The options here provide you to set threshold for the Disk space available to Monyog,choose the server selector behavior in Monyog, change the port for Monyog GUI. You can also change the settings for MySQL warmup time,exporting CSV files, maximum query length fetched by Monyog and the colors of the charts displayed in Monyog.
SERVER SELECTOR TYPE
There are two options to switch between the behaviour of Server Selector:
- Same servers across all tabs : If you enable this option, a server selected on one page will make it the default selected server selected across all pages in Monyog (excluding the Overview page). The Overview page will have its own separate server selector applicable only for the page.
- Keep them separate : This is the default selected option. If you enable this option, a server selected on one page will make it selected only for that page, i.e, each of the pages in Monyog will have its own server selector.
Monyog Disk Monitoring
Low disk space is a critical factor for any application. It can cause the application to perform poorly and make it difficult/unable to install the software upgrades.
Monyog sends SNMP trap/email alerts to all the email-ids if the disk space where Monyog is installed/running is running out. User can free up some disk space before the system goes out of space and shuts down. Thus maintaining high-availability of Monyog.
How to monitor disk space with Monyog?
To monitor the disk space, you will need to set the threshold for the free disk space. Monyog will send email to IDs mentioned under the notification settings of all servers. Alerts will also be sent to email IDs provided in the SMTP settings.
The threshold limit set denotes is for the disk space available in the Data directory of Monyog. In case the installation directory and data directory are stored in different locations, Monyog will alert if the space available to the Installation directory gets below 500MB.
Monyog will monitor the disk space on a 5-minute interval in stable conditions and 1-minute interval when the disk space goes below the threshold value.
The alert notifications will be sent every 6 Hours if the disk space remains below the threshold value.
Using the Change port option, you can change the Monyog webserver port. By using this option, you can define on which port the Monyog (web) server will listen. This port must be specified when connecting to Monyog from a browser.
Users can change the port from General > PORT. Once the port is changed, the user should restart the Monyog service for it to take effect.
MySQL Warmup Period
Using the Change MySQL Warmup Time option, you can change the warm-up time for MySQL servers. Some alerts and advisors are only applicable if the server is running for a minimum period of time.
How To Change?
- Users can change the MySQL Warmup Time time by using the user settings screen, choose General > MySQL Warmup Period.
- The drop down can be used to display options like seconds, minutes, hours, days etc.
Use this option to define the field delimiter for CSV export.
How To Change?
Users can change the CSV export settings by using General > CSV EXPORT. You can define the field delimiter for exporting as CSV and the default is set to comma " , " but you can ofcourse specify any other delimiters if you need.
Maximum Query Length
Settings -> Maximum Query Length defines the maximum query length displayed.
Default is 10000 characters and max Value is 64000 characters.
Note: The maximum query length setting here applies to queries fetched in processlist mode. In Performance Schema mode, the maximum query length is defined by the MySQL global variable performance_schema_max_digest_length. The default value is 1024 bytes and the maximum value allowed is 1048576.
This variable was added in MySQL 5.7.8. In MySQL 5.7.6 and 5.7.7, use max_digest_length instead. Before 5.7.6, the value cannot be changed.
Using this option, you can set chart colors of your choice.