Hi,
You can only set this parameters in order to monitoring slow queries:
long_query_time = 120 ( example of 2 minutes)
#log-long-format
#log-slow-queries=/var/log/slow-queries.log
You can enable and disable using " # "
You set :
log=ON
log_slow_queries = ON
log_slow_queries=/var/log/slow-q
Hi , Everyone :: I need your help.
I have problem about mysql.
it about log_slow_queries
this is my.cnf file
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords=1
#skip-networking
skip-innodb
skip-bdb
skip-name-resolve
skip-locking
skip-character-set-clie