MySQL Forums
Forum List  »  InnoDB

Re: Information on Analyze and Optimize
Posted by: Peter Brawley
Date: October 18, 2019 09:23AM

Some options ...

If binary logging is enabled, grep -i "analyze table" against binary log output from mysqlbinlog.

Likewise for the general log.

Write an sproc that calls check or analyse then logs the timestamp and perhaps the result.

Options: ReplyQuote


Subject
Views
Written By
Posted
1063
October 14, 2019 04:46AM
Re: Information on Analyze and Optimize
529
October 18, 2019 09:23AM


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.