List:General Discussion« Previous MessageNext Message »
From:P.R.Karthik Date:May 14 2012 7:34am
Subject:Re: MySQL slowlog - only in file?
View as plain text  
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 <nilnandan@stripped>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.rafal@stripped
> >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.
> >
>

Thread
MySQL slowlog - only in file?Rafał Radecki11 May
  • Re: MySQL slowlog - only in file?Nilnandan Joshi11 May
    • Re: MySQL slowlog - only in file?P.R.Karthik14 May
      • Re: MySQL slowlog - only in file?Carsten Pedersen14 May
        • RE: MySQL slowlog - only in file?David Lerer14 May
          • RE: MySQL slowlog - only in file?David Lerer14 May