MySQL Forums
Forum List  »  MySQL Administrator

scheduling SHOW ENGINE INNODB STATUS
Posted by: MySQL New DBA
Date: October 21, 2011 02:44PM

Hi

This is regarding collection of Innodb health report at regular intervals.

From the documentation regarding enabling Innodb monitors, I can see "output generation does result in some performance decrement"
http://dev.mysql.com/doc/refman/5.5/en/innodb-monitors.html

Do you think there can be the same performance decrement if we don't enable the Innodb monitors (by not creating the monitor tables), and just get the output of SHOW ENGINE INNODB STATUS into a file at regular schedules.
The purpose is to have regular snapshot information which can be used for analysis and comparison later when required. Just like we have in oracle with snapshot and AWR reports.

Thanks

Options: ReplyQuote


Subject
Written By
Posted
scheduling SHOW ENGINE INNODB STATUS
October 21, 2011 02:44PM


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.