Tuesday, December 5, 2006

MySQL Slow Query Logging

by damonp on December 5, 2006

in Snippets,SQL,SysAdmin

Add to /etc/my.cnf under [mysqld] stanza

MySQL5

log_slow_queries  = /var/log/mysqld-slow.log
long_query_time   = 1

MySQL3, MySQL4

log-slow-queries=/var/log/mysqld-slow.log
set-variable    = long_query_time=1

Popularity: 1%

{ 0 comments }