Welcome to WebmasterWorld Guest from 54.198.229.157

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:10553
votes: 13


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]