Hi Rafal, If there are more slow queries in your server and logging them into a table will increase the IO of the server. It is better to be in a file. The slow query log file can be processed easily by pt-query-digest<http://www.percona.com/doc/percona-toolkit/2.1/pt-query-digest.html> .
Regards, KarthiK.P.R MySQL DBA On Fri, May 11, 2012 at 2:47 PM, Nilnandan Joshi <nilnan...@gmail.com>wrote: > Hi Rafal, > > If you are using MySQL 5.1 and later version than you can enable the log > tables and you can see slow queries in the log tables. > Please check this post: > http://nilinfobin.com/2012/03/slow_log-and-general_log-tables-in-mysql-5-1/ > > regards, > Nilnandan > > On Fri, May 11, 2012 at 2:40 PM, Rafał Radecki <radecki.ra...@gmail.com > >wrote: > > > Hi all. > > > > Is there a possibility to see the info from slowlog somewhere in > database? > > I would like to see slow queries using mysql and not by watching the log > > file. > > I've searched on google and mysql website but hasn't found the solution. > > > > Best regards, > > Rafal Radecki. > > >
