Find all the service models dedicated to the supervision of your MariaDB Application.
MariaDB
Presentation
Service Templates
BOX mode
MariaDB-Uptime
Duration since the last restart of the server (takes into account the restarts and the crashes). Configuration : MariaDB supervision account (use the MySQL account), TCP port of connection to the MariaDB server, thresholds expressed in seconds and respecting the nagios format:
XX: alert if above XX
XX: : alert if below XX
XX:YY : alert if not between XX and YY
Available from version 4.16
MariaDB-Tmp-Disk-Tables
Collects the rate of temporary tables created on disk rather than in memory, on the MariaDB database. This control notifies when a threshold is exceeded. Configuration: account and password of a user with USAGE access to the MariaDB database (use a MySQL account), alert threshold, critical threshold.
Available from version 4.16
MariaDB-ThreadCacheHitRate
Controls the use of the thread cache. Measures the rate of use of this cache and alerts when this rate goes below a threshold. Configuration: MariaDB monitoring account (use MySQL account), MariaDB server connection port, thresholds expressed in percentage.
Available from version 4.16
MariaDB-TableCacheHitRate
Controls table cache usage. Measures the table cache hit rate. Alerts if it is below a certain threshold. This control is done only when the fill rate of this cache is higher than 95%. Configuration: MariaDB supervision account (use MySQL account), TCP port of connection to the server, thresholds in percentage.
Available from version 4.16
MariaDB-Table-Lock-Contention
Collects the rate of failed table locks on the MariaDB database. This control notifies when a threshold is exceeded. Configuration: account and password of a user with USAGE access to the MariaDB database (use MySQL account), alert threshold, critical threshold.
Available from version 4.16
MariaDB-Slow-Queries
Collects the rate of requests classified as slow on the MariaDB server. This control notifies when the threshold is exceeded. Configuration: account and password of a user with USAGE access to the MariaDB database (use MySQL account), alert threshold, critical threshold.
Available from version 4.16
MariaDB-SlaveSQL
Checks if the SQL replication process is running. Alerts if it is not. Configuration: MariaDB monitoring account (use MySQL account), TCP connection port.
Available from version 4.16
MariaDB-SlaveIO
Checks if the IO replication process is running. Alerts if it is not. Configuration: MariaDB monitoring account (use MySQL account), TCP connection port.
Available from version 4.16
MariaDB-Request-String
Executes a SQL query on a database and returns a String value. Changes state if the first column of the query matches or doesn't match the searched string. If a second column is part of the result of the query then its content is displayed in the plugin output. Configuration: an account and a password of a MariaDB user (use the MySQL account) having the rights of execution of the request, name of the base, SQL request, sought string (possible regex), status of presence, status of absence. Prerequisite: The query must return only one row. The first column is compared with the string. The second column is used to display an additional text in the plugin output.
Available from version 4.16
MariaDB-Request
Executes a SQL query returning a number. Configuration : MariaDB monitoring account (use MySQL account), TCP connection port, thresholds, SQL query.
Available from version 4.16
MariaDB-QueryCache-LowMemoryPrunes
Measures the number of queries/sec out of the query cache that occur due to a memory shortage. Alerts if this number exceeds a threshold. A high value may indicate a too small query cache size. Configuration: MariaDB monitoring account (use MySQL account), TCP connection port, alert thresholds.
Available from version 4.16
MariaDB-Replication-Delay
Collects the replication delay, in seconds, from the master MariaDB server to the slave MariaDB server. This control notifies when the threshold is exceeded. Configuration: account and password of a user with CLIENT REPLICATION access to the MariaDB database (use MySQL account), alert threshold, critical threshold.
Available from version 4.16
MariaDB-QueryCache-HitRate
Controls the cache usage of SQL queries. Measures the success rate and alerts if it is below a threshold. Configuration: MariaDB monitoring account (use MySQL account), TCP port to connect to the server, percentage thresholds.
Available from version 4.16
MariaDB-OpenFiles
Checks the number of open files against the maximum limit for the MySQL server. Alerts if this rate exceeds a threshold. Configuration: MariaDB monitoring account (use MySQL account), connection port, thresholds as a percentage of the maximum limit.
Available from version 4.16
MariaDB-Open-Connections
Collects the number of current connections to the MariaDB database. This control notifies when a threshold is exceeded. Configuration: account and password of a user with USAGE access to the MariaDB database (use MySQL account), alert threshold, critical threshold.
Available from version 4.16
MariaDB-Modified-Configuration
Verifies that the MariaDB server configuration has not been changed. Alerts if any changes have been made and specifies which directives have been changed. Configuration: MariaDB supervision account (use MySQL account), MariaDB server connection port, configuration checksum.
The configuration is done in two steps.
We set the checksum parameter to 0 to initialize the check. This one returns the initial checksum corresponding to the current MariaDB configuration.
The checksum parameter is then defined with the one returned previously.
Available from version 4.16
MariaDB-Long-Running-Procs
Collects the number of MariaDB processes whose execution time exceeds one minute. This control notifies when the threshold is exceeded. Configuration: account and password of a user with USAGE access to the MariaDB database (use MySQL account), alert threshold, critical threshold.
Available from version 4.16
MariaDB-LogWaits
Controls the number of times per second that the database waits for the InnoDB log to be written to disk. A value too high indicates that this log is too small. Alert when this value exceeds a threshold. Configuration : MariaDB supervision account (use MySQL account), TCP connection port, alert thresholds.
Available from version 4.16
MariaDB-KeyCache-HitRate
Controls the key cache usage of MyISAM tables. Measures the hit rate and alerts if it is below a certain threshold. Configuration: MariaDB supervision account (use MySQL account), TCP port of connection to the server, thresholds in percentage.
Available from version 4.16
MariaDB-Index-Usage
Collects the rate of index usage by queries on the MariaDB database. This control notifies when a threshold is exceeded. Configuration: account and password of a user with USAGE access to the MariaDB database (use the MySQL account), alert threshold, critical threshold. The alert threshold is higher than the critical threshold.
Available from version 4.16
MariaDB-Databases
Get the size of the databases and notify if the server is not accessible. Configuration : account on MariaDB server (use MySQL account), databases
Available from version 4.16
MariaDB-ConnectionTime
Controls the establishment of the connection to the MySQL server. Measures the time to establish the connection. Alerts if this delay is higher than a threshold. Configuration: MariaDB monitoring account (use MySQL account), MySQL server connection port.
Available from version 4.16
MariaDB-BufferPool-HitRate
Controls the Buffer Pool usage of InnoDB tables. Measures the success rate and alerts if it is below a threshold. Configuration: MariaDB monitoring account (use MySQL account), TCP port to connect to the server, percentage thresholds.
Available from version 4.16
MariaDB-BufferPool-WaitFree
Number of occurrences / second where we wait for the Buffer Pool to be available. Alert if it reaches an alert threshold Configuration: MariaDB supervision account (use MySQL account), TCP connection port, thresholds.
Available from version 4.16
News
Server monitoring at the heart of your business
18 November 2020
Integration with Slack: Why and How?
10 April 2020
Why monitor an Office365 environment
9 April 2020
8 April 2020
Do you need help?