Mtop — мониторинг MySQL server для CentOS6

Для  CentOS 6 64-Bit

Устанавливаем сторонний репозитарий RPMforge 
# wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
# rpm -Uvh rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm

Импортируем ключ RPMForge  для CentOS 6

# wget http://dag.wieers.com/rpm/packages/RPM-GPG-KEY.dag.txt
# rpm --import RPM-GPG-KEY.dag.txt

Устанавливаем

yum install mtop
Подключаемся к серверу MySQL

mysql -u root -p

Для mysqltop даем привилегии grant privileges

mysql> grant super, reload, process on *.* to mysqltop;
Query OK, 0 rows affected (0.00 sec)

mysql> grant super, reload, process on *.* to mysqltop@localhost;
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

Запускаем программу мониторим

mtop

Дополнительные функции

1. s – change the number of seconds to delay between updates
2. m – toggle manual refresh mode on/off
3. d – filter display with regular expression (user/host/db/command/state/info)
4. F – fold/unfold column names in select statement display
5. h – display process for only one host
6. u – display process for only one user
7. i – toggle all/non-Sleeping process display
8. o – reverse the sort order
9. q – quit
10. ? – help