Welcome to WebmasterWorld Guest from 54.226.60.235

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)



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 phranque is a WebmasterWorld Top Contributor of All Time 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]
 

Featured Threads

Hot Threads This Week

Hot Threads This Month