MySQL / MariaDB

Auto-Discovery

Health Check

Metrics

Logs

To enable metrics gathering, credentials are required. Bleemeo agent will find the credentials if:

• MySQL or MariaDB and the agent are running on Ubuntu or Debian
• MySQL or MariaDB is running in a Docker container and root password is set through the environment variable MYSQL_ROOT_PASSWORD or MARIADB_ROOT_PASSWORD

If some auto-detected parameters are wrong, you can manually override them by adding the following to /etc/glouton/conf.d/99-local.conf:

service:
[...]

  # For a MySQL or MariaDB running outside a container
  - type: "mysql"
    username: "USERNAME"
    password: "PASSWORD"
    address: "127.0.0.1"
    # If set to existing socket file, Glouton will prefer using the Unix socket to
    # connect and gather metric from MySQL or MariaDB.
    # Service check will continue to use the TCP address.
    metrics_unix_socket: "/var/run/mysqld/mysqld.sock"
    port: 3306

  # For an additional MySQL or MariaDB running outside a container
  - type: "mysql"
    instance: "NAME_ASSOCIATED_WITH_YOUR_ADDITIONAL_SERVICE"
    username: "USERNAME"
    password: "PASSWORD"
    address: "127.0.0.1"
    # If set to existing socket file, Glouton will prefer using the Unix socket to
    # connect and gather metric from MySQL or MariaDB.
    # Service check will continue to use the TCP address.
    metrics_unix_socket: "/var/run/mysqld/mysqld2.sock"
    port: 3307

  # For a MySQL or MariaDB running in a Docker container
  - type: "mysql"
    instance: "CONTAINER_NAME"
    username: "USERNAME"
    password: "PASSWORD"
    address: "172.17.0.2"
    port: 3306

Agent gathers the following metrics:

