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