Deprecated: Assigning the return value of new by reference is deprecated in /home/therning/public_html/niklas/wp-settings.php on line 472

Deprecated: Assigning the return value of new by reference is deprecated in /home/therning/public_html/niklas/wp-settings.php on line 487

Deprecated: Assigning the return value of new by reference is deprecated in /home/therning/public_html/niklas/wp-settings.php on line 494

Deprecated: Assigning the return value of new by reference is deprecated in /home/therning/public_html/niklas/wp-settings.php on line 530

Deprecated: Assigning the return value of new by reference is deprecated in /home/therning/public_html/niklas/wp-includes/cache.php on line 103

Deprecated: Assigning the return value of new by reference is deprecated in /home/therning/public_html/niklas/wp-includes/query.php on line 21

Deprecated: Assigning the return value of new by reference is deprecated in /home/therning/public_html/niklas/wp-includes/theme.php on line 623
Niklas blog » Blog Archive » Debugging MySQL queries

Niklas blog

Just another WordPress weblog

Debugging MySQL queries

December 11th, 2009 in mysql

Here’s how to temporarily enable logging of all statements sent to MySQL:

set global general_log_file='/tmp/queries.log';
set global general_log=1;

This will log all queries to /tmp/queries.log. To disable logging do:

set global general_log=0;

NOTE: This only works in MySQL 5.1+.

Tags: ,

Comments are closed.