Is there any way to find out non index query from mysql slow log - Databases forum at WebmasterWorld - WebmasterWorld

Forum Moderators: open

Message Too Old, No Replies

Is there any way to find out non index query from mysql slow log

Is there any way to find out non index query from mysql slow log

chandrashekhard

2:20 pm on Jun 13, 2012 (gmt 0)

10+ Year Member

Is there any way to find out non index query from mysql slow log
I tried pt-query-digest pt-index-usage but not get any thing for this.

phranque

3:17 am on Jun 14, 2012 (gmt 0)

WebmasterWorld Administrator

10+ Year Member

Top Contributors Of The Month

welcome to WebmasterWorld, chandrashekhard!

perhaps this resource would be helpful - Optimizing Queries with EXPLAIN:
http://dev.mysql.com/doc/refman/5.0/en/using-explain.html [dev.mysql.com]