Logging queries in mysql

A nice simple way to log all the queries being run…

From the mysql command line type these.

1) execute “SET GLOBAL log_output = ‘TABLE’;”
2) execute “SET GLOBAL general_log = ‘ON’;”
3) take a look at the table mysql.general_log 

It’s basically telling mysql to log all it’s queries to a system table, easy!