www.mysqlperformanceblog.com Tutorials

Fixing column encoding mess in MySQL
Just had an interesting issue with an encoding mess on a column containing non-ASCII text. The solution was not immediately obvious so I decided it's worth sharing.

How fast can you sort data with MySQL?
See how much MySQL can sort 1.000.000 rows, or rather return top 10 rows from sorted result set which is the most typical way sorting is used in practice.

Debugging sleeping connections with MySQL
Have you ever seen connection in the SHOW PROCESSLIST output which is in "Sleep" state for a long time and you have no idea why this would happen?