List:General Discussion« Previous MessageNext Message »
From:David Lerer Date:May 14 2012 1:11pm
Subject:RE: MySQL slowlog - only in file?
View as plain text  
Alternatively, you could use MySQL Enterprise Monitor (Oracle) and capture the queries for
very easy analysis. 
I have found it very effective, especially when you have  very high number of queries per
second.
I have not noticed any impact on database performance. 
David.

-----Original Message-----
From: Carsten Pedersen [mailto:carsten@stripped] 
Sent: Monday, May 14, 2012 6:16 AM
To: P.R.Karthik
Cc: Nilnandan Joshi; Rafał Radecki; mysql@stripped
Subject: Re: MySQL slowlog - only in file?

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.
>>>
>>
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql


The information contained in this e-mail and any attached 
documents may be privileged, confidential and protected from 
disclosure.  If you are not the intended recipient you may not 
read, copy, distribute or use this information.  If you have 
received this communication in error, please notify the sender 
immediately by replying to this message and then delete it 
from your system.
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