Friday, May 3, 2013

MySQL Query Logging

Needed to log some queries today in MySQL.
Here is the long and the short of it....(more info)


set global log_queries_not_using_indexes = 'ON';
SET GLOBAL general_log = 'ON';
SET GLOBAL log_slow_queries = 'ON';
set global long_query_time= 1;

Now check your settings...