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<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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
