Last year, I made the first post in a small series, which aimed
to highlight unique features of Percona Server for MySQL, by
discussing binlog_space_limit
option.
Today, I am going to discuss another important type of log available in MySQL that is enhanced in Percona Server for MySQL – the slow query log. The reason why I am doing this is that although this extension has existed since the very early times of versions 5.1 (over 10 years ago!), many people are still unaware of it, which I see from time to time when working with Support customers.
Default Slow Log Inadequacy
How many times have you been wondering why, whilst reviewing slow query logs, the very same query occasionally runs way slower than usual? There may be many reasons for that, but the standard slow …
[Read more]