Author - Muhammad Irfan

MySQL Slow Query Log: Tools and Tips

MySQL Slow Query Log

MySQL has a nice feature: MySQL slow query log, which allows you to log all queries that exceed a predefined about of time to execute. Peter Zaitsev first wrote about this back in 2006 – there have been a few other posts here on the MySQL Performance Blog since then (check this and this, […]

Read more

[ERROR] mysqld: Sort aborted: Server shutdown in progress

Recently, one of our support customers faced this: “[ERROR] mysqld: Sort aborted: Server shutdown in progress.” At first it would appear this occurred because of a mysql restart (i.e. the MySQL server restarted and the query got killed during the stopping of mysql). However, while debugging this problem I found no evidence of a […]

Read more

MySQL Error: Too many connections

MySQL Error: Too many connections

Editor’s Note: Follow up to this post here MySQL 5.7 Performance Tuning After Installation.
We have always received quite a few questions here at wait_timeout is an important parameter to tune and discard unused or idle connections to minimize the number of active connections to your MySQL server – and this will ultimately help to […]

Read more

InnoDB Performance Optimization Basics

InnoDB Performance Optimization

I recently stumbled upon a post that Peter Zaitsev published back in 2007 titled “blog post to see how EXT4 can outperform XFS. You can use noatime and nodiratime options if you’re using innodb_file_per_table and a lot of tables though benefit of these is minor. The default I/O scheduler in Linux is Completely Fair […]

Read more

Crash-resistant replication: How to avoid MySQL replication errors

Percona Server’s “crash-resistant replication” feature is useful in versions 5.1 through 5.5. However, in Percona Server 5.6 it’s replaced with Oracle MySQL 5.6’s “crash safe replication” feature, which has it’s own implementation (you can read more about it here).
A MySQL slave normally stores its position in files master.info and relay-log.info which are updated by […]

Read more