Re: Getting list of Query which are all not using Index
Posted by: Rick James
Date: April 13, 2016 06:10PM

Furthermore, use one of these to summarize the slowlog:
mysqldumpslow -s t
pt-query-digest

They will put the "worst" query first. Often, fixing the first 2-3 are enough to improve the system noticeably.

I like long_query_time=1 .

Options: ReplyQuote


Subject
Written By
Posted
Re: Getting list of Query which are all not using Index
April 13, 2016 06:10PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.