NAME
mytop – display MySQL server performance info like ‘top’

SYNOPSIS

mytop [options]

EXAMPLE

mytop -u mysqluser -p mysqlpassword -d database

ERRORS on RHEL or CentOS
Mytop has started to break on RHEL or CentOS. It appears that some of the perl modules have change.d
There error is:

#mytop
Error in option spec: “long|!”

The fix for this is to edit the mytop script and comment out the line containing long|!

nano /usr/bin/mytop

Run a search for long|! and comment out the following line:

“long|!” => $config{long_nums},

Start mytop and you should be fine!

Reference: eth0.us