Please enter a valid email address. The download links will be emailed to you.
The download links for
MONyog have been sent to
Back to Topics

Default Dashboards

The Dashboard is a page displaying a graphical view of the server parameters and metrics that in most situations will give you a quick overview of the server load and performance. Monyog ships with a default dashboard called "Performance metrics" which includes the metrics:

MySQL metrics:

  • Connections
  • Cache misses
  • Statements
  • Database Throughputs

System metrics:

  • Disk IO
  • CPU usage

image

How is the refresh interval defined?

Every graph displays related metrics using different colors. In the Charts interface the X-axis timestamps are not printed, and the time interval between each will reflect the server-specific setting for the sample interval. For that reason the display for different servers cannot be compared if this setting is different. Even the time-interval between the plotted values may vary for a single server if less than 15 samples are available since the sample interval was changed for that server. If no data are available for a period because MONyog service was stopped, two empty sample points will display in the grid no matter how long time has passed.

Adding Dashboards

Just click on the drop down menu containing the Dashboard names, and select the "Add New Dashboard" option. This will open the page where you can give a suitable dashboard name and decide the charts which will be enabled for your dashboard.

Dashboards settings

Dahboard settings can be changed from the dashboard page itself. These are local (browser specific) settings that are stored in a cookie.

  • Chart's size is configurable, you can stretch/reduce the charts size.
  • You can hover on the anchor points on the charts to see the actual values.
  • You can also customize the look of charts by clicking 'Chart color settings' where you can change the colors to your choice. Refer to Chart Color Settings.
  • You can rename the dashboard name, add/remove charts to the dashboard. You can delete the dashboard from the dashboard name drop down menu.

image

Charts recommendation

Recommended number of collections is 50 for better visibility.

Note

This recommendation is based on 1280 x 1024 screen resolution. So, depending upon your screen resolution the number of collections may vary to some extent.

Even the Charts is configurable.

You can customize the Charts page to include other counters/metrics as well. Just edit the 'Chartsmysqlcounters' and 'Chartssystemcounters' JavaScript files. You can also choose to display only a single line (or any combination of lines) in a multi-line chart just by clicking on the buttons in the legend. For example in Connection history, if we want to view only refused connections we can disable 'attempts' or 'terminated abruptly' buttons. In this we can customize Cache hit rate and others to avoid confusions.

Also, charts can now be exported as PDF/JPG/PNG formats. Refer " Exporting graphics".

Note

This feature is available in MONyog Professional, Enterprise and Ultimate.