live MySQL queries

On your mysql console…

mysql> SHOW VARIABLES LIKE "general_log%";

+------------------+----------------------------+
| Variable_name    | Value                      |
+------------------+----------------------------+
| general_log      | OFF                        |
| general_log_file | /var/run/mysqld/mysqld.log |
+------------------+----------------------------+

mysql> SET GLOBAL general_log = 'ON';

Then!

tail -f -n200 /var/run/mysqld/mysqld.log

 

After debugging… don’t forget to turn it OFF!

mysql> SET GLOBAL general_log = 'OFF';

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.