EmergencyEMERGENCY? Get 24/7 Help Now!

Which Linux distribution for a MySQL database server? A specific point of view.

 | December 8, 2011 |  Posted In: Insight for DBAs, MySQL

One of the more common questions I get asked is which Linux distribution I would use for a MySQL database server. Bearing the responsibility for someone else’s success means I should advise something that is stable, reliable, easy to manage and has plenty of resources available online. It should also allow running MySQL without too […]

Read More

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


 | 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

Poor man’s query logging

 | November 7, 2008 |  Posted In: Insight for DBAs

Occasionally there is a need to see what queries reach MySQL. The database provides several ways to share that information with you. One is called general log activated with


in MySQL 5.1+) start-up parameter. The log writes any query being executed by MySQL to a file with limited amount of additional information. […]

Read More

Living with backups

 | November 6, 2008 |  Posted In: Insight for DBAs

Everyone does backups. Usually it’s some nightly batch job that just dumps all MySQL tables into a text file or ordinarily copies the binary files from the data directory to a safe location. Obviously both ways involve much more complex operations than it would seem by my last sentence, but it is not important right […]

Read More

A quest for the full InnoDB status

 | October 31, 2008 |  Posted In: Insight for DBAs

When running InnoDB you are able to dig into the engine internals, look at various gauges and counters, see past deadlocks and the list of all open transactions. This is in your reach with one simple command —

. On most occasions it works beautifully. The problems appear when you have a large spike in […]

Read More

MySQL extensions for hosting

 | April 24, 2008 |  Posted In: Percona Software

A few weeks ago I was asked to isolate some functionalities from Mark Callaghan’s MySQL patch bundle. They were extensions adding per-user and per-table accounting to the database, accessible with a new set of commands such as SHOW TABLE_STATISTICS, SHOW INDEX_STATISTICS and SHOW USER_STATISTICS. The first two can interest anyone to periodically check what data […]

Read More