EmergencyEMERGENCY? Get 24/7 Help Now!

Joining on range? Wrong!

 | May 17, 2010 |  Posted In: Insight for Developers, MySQL

The problem I am going to describe is likely to be around since the very beginning of MySQL, however unless you carefully analyse and profile your queries, it might easily go unnoticed. I used it as one of the examples in our talk given at phpDay.it conference last week to demonstrate some pitfalls one may […]

Read More

Slow DROP TABLE

 | June 16, 2009 |  Posted In: Insight for DBAs

It is a known fact that ext3 is not the most efficient file system out there and for example file removals can be painfully slow and cause a lot of random I/O. However, as it turns out, it can sometimes have a much more severe impact on the MySQL performance that it would seem. When […]

Read More