Re: Log Mysql slow query into table

2010-11-30 Thread Wagner Bianchi
Have a look on it: mysql> show variables like '%slow%'; +-+--+ | Variable_name | Value| +-+--+ | log_slow_queries| OFF | | slow_launch_time

Log Mysql slow query into table

2010-11-30 Thread Cool Cool
Hi, I am trying to log slow queries into both file and table. I had set as > SET GLOBAL log_output =`TABLE,FILE`; But it isnt getting logged into tables. Can I know if I need to create table or am I missing anything ? Thanks. Regards, Ram