MySQL Performance Blog

26th of September, just after HighLoad conference I will have full day MySQL master class.

This time we will talk about Innodb Architecture and Performance Optimization and when will discuss some MySQL Performance Optimization and Scaling case studies from audience (or some of from my MySQL Consulting Practice if there would not be enough of them). As usually I’ll try to keep it very interactive and will try to answer any other MySQL Performance, Scaling and High Availability questions you might have.

Every so often you need to perform sort results retrieved from MySQL when your WHERE clause goes beyound col=const values which would allow MySQL to still use second portion of the index for the order by. Ranges as well as IN lists make this optimization impossible, not even speaking about index merge optimization. Lets look at this example:
[read more...]