MySQL sar is a simple monitoring service for MySQL database server, like sysstat for system resources. It helps system administrators to easily monitor queries per second and slow queries of MySQL server, by checking MySQL server status every 5 minutes, storing data it in a sqlite database. MySQL sar displays data in sar-like format.
What's New in This Release: [ read full changelog ]
· MySQLsar is now tested with RHEL 5.3 , Ubuntu 9.04 ... It should work on any Linux distro with LSB version 3.1 or newer ..
· Revision 3 is now tagged as version-1.0.
To install it:
· 1- Browse the code, go to revision 3, download mysqlsar file ...
· 3- Copy the file as /etc/init.d/mysqlsar , chmod 700 mysqlsar
· 4- Turn the service on, then run /etc/init.d/mysqlsar start
· 5- It will ask you to set the DB variable, open the file, uncomment line "#DB=/var/log/MySQLsar.db" , and change its path as you like
· 6- You should be able to use it now ...