Need for Speed: MySQL Indexing

Best Practices for Businesses
12 November 5:00pm - 5:50pm @ Orchard 2
Experience level: 
Intermediate
Duration: 
50 minutes conference
Database Performance is what everybody is asking for. Often we expect that some changes in the database configuration is the solution for our problem. But typically it is not. Very often (in most of the cases) the problem is missing indexes. In this talk we will have a look at Indexes, how they are used and how they should not be used. We take over the role of a MySQL Optimizer to understand why an index is good or why it is not so good. We will further have a look how indexes influence locality of data and how we can improve the locality of data to achieve much better performance. After this talk you should have an idea about how you solve your MySQL indexing problem to achieve a better over-all MySQL performance...


Speakers

CTO, FromDual GmbH

Slides