4th Moscow MUG Meeting - Designing Indices, 29.11

November 29, Thursday, at 19-00 with the support of the club " Business in RU style "
The 4th meeting of the Moscow MySQL User Group will be held

Meeting topic: Index Design

The meeting will be held by Ruslan Zakirov ,
Leading Developer at Best Practical Solutions
which develops open products
Request Tracker, SVK, Jifty, and also the HiveMinder.com service
')
Meeting plan

1. General principles of the device indexes.

2. Job query scheduler:
- as planned request
- how to perform
- where in this scheme are the indices, how many are there.

3. Consider the plans under the magnifying glass using EXPLAIN:
- when to read it
- how to read it, what to look at
- how to change it using indexes
- how to change it using additional directives
- and why it is needed.

4. Examples:
Everywhere there will be examples, but in more detail we will focus on the queries that were at the last meeting in the report and squeeze all the juice out of them, and there will be several examples to demonstrate various effects and decomposition methods in order to increase the efficiency of using indexes.

To get to the seminar, register here.

Address: Moscow, Myasnitskaya, 20, HSE , Auditorium 116