Presentation

Find all the service models dedicated to the monitoring of your MySQL Application.

Service Templates

BOX mode

MySQL-DB-Uptime

Duration since the last server restart (takes into account restarts and crashes). Alert if a threshold is exceeded. Configuration: MySQL supervision account, TCP port for connection to the MySQL server, thresholds expressed in seconds and respecting the nagios format:
XX: warning if above XX
XX: : alert if below XX
XX:YY: alert if not between XX and YY

Available from version
3.13

MySQL-Index-Usage

Collects the index usage rate of MySQL database queries. This control notifies when a threshold is exceeded. Configuration: account and password of a user with USER access to MySQL database, alert threshold, critical threshold. The alert threshold is higher than the critical threshold.

Available from version
3.13

MySQL-Long-Running-Procs

Collects the number of MySQL processes with execution times exceeding one minute. This control notifies when a threshold is exceeded. Configuration: account and password of a user with USER access to MySQL database, alert threshold, critical threshold.

Available from version
3.13

MySQL-Modified-Configuration

Verifies that the MySQL server configuration has not been changed. Alerts you when changes are made and specifies which directives have been modified. Configuration: MySQL monitoring account, MySQL server connection port, configuration checksum. The configuration is done in two steps. The checksum parameter is set to 0 to initialize the checksum. This returns the initial checksum corresponding to the current MySQL configuration. The checksum parameter is then set with the previously returned checksum.

Available from version
3.13

MySQL-Open-Connections

Collects the number of current connections to the MySQL database. This control notifies when a threshold is exceeded. Configuration: account and password of a user with USER access to the MySQL database, alert threshold, critical threshold.

Available from version
3.13

MySQL-Replication-Delay

Collects the replication time, in seconds, from the master MySQL server to the slave MySQL server. This control notifies when a threshold is exceeded. Configuration: account and password of a user with USER access to the MySQL database, alert threshold, critical threshold.

Available from version
3.13

MySQL-Slow-Queries

Collects the rate of queries classified as slow on the MySQL server. This control notifies when a threshold is exceeded. Configuration: account and password of a user with USER access to the MySQL database, alert threshold, critical threshold.

Available from version
3.13

MySQL-Table-Lock-Contention

Collects the lock rate of failed tables on the MySQL database. This control notifies when a threshold is exceeded. Configuration: account and password of a user with USER access to MySQL database, alert threshold, critical threshold.

Available from version
3.13

MySQL-Tmp-Disk-Tables

Collects the rate of temporary tables created on disk rather than in memory on the MySQL database. This control notifies when a threshold is exceeded. Configuration: account and password of a user with USER access to MySQL database, alert threshold, critical threshold.

Available from version
3.13

MySQL-DB-KeyCache-HitRate

Controls the use of the MyISAM table key cache. Measures the success rate and alerts if it is below a certain threshold. Configuration: MySQL supervision account, TCP port of connection to the server, percentage thresholds.

Available from version
3.13

MySQL-DB-LogWaits

Controls the number of times per second that the database waits for the InnoDB log to be written to disk. A too high value indicates that this log is too small. Alert when this value exceeds a threshold. Configuration: MySQL supervision account, TCP connection port, alert thresholds.

Available from version
3.13

MySQL-DB-OpenFiles

Controls the rate of open files against the maximum limit for the MySQL server. Alerts if this rate exceeds a threshold. Configuration: MySQL monitoring account, Connection port, thresholds as a percentage of the maximum limit.

Available from version
3.13

MySQL-DB-QueryCache-HitRate

Controls the use of the SQL query cache. Measures the success rate and alerts if it is below a threshold. Configuration: MySQL monitoring account, TCP port to connect to the server, percentage thresholds.

Available from version
3.13

MySQL-DB-QueryCache-LowMemoryPrunes

Measures the number of query/sec query cache outputs that take place due to lack of memory space. Alerts if this number exceeds a threshold. A high value may indicate a query cache size that is too small. Configuration: MySQL monitoring account, TCP connection port, alert thresholds.

Available from version
3.13

MySQL-DB-Request

Executes a SQL query returning a number. Alerts if this number exceeds a threshold. Configuration: MySQL monitoring account, TCP connection port, thresholds, SQL query.

Available from version
3.13

MySQL-DB-SlaveIO

Checks whether the IO replication process is running. Alert if it is not. Configuration: MySQL monitoring account, TCP connection port.

Available from version
3.13

MySQL-DB-SlaveSQL

Checks if the SQL replication process is running. Alert if it is not. Configuration: MySQL monitoring account, TCP connection port.

Available from version
3.13

MySQL-DB-TableCacheHitRate

Controls the use of the table cache. Measures the success rate of using the table cache. Alerts if the cache table is below a certain threshold. Configuration: MySQL monitoring account, TCP server connection TCP port, percentage thresholds.

Available from version
3.13

MySQL-DB-ThreadCacheHitRate

Controls the use of the thread cache. Measures thread cache usage and alerts when it falls below a threshold. Configuration: MySQL monitoring account, MySQL server connection port, thresholds expressed as a percentage.

Available from version
3.13

MySQL-Databases

Resets the size of the databases and notifies if the server is not accessible. Configuration: Account on MySQL server  

Available from version
3.13

MySQL-DB-BufferPool-HitRate

Controls the use of the Buffer Pool of InnoDB tables. Measures the success rate and alerts if it is below a threshold. Configuration: MySQL supervision account, TCP port of connection to the server, percentage thresholds.

Available from version
3.13

MySQL-DB-BufferPool-WaitFree

Number of occurrences / second that the Buffer Pool is expected to be available. Alert if it reaches an alert threshold. Configuration: MySQL monitoring account, TCP connection port, thresholds.

Available from version
3.13

MySQL-DB-ConnectionTime

Controls the establishment of the connection to the MySQL server. Measures the time to establish the connection. Alerts if this delay is greater than a threshold. Configuration: MySQL monitoring account, MySQL server connection port.

Available from version
3.13
en_US

Welcome to ServiceNav!

Need help? More information about our products? Write to us!
You have taken note of our privacy policy.

[COVID - 19 ] - TELEWORKING, TARGET AVAILABILITY 100% !

While the epidemic lasts, ensure the availability and performance of your IT services for teleworking, with ServiceNav!

Following the government's call to mobilize to help businesses overcome the current health and economic context, we help you, free of charge, to ensure the complete monitoring of your teleworking environments: VPN, VDI, Teams, Skype Enterprise, Citrix... Objectives: collection, availability and usage indicators, dashboards to support your communication.
We use cookies to ensure that you have the best possible experience on our site, and if you continue to use this site, we will assume that you are satisfied with it.

Reserve your place

You have taken note of our privacy policy.