Page History

...

SQL DM for MySQL concerns itself with answering the following question:

• Was your MySQL down in the last one month?

• When did your MySQL traffic peak in the last few days?

And these are the few instances where we can find the answers for the following questions:

• When replication slave went down?
• Whether their was a hacking attempt?
• Which counters do you want to analyze?
• What time period do you want to analyze?

Answering the question will thus become becomes a matter of comparing different results and of analyzing their differences.

...

Current Trend Graph

With the ‘Current’ Current time-frame selected, the “Trend graph” Trend graph icon is present just beside the monitor name. On When clicking, it will display displays the trend graph of last 1 hour duration for the selected servers in the Monitors page. The selected servers list is displayed on the right hand side, the servers can be selected /or unselected by clicking on the server name.the server name.

Image Added

Historical Trend Graph

This is similar to the Current trend graph, the difference being that you can select any desired time-frame for which you want to see the graph for. You can choose the time-frame as History and then click the Trend Graph icon beside the counter name to see the graph. Along with the graph, it also shows the values of the monitor in the tabular form. Enable the option Show Only Changed Values to check when the monitor value was changed.

Image Added