Tag - Muhammad Irfan

MySQL Upgrade Best Practices

MySQL upgrade best practices

MySQL upgrades are necessary tasks and we field a variety of questions here at Percona Support regarding MySQL upgrade best practices. This post highlights the recommended ways to upgrade MySQL in different scenarios.
Why are MySQL upgrades needed? The reasons are many and include Access to new features, performance benefits, bug fixes… However, MySQL upgrades […]

Read more

MySQL 101: Monitor Disk I/O with pt-diskstats

Here on the iostat is one of the popular tools and pt-diskstats tool for this purpose. The pt-diskstats tool is similar to iostat but it’s more interactive and contains extended information. pt-diskstats reports current disk activity and shows the statistics for the last second (which by default is 1 second) and will continue until […]

Read more

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