Welcome to WebmasterWorld Guest from 54.204.92.234

Forum Moderators: open

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

   
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.
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