Friday, March 8, 2013

LOG setting in mysql

vi /etc/my.cnf

#general Query
log=mysql-general.log


#slow Query
slow-query-log = 1
long_query_time = 1
log_slow_queries = mysql-slow.log


restart mysql





No comments:

Post a Comment