Remotely monitoring MySql databases with Mytop and Terminator

21 10 2008

When finding yourself maintaining Mysql servers within a cluster, network, or even further spread out, it becomes very handy, for monitoring purposes, to take a peak at the activities of Mysql.

A very useful little tool that helps doing this, is MyTop

mytop is a console-based (non-gui) tool for monitoring the threads and overall performance of a MySQL 3.22.x, 3.23.x, and 4.x server. It runs on most Unix systems (including Mac OS X) which have Perl, DBI, and Term::ReadKey installed. And with Term::ANSIColor installed you even get color. If you install Time::HiRes, you’ll get good real-time queries/second stats. As of version 0.7, it even runs on Windows (somewhat).

The source can be found on the official page. For ubuntu, the package is in the repositories, and this is the case we’ll be talking about.

Read the rest of this entry »