http://jeremy.zawodny.com/mysql/mytop/
innotop
https://www.xaprb.com/blog/2006/07/02/innotop-mysql-innodb-monitor/
https://bobcares.com/blog/fix-mysql-high-cpu-usage/
http://serverfault.com/questions/686665/mysql-showing-100-cpu-usage
https://www.serverdensity.com/monitor/mysql/how-to/
http://blog.codenode.com/2015/01/hack-mysql-has-been-retired.html
https://www.mysql.com/products/enterprise/monitor.html
https://www.digitalocean.com/community/tutorials/how-to-use-mytop-to-monitor-mysql-performance
http://www.codero.com/knowledge-base/content/8/319/en/how-to-install-mytop-for-database-performance-monitoring.html
https://www.tecmint.com/mytop-mysql-database-monitoring-in-rhel-centos-fedora/
https://www.howtoforge.com/tutorial/mytop-mysql-database-monitoring/
https://www.servernoobs.com/how-to-install-mytop-1-9-on-cpanel/
https://www.vultr.com/docs/using-mytop-to-monitor-mysql-performance
http://www.sohailriaz.com/how-to-install-mytop-a-top-clone-for-mysql/
http://www.tutorialspoint.com/articles/how-to-monitor-mysql-performance-using-mytop-on-centos-7
SHOW ENGINE INNODB STATUS
show table status like 'air_schedule_price';
Please also ask them if hang is still repeatable to attach gdb to running mysqld process, then run `thread apply all bt full`, so we can see what going on.
