List:General Discussion« Previous MessageNext Message »
From:Carsten Pedersen Date:May 14 2012 10:15am
Subject:Re: MySQL slowlog - only in file?
View as plain text  
Alternatively, you can copy the data into another table easily: 
http://www.bitbybit.dk/carsten/blog/?p=115

Best,

/ Carsten

On 14.05.2012 09:34, P.R.Karthik wrote:
> 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