MySQL Forums
Forum List  »  InnoDB

Re: updated statistics
Posted by: Rick James
Date: February 04, 2015 06:47PM

Older versions of MySQL: When a query suddenly performs worse than before, you can _suspect_ that ANALYZE is needed. There is no other way to know.

Newer versions: You should never need to use ANALYZE.

I have studied thousands of slow queries; very few really need ANALYZE -- usually something else (new index, compound index, rephrasing the query, etc) is the best cure for the performance issue.

Options: ReplyQuote


Subject
Views
Written By
Posted
1581
February 02, 2015 11:57PM
925
February 02, 2015 11:59PM
Re: updated statistics
909
February 04, 2015 06:47PM


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.