Metric	Description
service_status: Status of MySQL or MariaDB
mysql_cache_result_qcache_hits	Number of query cache hits per second
mysql_cache_result_qcache_inserts	Number of queries added to the query cache per second
mysql_cache_result_qcache_not_cached	Number of uncacheable queries per second
mysql_cache_result_qcache_prunes	Number of queries that were deleted from the query cache because of low memory per second
mysql_cache_blocksize_qcache	Number of blocks in the query cache
mysql_cache_free_blocks	Number of free memory blocks in the query cache
mysql_cache_free_memory	Number of free memory for the query cache in bytes
mysql_cache_size_qcache	Number of queries registered in the query cache
mysql_locks_immediate	Number of table locks that could be granted immediately per second
mysql_locks_waited	Number of table locks that could not be granted immediately per second
mysql_innodb_history_list_len	Size of InnoDB transaction history list
mysql_innodb_locked_transaction	Number of InnoDB transaction currently locked
mysql_octets_rx	Network traffic received from clients in bytes per second
mysql_octets_tx	Network traffic sent to clients in bytes per second
mysql_queries	Number of queries per second
mysql_slow_queries	Number of slow queries per second
mysql_threads_cached	Number of threads in the thread cache
mysql_threads_connected	Number of currently open connections
mysql_threads_running	Number of threads that are not sleeping
mysql_total_threads_created	Number of threads created per second
mysql_commands_begin	Number of “BEGIN” statement executed per second
mysql_commands_binlog	Number of “BINLOG” statement executed per second
mysql_commands_call_procedure	Number of “CALL PROCEDURE” statement executed per second
mysql_commands_change_master	Number of “CHANGE MASTER” statement executed per second
mysql_commands_change_repl_filter	Number of “CHANGE REPL FILTER” statement executed per second
mysql_commands_check	Number of “CHECK TABLE” statement executed per second
mysql_commands_checksum	Number of “CHECKSUM TABLE” statement executed per second
mysql_commands_commit	Number of “COMMIT” statement executed per second
mysql_commands_dealloc_sql	Number of “DEALLOCATE PREPARE” statement executed per second
mysql_commands_stmt_close	Number of “DEALLOCATE PREPARE” statement executed per second
mysql_commands_delete_multi	Number of “DELETE” on multiple table statement executed per second
mysql_commands_delete	Number of “DELETE” statement executed per second
mysql_commands_do	Number of “DO” statement executed per second
mysql_commands_execute_sql	Number of “EXECUTE” statement executed per second
mysql_commands_stmt_execute	Number of “EXECUTE” statement executed per second
mysql_commands_explain_other	Number of “EXPLAIN FOR CONNECTION” statement executed per second
mysql_commands_flush	Number of “FLUSH” statement executed per second
mysql_commands_ha_close	Number of “HA CLOSE” statement executed per second
mysql_commands_ha_open	Number of “HA OPEN” statement executed per second
mysql_commands_ha_read	Number of “HA READ” statement executed per second
mysql_commands_insert_select	Number of “INSERT … SELECT” statement executed per second
mysql_commands_insert	Number of “INSERT” statement executed per second
mysql_commands_kill	Number of “KILL” statement executed per second
mysql_commands_preload_keys	Number of “LOAD INDEX INTO CACHE” statement executed per second
mysql_commands_load	Number of “LOAD” statement executed per second
mysql_commands_lock_tables	Number of “LOCK TABLES” statement executed per second
mysql_commands_optimize	Number of “OPTIMIZE” statement executed per second
mysql_commands_prepare_sql	Number of “PREPARE” statement executed per second
mysql_commands_stmt_prepare	Number of “PREPARE” statement executed per second
mysql_commands_purge_before_date	Number of “PURGE BEFORE DATE” statement executed per second
mysql_commands_purge	Number of “PURGE” statement executed per second
mysql_commands_release_savepoint	Number of “RELEASE SAVEPOINT” statement executed per second
mysql_commands_repair	Number of “REPAIR” statement executed per second
mysql_commands_replace_select	Number of “REPLACE SELECT” statement executed per second
mysql_commands_replace	Number of “REPLACE” statement executed per second
mysql_commands_reset	Number of “RESET” statement executed per second
mysql_commands_resignal	Number of “RESIGNAL” statement executed per second
mysql_commands_rollback_to_savepoint	Number of “ROLLBACK TO SAVEPOINT” statement executed per second
mysql_commands_rollback	Number of “ROLLBACK” statement executed per second
mysql_commands_savepoint	Number of “SAVEPOINT” statement executed per second
mysql_commands_select	Number of “SELECT” statement executed per second
mysql_commands_signal	Number of “SIGNAL” statement executed per second
mysql_commands_slave_start	Number of “START SLAVE” statement executed per second
mysql_commands_group_replication_start	Number of “START” for group replication statement executed per second
mysql_commands_stmt_fetch	Number of “STMT FETCH” statement executed per second
mysql_commands_stmt_reprepare	Number of “STMT REPREPARE” statement executed per second
mysql_commands_stmt_reset	Number of “STMT RESET” statement executed per second
mysql_commands_stmt_send_long_data	Number of “STMT SEND LONG DATA” statement executed per second
mysql_commands_slave_stop	Number of “STOP SLAVE” statement executed per second
mysql_commands_group_replication_stop	Number of “STOP” for group replication statement executed per second
mysql_commands_truncate	Number of “TRUNCATE” statement executed per second
mysql_commands_unlock_tables	Number of “UNLOCK TABLES” statement executed per second
mysql_commands_update_multi	Number of “UPDATE” on multiple table statement executed per second
mysql_commands_update	Number of “UPDATE” statement executed per second
mysql_commands_xa_commit	Number of “XA COMMIT” statement executed per second
mysql_commands_xa_end	Number of “XA END” statement executed per second
mysql_commands_xa_prepare	Number of “XA PREPARE” statement executed per second
mysql_commands_xa_recover	Number of “XA RECOVER” statement executed per second
mysql_commands_xa_rollback	Number of “XA ROLLBACK” statement executed per second
mysql_commands_xa_start	Number of “XA START” statement executed per second
mysql_commands_assign_to_keycache	Number of assign to keycache commands per second
mysql_handler_commit	Number of internal commit request per second
mysql_handler_delete	Number of rows deleted from tables per second
mysql_handler_write	Number of rows inserted per second
mysql_handler_update	Number of rows updated per second
mysql_handler_rollback	Number of transaction rollback requests given to a storage engine per second