Alternatively, you can copy the data into another table easily:
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
> 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:
>> On Fri, May 11, 2012 at 2:40 PM, Rafał Radecki<radecki.rafal@stripped
>>> Hi all.
>>> Is there a possibility to see the info from slowlog somewhere in
>>> I would like to see slow queries using mysql and not by watching the log
>>> I've searched on google and mysql website but hasn't found the solution.
>>> Best regards,
>>> Rafal Radecki.