Monday, April 23, 2007

mysql 5.1 SHOW PROCESS LIST AND slow query log

Oooh in 5.1 these are now system tables. Why should you care? The slow query log requires a full restart of mysql in previous versions of mysql. Now it's just a flag that can be turned on and queried against from the CSV storage engine.

1 comment:

veganloveburger said...

Awesome, I'd love to only write & sample the slow query log occaisionally.