Main menu:

Site search

Categories

Archive

Archive for March, 2008

Logging long running queries in mysql

Here is another nugget from the mysql world. Mysql has a built in logger for tracking down those queries that are long running queries. Technically mysql likes to call them “slow queries” 1. Login to your server as root 2. Open my.cnf with your favorite editor. Example: 3. Into the [mysqld] section add the fallowing [...]