monitoring mysql

monitoring mysql database

mysql> SET GLOBAL general_log_file = '/mysql/log/all_queries.log';
mysql> SET GLOBAL general_log = 'ON';
mysql> SET GLOBAL general_log = 'OFF';

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
bind-address = 10.14.23.185
server-id       = 1
log_bin         = /var/log/mysql/mysql_bin.log
binlog_do_db    = zabbix

slow_query_log_file  = /var/lib/mysql/mysql-slow.log
long_query_time = 5
slow_query_log = 1

[client]
user=root
host=localhost
password=