HostsVault BlogHostsVault Blog

MySQL is a widely used multi-threaded, multi-user RDBMS in the Linux world its intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.

However sometimes specially in the shared environment its the sole purpose of overload in the server

Here is a how-to to install mytop (top version for MySQL) which will help you identify a user query that’s taking long time or user opening to much connections to the server so it can help you maintain stability on your server.

First install TermReadKey:

cd /usr/local/src
wget http://search.cpan.org/CPAN/authors/id/J/JS/JSTOWE/TermReadKey-2.30.tar.gz
tar -zxf TermReadKey-2.30.tar.gz
cd TermRead*
perl Makefile.PL
make test
make
make install
cd ..

Then install DBI:

wget http://search.cpan.org/CPAN/authors/id/T/TI/TIMB/DBI-1.48.tar.gz
tar -zxf DBI-1.48.tar.gz
cd DBI*
perl Makefile.PL
make test
make
make install
cd ..

And finally our beloved MyTop

wget http://jeremy.zawodny.com/mysql/mytop/mytop-1.4.tar.gz
tar -zxf mytop-1.4.tar.gz
cd mytop*
perl Makefile.PL
make test
make
make install

Then by running mytop it will bring up a page similar to this :