Why Index could refuse to work ?

Have you ever seen index which refused to be used even if there is every reason for it to work (from the glance view):

Shell

mysql> explain select * from article where article_id=10;
+—-+————-+———+——+—————+——+———+——+——-+————-+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | […]

Read more

MySQL ORDER BY LIMIT Performance Optimization

Suboptimal MySQL ORDER BY  implementation, especially together with LIMIT is often the cause of MySQL performance problems.
Here is what you need to know about MySQL ORDER BY LIMIT optimization to avoid these problems.
MySQL ORDER BY with LIMIT is most common use of ORDER BY in interactive applications with large data sets being sorted. On many […]

Read more

MySQL wins C’T Database Contest

Today MySQL published the press release with results of Database Contest (results on German available here http://www.mysql.de/ct-dbcontest).
Peter and me spent quite some time working on this project while being employed by MySQL and it is great to see results finally publicly available.
The story began about year ago when C’T magazine had called for Database […]

Read more