Lilypie - Personal pictureLilypie

Log Slow Queries in MySQL

Posted by cikul on Sunday, June 1st 2008   

Digg it

Bookmark it

Stumble it

Email to friend

1
Jun

logged slow queries by MySQL Server and you can optimize them.

# touch /var/log/slow-queries.log
# chmod 644 /var/log/slow-queries.log


Edit your /etc/my.cnf and under [mysqld] add following lines.

[mysqld]
…
log-slow-queries = /var/log/slow-queries.log

# /scripts/restartsrv_mysql

Related Content

Subscribe to the post comments feeds or Leave a trackback

Filed under: Linux     
No Comment Yet   

Be The First To Comment

Related Post

Please Leave Your Comments Below

Please Note: All comments will be moderated

«
»