We can monitor mysql queries and database using an utility called MonYog. MONyog is a monitoring and advisory tool for MySQL Community as well as Enterprise versions.MONyog is agent-less, and does not require anything to be installed on the MySQL servers. MONyog helps monitor enterprise database environments.
MONyog MySQL Monitor and Advisor MySQL DBAs manage more MySQL servers,and tune their MySQL servers.
To install monyog get the rpm / tar.gz package
# rpm -ivh monyog.version.rpm
# service monyog start / stop
or
# tar -xvf monyog.version.tar.gz
# cd monyog
# cd bin
# ./MoNyog start / stop
After installing, MONyog will be started automatically as a daemon/service. We can immediately start monitoring your MySQL servers by pointing your browser to:
http://<YOUR_HOST>:5555
After getting the GUI interface perform some more steps to get the desired data’s into the interface.
You have to set the username and password for the interface.
Name for the new Host that need to add the interface.
Mysql host, mysql host username and password.
Mysql connection interval
Enable query logs, error logs
Just go through the following screen shoots for more details
http://www.webyog.com/en/screenshots.php
To Enable mysql query logs you need to add some lines to your my.cnf file and restart.
To enable slow Query Log only
log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 1
To enable full Log Query
log=/var/log/mysqldquery.log
The above will log all queries to the log file.
Don’t forgot to restart mysql service after making changes in my.cnf file.
Recent Comments