Welcome to WebmasterWorld Guest from 54.146.230.254

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

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

New User

joined:June 7, 2012
posts: 3
votes: 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 June 14, 2012 (gmt 0)

Administrator

WebmasterWorld Administrator phranque is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Aug 10, 2004
posts:10550
votes: 10


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]
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members