Track Configuration changes

Track Configuration Changes is version control for your MySQL server’s Global Variables. MONyog will track changes to global configuration no matter if the configuration parameters were specified in my.ini/my.cnf, are server defaults or if somebody with

SUPER privilege has executed a SET GLOBAL statement. So if you notice your MySQL server’s performance degraded from the last time you checked, you can track and compare changes in the configuration file to determine whether a change in the Global Variables

has brought about this degradation.

To view data for a server, select the server from the drop-down menu and click on ‘Analyze’. All timestamps when changes were detected are listed on the left pane.

‘Change timeframe’ allows you to change the time-frame from which changes to the configuration are displayed. To track changes between two timestamps select the original timestamp on the left pane. Next select the timestamp to compare with from the drop-down menu on the top right corner of the screen and click ‘Compare’.  Checking on ‘Show only changed values’ will hide all values which haven’t changed between the two timestamps.