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

Written By
October 14, 2019 04:46AM
Re: Information on Analyze and Optimize
October 18, 2019 09:23AM

Sorry, only registered users may post in this forum.

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.