MySQL Using mytop Debug Source of High IO and Slow Performance
mytop is one of my favorite tools and it is fairly simple aside from a few caveats and issues that persist to this day.
To install it on Centos:
yum -y install centos
Configure ~/.mytop
vi ~/.mytop
user=root
host=localhost
db=test
#port=3306
socket=/var/lib/mysql/mysql.sock
header=1
color=1
Try running it and see this error:
mytop --prompt
Error Fix:
vi /usr/bin/mytop
#comment this out:
#"long|!" => \$config{long_nums},
Once you do get it running it's very useful you can watch queries in real time and if there is a single database slowing you down it will become apparent by watching the queries. Even using slow queries cannot always find the cause because sometimes the query isn't technically slow but it is the iowait that doesn't allow the query to even start executing for a long time.
Tags:
mysql, mytop, debug, io, performancemytop, caveats, persist, install, centos, yum, configure, vi, user, localhost, db, socket, var, lib, header, prompt, usr, bin, quot, config, long_nums, queries, database, slowing, apparent, query, isn, iowait, doesn, executing,