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>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
> I've searched on google and mysql website but hasn't found the solution.
> Best regards,
> Rafal Radecki.