CodePuzzling::tumblr('!');

[MySQL] How to install mytop on CentOS 5.3

For the ones who don’t know what mytop is, it’s a simple perl script that shows mysql’s porcesses list (SHOW PROCESSLIST) like top does for system’s processes. First of all, let’s assure what distro you’re using by typing:

[root@localhost ~]# cat /etc/issue
CentOS release 5.3 (Final)
Kernel \r on an \m

Then let’s import GPG key:

rpm --import http://dries.ulyssis.org/rpm/RPM-GPG-KEY.dries.txt

Then we download mytop through rpm command (the link is shortened through bit.ly, if rpm doesn’t follow redirect, use normal url) and install via yum:

rpm -Uhv http://bit.ly/DVVs1
yum install rpm

Then you can use an alias in your bashrc file for not inserting all the times user and password:

vim ~/.bashrc
alias mytop='mytop -uuser -ppass'

.