EmergencyEMERGENCY? Get 24/7 Help Now!

Slow Query Log analyzes tools

 | September 6, 2006 |  Posted In: Insight for DBAs

(There is an updated version of this post here). MySQL has simple but quite handy feature – slow query log, which allows you to log all queries which took over define number of seconds to execute. There is also an option to enable logging queries which do not use indexes even if they take less […]

Read More

Joining Peter for MySQL Consulting

 | September 4, 2006 |  Posted In: Events and Announcements

Starting September I’m leaving MySQL to partner with Peter on practice as well as work with him on some Web projects. I really enjoyed working under Peter’s guidance while working for MySQL and it is great we now can work together as a partners. I thanks MySQL for two great years I had. I also […]

Read More

Even minor upgrades are not always safe

 | September 4, 2006 |  Posted In: Insight for DBAs

I already wrote couple of weeks ago I keep most of my systems on MySQL 4.1 still as they will not benefit from MySQL 5.0 features anyway while I do not want to likely loose a bit of performance and possibly deal with new bugs and changes introduced in MySQL 5.0 (You never know where […]

Read More

MySQL ORDER BY LIMIT Performance Optimization

 | September 1, 2006 |  Posted In: Insight for Developers

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