Docs » Integrations Guide » Integrations Reference » MySQL

../../_images/integrations_mysql.png MySQL πŸ”—

DESCRIPTION πŸ”—

This integration primarily consists of the Smart Agent monitor collectd/mysql. Below is an overview of that monitor.

Smart Agent Monitor πŸ”—

Monitors a MySQL database server using collectd’s MySQL plugin. It supports MySQL versions 5.x or later.

This monitor connects to a MySQL instance and reports on the values returned by a SHOW STATUS command. This includes the following:

  • Number of commands processed
  • Table and row operations (handlers)
  • State of the query cache
  • Status of MySQL threads
  • Network traffic

Note on localhost πŸ”—

On Unix, MySQL programs treat the host name localhost specially, in a way that is likely different from what is expected compared to other network-based programs. For connections to localhost, MySQL programs attempt to connect to the local server by using a Unix socket file. To ensure that the client makes a TCP/IP connection to the local server specify a host name value of 127.0.0.1, or the IP address or name of the local server.

Databases πŸ”—

You have to specify each database you want to monitor individually under the databases config option. If you have a common authentication to all databases being monitored, you can specify that in the top-level username/password options, otherwise they can be specified at the database level.

Example Config πŸ”—

Sample YAML configuration:

monitors:
 - type: collectd/mysql
   host: 127.0.0.1
   port: 3306
   databases:
     - name: dbname
     - name: securedb
       username: admin
       password: s3cr3t
   username: dbuser
   password: passwd

INSTALLATION πŸ”—

This integration is part of the SignalFx Smart Agent as the collectd/mysql monitor. You should first deploy the Smart Agent to the same host as the service you want to monitor, and then continue with the configuration instructions below.

CONFIGURATION πŸ”—

To activate this monitor in the Smart Agent, add the following to your agent config:

monitors:  # All monitor config goes under this key
 - type: collectd/mysql
   ...  # Additional config

For a list of monitor options that are common to all monitors, see Common Configuration.

Config option Required Type Description
host yes string
port yes integer
name no string
databases yes list of objects (see below) A list of databases along with optional authentication credentials.
username no string These credentials serve as defaults for all databases if not overridden
password no string
reportHost no bool A SignalFx extension to the plugin that allows us to disable the normal behavior of the MySQL collectd plugin where the host dimension is set to the hostname of the MySQL database server. When false (the recommended and default setting), the globally configured hostname config is used instead. (default: false)

The nested databases config object has the following fields:

Config option Required Type Description
name yes string
username no string
password no string

USAGE πŸ”—

Below are screen captures of dashboards created for this plugin by SignalFx, illustrating the metrics emitted by this plugin.

For general reference on how to monitor MySQL performance using this plugin, see documentation on collectd.org.

Monitoring multiple MySQL nodes

../../_images/MySQL_nodes_dashboard.pngExample dashboard showing MySQL nodes

Example dashboard showing performance of multiple MySQL nodes.

Monitoring a single MySQL node

../../_images/MySQL_node_dashboard.pngExample dashboard showing a single MySQL host

Example dashboard showing performance of a single MySQL node.

METRICS πŸ”—

Metric Name Description Type
cache_result.cache_size MySQL Qcache Size gauge
cache_result.qcache-hits The number of hits on MySQL query cache cumulative
cache_result.qcache-inserts The number of inserts into MySQL query cache cumulative
cache_result.qcache-not_cached The number of MySQL queries that were not cacheable or not cached cumulative
cache_result.qcache-prunes The number of queries that were pruned from query cache because of low-memory condition cumulative
cache_size.qcache The number of queries in MySQL query cache gauge
mysql_commands.admin_commands The number of MySQL ADMIN commands executed cumulative
mysql_commands.alter_db The number of MySQL ALTER DB commands executed cumulative
mysql_commands.alter_db_upgrade The number of MySQL ALTER DB UPGRADE commands executed cumulative
mysql_commands.alter_event The number of MySQL ALTER EVENT commands executed cumulative
mysql_commands.alter_function The number of MySQL ALTER FUNCTION commands executed cumulative
mysql_commands.alter_procedure The number of MySQL ALTER PROCEDURE commands executed cumulative
mysql_commands.alter_server The number of MySQL ALTER SERVER commands executed cumulative
mysql_commands.alter_table The number of MySQL ALTER TABLE commands executed cumulative
mysql_commands.alter_tablespace The number of MySQL ALTER TABLESPACE commands executed cumulative
mysql_commands.alter_user The number of MySQL ALTER USER commands executed cumulative
mysql_commands.analyze The number of MySQL ANALYZE commands executed cumulative
mysql_commands.assign_to_keycache The number of MySQL ASSIGN TO KEYCACHE commands executed cumulative
mysql_commands.begin The number of MySQL BEGIN commands executed cumulative
mysql_commands.binlog The number of MySQL BINLOG commands executed cumulative
mysql_commands.call_procedure The number of MySQL CALL PROCEDURE commands executed cumulative
mysql_commands.change_db The number of MySQL CHANGE DB commands executed cumulative
mysql_commands.change_master The number of MySQL CHANGE MASTER commands executed cumulative
mysql_commands.check The number of MySQL CHECK commands executed cumulative
mysql_commands.checksum The number of MySQL CHECKSUM commands executed cumulative
mysql_commands.commit The number of MySQL COMMIT commands executed cumulative
mysql_commands.create_db The number of MySQL CREATE DB commands executed cumulative
mysql_commands.create_event The number of MySQL CREATE EVENT commands executed cumulative
mysql_commands.create_function The number of MySQL CREATE FUNCTION commands executed cumulative
mysql_commands.create_index The number of MySQL CREATE INDEX commands executed cumulative
mysql_commands.create_procedure The number of MySQL CREATE PROCEDURE commands executed cumulative
mysql_commands.create_server The number of MySQL CREATE SERVER commands executed cumulative
mysql_commands.create_table The number of MySQL CREATE TABLE commands executed cumulative
mysql_commands.create_trigger The number of MySQL CREATE TRIGGER commands executed cumulative
mysql_commands.create_udf The number of MySQL CREATE UDF commands executed cumulative
mysql_commands.create_user The number of MySQL CREATE USER commands executed cumulative
mysql_commands.create_view The number of MySQL CREATE VIEW commands executed cumulative
mysql_commands.dealloc_sql The number of MySQL DEALLOC SQL commands executed cumulative
mysql_commands.delete The number of MySQL DELETE commands executed cumulative
mysql_commands.delete_multi The number of MySQL DELETE MULTI commands executed cumulative
mysql_commands.do The number of MySQL DO commands executed cumulative
mysql_commands.drop_db The number of MySQL DROP DB commands executed cumulative
mysql_commands.drop_event The number of MySQL DROP EVENT commands executed cumulative
mysql_commands.drop_function The number of MySQL DROP FUNCTION commands executed cumulative
mysql_commands.drop_index The number of MySQL DROP INDEX commands executed cumulative
mysql_commands.drop_procedure The number of MySQL DROP PROCEDURE commands executed cumulative
mysql_commands.drop_server The number of MySQL DROP SERVER commands executed cumulative
mysql_commands.drop_table The number of MySQL DROP TABLE commands executed cumulative
mysql_commands.drop_trigger The number of MySQL DROP TRIGGER commands executed cumulative
mysql_commands.drop_user The number of MySQL DROP USER commands executed cumulative
mysql_commands.drop_view The number of MySQL DROP VIEW commands executed cumulative
mysql_commands.empty_query The number of MySQL EMPTY QUERY commands executed cumulative
mysql_commands.execute_sql The number of MySQL EXECUTE SQL commands executed cumulative
mysql_commands.flush The number of MySQL FLUSH commands executed cumulative
mysql_commands.get_diagnostics The number of MySQL GET DIAGNOSTICS commands executed cumulative
mysql_commands.grant The number of MySQL GRANT commands executed cumulative
mysql_commands.ha_close The number of MySQL HA CLOSE commands executed cumulative
mysql_commands.ha_open The number of MySQL HA OPEN commands executed cumulative
mysql_commands.ha_read The number of MySQL HA READ commands executed cumulative
mysql_commands.help The number of MySQL HELP commands executed cumulative
mysql_commands.insert The number of MySQL INSERT commands executed cumulative
mysql_commands.insert_select The number of MySQL INSERT SELECT commands executed cumulative
mysql_commands.install_plugin The number of MySQL INSTALL PLUGIN commands executed cumulative
mysql_commands.kill The number of MySQL KILL commands executed cumulative
mysql_commands.load The number of MySQL LOAD commands executed cumulative
mysql_commands.lock_tables The number of MySQL LOCK TABLES commands executed cumulative
mysql_commands.optimize The number of MySQL OPTIMIZE commands executed cumulative
mysql_commands.preload_keys The number of MySQL PRELOAD KEYS commands executed cumulative
mysql_commands.prepare_sql The number of MySQL PREPARE SQL commands executed cumulative
mysql_commands.purge The number of MySQL PURGE commands executed cumulative
mysql_commands.purge_before_date The number of MySQL PURGE BEFORE DATE commands executed cumulative
mysql_commands.release_savepoint The number of MySQL RELEASE SAVEPOINT commands executed cumulative
mysql_commands.rename_table The number of MySQL RENAME TABLE commands executed cumulative
mysql_commands.rename_user The number of MySQL RENAME USER commands executed cumulative
mysql_commands.repair The number of MySQL REPAIR commands executed cumulative
mysql_commands.replace The number of MySQL REPLACE commands executed cumulative
mysql_commands.replace_select The number of MySQL REPLACE SELECT commands executed cumulative
mysql_commands.reset The number of MySQL RESET commands executed cumulative
mysql_commands.resignal The number of MySQL RESIGNAL commands executed cumulative
mysql_commands.revoke The number of MySQL REVOKE commands executed cumulative
mysql_commands.revoke_all The number of MySQL REVOKE ALL commands executed cumulative
mysql_commands.rollback The number of MySQL ROLLBACK commands executed cumulative
mysql_commands.rollback_to_savepoint The number of MySQL ROLLBACK TO SAVEPOINT commands executed cumulative
mysql_commands.savepoint The number of MySQL SAVEPOINT commands executed cumulative
mysql_commands.select The number of MySQL SELECT commands executed cumulative
mysql_commands.set_option The number of MySQL SET OPTION commands executed cumulative
mysql_commands.show_binlog_events The number of MySQL SHOW BINLOG EVENTS commands executed cumulative
mysql_commands.show_binlogs The number of MySQL SHOW BINLOGS commands executed cumulative
mysql_commands.show_charsets The number of MySQL SHOW CHARSETS commands executed cumulative
mysql_commands.show_collations The number of MySQL SHOW COLLATIONS commands executed cumulative
mysql_commands.show_create_db The number of MySQL SHOW CREATE DB commands executed cumulative
mysql_commands.show_create_event The number of MySQL SHOW CREATE EVENT commands executed cumulative
mysql_commands.show_create_func The number of MySQL SHOW CREATE FUNC commands executed cumulative
mysql_commands.show_create_proc The number of MySQL SHOW CREATE PROC commands executed cumulative
mysql_commands.show_create_table The number of MySQL SHOW CREATE TABLE commands executed cumulative
mysql_commands.show_create_trigger The number of MySQL SHOW CREATE TRIGGER commands executed cumulative
mysql_commands.show_databases The number of MySQL SHOW DATABASES commands executed cumulative
mysql_commands.show_engine_logs The number of MySQL SHOW ENGINE LOGS commands executed cumulative
mysql_commands.show_engine_mutex The number of MySQL SHOW ENGINE MUTEX commands executed cumulative
mysql_commands.show_engine_status The number of MySQL SHOW ENGINE STATUS commands executed cumulative
mysql_commands.show_errors The number of MySQL SHOW ERRORS commands executed cumulative
mysql_commands.show_events The number of MySQL SHOW EVENTS commands executed cumulative
mysql_commands.show_fields The number of MySQL SHOW FIELDS commands executed cumulative
mysql_commands.show_function_code The number of MySQL SHOW FUNCTION CODE commands executed cumulative
mysql_commands.show_function_status The number of MySQL SHOW FUNCTION STATUS commands executed cumulative
mysql_commands.show_grants The number of MySQL SHOW GRANTS commands executed cumulative
mysql_commands.show_keys The number of MySQL SHOW KEYS commands executed cumulative
mysql_commands.show_master_status The number of MySQL SHOW MASTER STATUS commands executed cumulative
mysql_commands.show_open_tables The number of MySQL SHOW OPEN TABLES commands executed cumulative
mysql_commands.show_plugins The number of MySQL SHOW PLUGINS commands executed cumulative
mysql_commands.show_privileges The number of MySQL SHOW PRIVILEGES commands executed cumulative
mysql_commands.show_procedure_code The number of MySQL SHOW PROCEDURE CODE commands executed cumulative
mysql_commands.show_procedure_status The number of MySQL SHOW PROCEDURE STATUS commands executed cumulative
mysql_commands.show_processlist The number of MySQL SHOW PROCESSLIST commands executed cumulative
mysql_commands.show_profile The number of MySQL SHOW PROFILE commands executed cumulative
mysql_commands.show_profiles The number of MySQL SHOW PROFILES commands executed cumulative
mysql_commands.show_relaylog_events The number of MySQL SHOW RELAYLOG EVENTS commands executed cumulative
mysql_commands.show_slave_hosts The number of MySQL SHOW SLAVE HOSTS commands executed cumulative
mysql_commands.show_slave_status The number of MySQL SHOW SLAVE STATUS commands executed cumulative
mysql_commands.show_status The number of MySQL SHOW STATUS commands executed cumulative
mysql_commands.show_storage_engines The number of MySQL SHOW STORAGE ENGINES commands executed cumulative
mysql_commands.show_table_status The number of MySQL SHOW TABLE STATUS commands executed cumulative
mysql_commands.show_tables The number of MySQL SHOW TABLES commands executed cumulative
mysql_commands.show_triggers The number of MySQL SHOW TRIGGERS commands executed cumulative
mysql_commands.show_variables The number of MySQL SHOW VARIABLES commands executed cumulative
mysql_commands.show_warnings The number of MySQL SHOW WARNINGS commands executed cumulative
mysql_commands.signal The number of MySQL SIGNAL commands executed cumulative
mysql_commands.slave_start The number of MySQL SLAVE START commands executed cumulative
mysql_commands.slave_stop The number of MySQL SLAVE STOP commands executed cumulative
mysql_commands.truncate The number of MySQL TRUNCATE commands executed cumulative
mysql_commands.uninstall_plugin The number of MySQL UNINSTALL PLUGIN commands executed cumulative
mysql_commands.unlock_tables The number of MySQL UNLOCK TABLES commands executed cumulative
mysql_commands.update The number of MySQL UPDATE commands executed cumulative
mysql_commands.update_multi The number of MySQL UPDATE MULTI commands executed cumulative
mysql_commands.xa_commit The number of MySQL XA COMMIT commands executed cumulative
mysql_commands.xa_end The number of MySQL XA END commands executed cumulative
mysql_commands.xa_prepare The number of MySQL XA PREPARE commands executed cumulative
mysql_commands.xa_recover The number of MySQL XA RECOVER commands executed cumulative
mysql_commands.xa_rollback The number of MySQL XA ROLLBACK commands executed cumulative
mysql_commands.xa_start The number of MySQL XA START commands executed cumulative
mysql_handler.commit The number of internal COMMIT statements cumulative
mysql_handler.delete The number of times rows have been deleted from tables cumulative
mysql_handler.external_lock The number of external_lock occurences cumulative
mysql_handler.prepare The number of times "Prepare" phase was executed in the two-phase commit operations cumulative
mysql_handler.read_first The number of times the first entry in an index was read cumulative
mysql_handler.read_key The number of times a row was read based on a key cumulative
mysql_handler.read_next The number of requests to read the next row in key order cumulative
mysql_handler.read_prev The number of requests to read the previous row in key order cumulative
mysql_handler.read_rnd The number of requests that read a random fixed position in the data file cumulative
mysql_handler.read_rnd_next The number of requests for the next row in the data file cumulative
mysql_handler.rollback The number of requests for a rollback operation on the storage engine cumulative
mysql_handler.savepoint The number of requests to place a savepoint on the storage engine cumulative
mysql_handler.savepoint_rollback The number of requests to roll back to a savepoint cumulative
mysql_handler.update The number of requests to update a row in a table cumulative
mysql_handler.write The number of requests to insert a row in a table cumulative
mysql_locks.immediate The number of MySQL table locks which were granted immediately cumulative
mysql_locks.waited The number of MySQL table locks which had to wait before being granted cumulative
mysql_octets.rx The number of bytes received by MySQL server from all clients cumulative
mysql_octets.tx The number of bytes sent by MySQL server to all clients cumulative
mysql_select.full_join The number of joins that perform full table scans cumulative
mysql_select.full_range_join The number of joins that used a range search on a reference table cumulative
mysql_select.range The number of joins that used a range on the first table cumulative
mysql_select.range_check The number of joins without keys that check for key usage after each row cumulative
mysql_select.scan The number of joins that did a full scan of the first table cumulative
mysql_slow_queries The number of queries that have taken more than long_query_time seconds cumulative
mysql_sort.range The number of sorts that were done using ranges cumulative
mysql_sort.scan The number of sorts that were done by scanning the table cumulative
mysql_sort_merge_passes The number of merge passes done by the sorting algorithm cumulative
mysql_sort_rows The number of rows that were sorted cumulative
threads.cached The number of threads cached by MySQL for re-use on a new client connection gauge
threads.connected The number of currently open MySQL connections gauge
threads.running The number of MySQL threads that are processing a query gauge
total_threads.created The total number of threads created by MySQL for client connections cumulative

cache_result.cache_size πŸ”—

gauge

MySQL Qcache Size

cache_result.qcache-hits πŸ”—

cumulative

The number of hits on MySQL query cache.

cache_result.qcache-inserts πŸ”—

cumulative

The number of inserts into MySQL query cache.

cache_result.qcache-not_cached πŸ”—

cumulative

The number of MySQL queries that were not cacheable or not cached.

cache_result.qcache-prunes πŸ”—

cumulative

The number of queries that were pruned from query cache because of low-memory condition.

cache_size.qcache πŸ”—

gauge

The number of queries in MySQL query cache.

mysql_commands.admin_commands πŸ”—

cumulative

The number of MySQL ADMIN commands executed

mysql_commands.alter_db πŸ”—

cumulative

The number of MySQL ALTER DB commands executed

mysql_commands.alter_db_upgrade πŸ”—

cumulative

The number of MySQL ALTER DB UPGRADE commands executed

mysql_commands.alter_event πŸ”—

cumulative

The number of MySQL ALTER EVENT commands executed

mysql_commands.alter_function πŸ”—

cumulative

The number of MySQL ALTER FUNCTION commands executed

mysql_commands.alter_procedure πŸ”—

cumulative

The number of MySQL ALTER PROCEDURE commands executed

mysql_commands.alter_server πŸ”—

cumulative

The number of MySQL ALTER SERVER commands executed

mysql_commands.alter_table πŸ”—

cumulative

The number of MySQL ALTER TABLE commands executed

mysql_commands.alter_tablespace πŸ”—

cumulative

The number of MySQL ALTER TABLESPACE commands executed

mysql_commands.alter_user πŸ”—

cumulative

The number of MySQL ALTER USER commands executed

mysql_commands.analyze πŸ”—

cumulative

The number of MySQL ANALYZE commands executed

mysql_commands.assign_to_keycache πŸ”—

cumulative

The number of MySQL ASSIGN TO KEYCACHE commands executed

mysql_commands.begin πŸ”—

cumulative

The number of MySQL BEGIN commands executed

mysql_commands.binlog πŸ”—

cumulative

The number of MySQL BINLOG commands executed

mysql_commands.call_procedure πŸ”—

cumulative

The number of MySQL CALL PROCEDURE commands executed

mysql_commands.change_db πŸ”—

cumulative

The number of MySQL CHANGE DB commands executed

mysql_commands.change_master πŸ”—

cumulative

The number of MySQL CHANGE MASTER commands executed

mysql_commands.check πŸ”—

cumulative

The number of MySQL CHECK commands executed

mysql_commands.checksum πŸ”—

cumulative

The number of MySQL CHECKSUM commands executed

mysql_commands.commit πŸ”—

cumulative

The number of MySQL COMMIT commands executed

mysql_commands.create_db πŸ”—

cumulative

The number of MySQL CREATE DB commands executed

mysql_commands.create_event πŸ”—

cumulative

The number of MySQL CREATE EVENT commands executed

mysql_commands.create_function πŸ”—

cumulative

The number of MySQL CREATE FUNCTION commands executed

mysql_commands.create_index πŸ”—

cumulative

The number of MySQL CREATE INDEX commands executed

mysql_commands.create_procedure πŸ”—

cumulative

The number of MySQL CREATE PROCEDURE commands executed

mysql_commands.create_server πŸ”—

cumulative

The number of MySQL CREATE SERVER commands executed

mysql_commands.create_table πŸ”—

cumulative

The number of MySQL CREATE TABLE commands executed

mysql_commands.create_trigger πŸ”—

cumulative

The number of MySQL CREATE TRIGGER commands executed

mysql_commands.create_udf πŸ”—

cumulative

The number of MySQL CREATE UDF commands executed

mysql_commands.create_user πŸ”—

cumulative

The number of MySQL CREATE USER commands executed

mysql_commands.create_view πŸ”—

cumulative

The number of MySQL CREATE VIEW commands executed

mysql_commands.dealloc_sql πŸ”—

cumulative

The number of MySQL DEALLOC SQL commands executed

mysql_commands.delete πŸ”—

cumulative

The number of MySQL DELETE commands executed

mysql_commands.delete_multi πŸ”—

cumulative

The number of MySQL DELETE MULTI commands executed

mysql_commands.do πŸ”—

cumulative

The number of MySQL DO commands executed

mysql_commands.drop_db πŸ”—

cumulative

The number of MySQL DROP DB commands executed

mysql_commands.drop_event πŸ”—

cumulative

The number of MySQL DROP EVENT commands executed

mysql_commands.drop_function πŸ”—

cumulative

The number of MySQL DROP FUNCTION commands executed

mysql_commands.drop_index πŸ”—

cumulative

The number of MySQL DROP INDEX commands executed

mysql_commands.drop_procedure πŸ”—

cumulative

The number of MySQL DROP PROCEDURE commands executed

mysql_commands.drop_server πŸ”—

cumulative

The number of MySQL DROP SERVER commands executed

mysql_commands.drop_table πŸ”—

cumulative

The number of MySQL DROP TABLE commands executed

mysql_commands.drop_trigger πŸ”—

cumulative

The number of MySQL DROP TRIGGER commands executed

mysql_commands.drop_user πŸ”—

cumulative

The number of MySQL DROP USER commands executed

mysql_commands.drop_view πŸ”—

cumulative

The number of MySQL DROP VIEW commands executed

mysql_commands.empty_query πŸ”—

cumulative

The number of MySQL EMPTY QUERY commands executed

mysql_commands.execute_sql πŸ”—

cumulative

The number of MySQL EXECUTE SQL commands executed

mysql_commands.flush πŸ”—

cumulative

The number of MySQL FLUSH commands executed

mysql_commands.get_diagnostics πŸ”—

cumulative

The number of MySQL GET DIAGNOSTICS commands executed

mysql_commands.grant πŸ”—

cumulative

The number of MySQL GRANT commands executed

mysql_commands.ha_close πŸ”—

cumulative

The number of MySQL HA CLOSE commands executed

mysql_commands.ha_open πŸ”—

cumulative

The number of MySQL HA OPEN commands executed

mysql_commands.ha_read πŸ”—

cumulative

The number of MySQL HA READ commands executed

mysql_commands.help πŸ”—

cumulative

The number of MySQL HELP commands executed

mysql_commands.insert πŸ”—

cumulative

The number of MySQL INSERT commands executed

mysql_commands.insert_select πŸ”—

cumulative

The number of MySQL INSERT SELECT commands executed

mysql_commands.install_plugin πŸ”—

cumulative

The number of MySQL INSTALL PLUGIN commands executed

mysql_commands.kill πŸ”—

cumulative

The number of MySQL KILL commands executed

mysql_commands.load πŸ”—

cumulative

The number of MySQL LOAD commands executed

mysql_commands.lock_tables πŸ”—

cumulative

The number of MySQL LOCK TABLES commands executed

mysql_commands.optimize πŸ”—

cumulative

The number of MySQL OPTIMIZE commands executed

mysql_commands.preload_keys πŸ”—

cumulative

The number of MySQL PRELOAD KEYS commands executed

mysql_commands.prepare_sql πŸ”—

cumulative

The number of MySQL PREPARE SQL commands executed

mysql_commands.purge πŸ”—

cumulative

The number of MySQL PURGE commands executed

mysql_commands.purge_before_date πŸ”—

cumulative

The number of MySQL PURGE BEFORE DATE commands executed

mysql_commands.release_savepoint πŸ”—

cumulative

The number of MySQL RELEASE SAVEPOINT commands executed

mysql_commands.rename_table πŸ”—

cumulative

The number of MySQL RENAME TABLE commands executed

mysql_commands.rename_user πŸ”—

cumulative

The number of MySQL RENAME USER commands executed

mysql_commands.repair πŸ”—

cumulative

The number of MySQL REPAIR commands executed

mysql_commands.replace πŸ”—

cumulative

The number of MySQL REPLACE commands executed

mysql_commands.replace_select πŸ”—

cumulative

The number of MySQL REPLACE SELECT commands executed

mysql_commands.reset πŸ”—

cumulative

The number of MySQL RESET commands executed

mysql_commands.resignal πŸ”—

cumulative

The number of MySQL RESIGNAL commands executed

mysql_commands.revoke πŸ”—

cumulative

The number of MySQL REVOKE commands executed

mysql_commands.revoke_all πŸ”—

cumulative

The number of MySQL REVOKE ALL commands executed

mysql_commands.rollback πŸ”—

cumulative

The number of MySQL ROLLBACK commands executed

mysql_commands.rollback_to_savepoint πŸ”—

cumulative

The number of MySQL ROLLBACK TO SAVEPOINT commands executed

mysql_commands.savepoint πŸ”—

cumulative

The number of MySQL SAVEPOINT commands executed

mysql_commands.select πŸ”—

cumulative

The number of MySQL SELECT commands executed

mysql_commands.set_option πŸ”—

cumulative

The number of MySQL SET OPTION commands executed

mysql_commands.show_binlog_events πŸ”—

cumulative

The number of MySQL SHOW BINLOG EVENTS commands executed

mysql_commands.show_binlogs πŸ”—

cumulative

The number of MySQL SHOW BINLOGS commands executed

mysql_commands.show_charsets πŸ”—

cumulative

The number of MySQL SHOW CHARSETS commands executed

mysql_commands.show_collations πŸ”—

cumulative

The number of MySQL SHOW COLLATIONS commands executed

mysql_commands.show_create_db πŸ”—

cumulative

The number of MySQL SHOW CREATE DB commands executed

mysql_commands.show_create_event πŸ”—

cumulative

The number of MySQL SHOW CREATE EVENT commands executed

mysql_commands.show_create_func πŸ”—

cumulative

The number of MySQL SHOW CREATE FUNC commands executed

mysql_commands.show_create_proc πŸ”—

cumulative

The number of MySQL SHOW CREATE PROC commands executed

mysql_commands.show_create_table πŸ”—

cumulative

The number of MySQL SHOW CREATE TABLE commands executed

mysql_commands.show_create_trigger πŸ”—

cumulative

The number of MySQL SHOW CREATE TRIGGER commands executed

mysql_commands.show_databases πŸ”—

cumulative

The number of MySQL SHOW DATABASES commands executed

mysql_commands.show_engine_logs πŸ”—

cumulative

The number of MySQL SHOW ENGINE LOGS commands executed

mysql_commands.show_engine_mutex πŸ”—

cumulative

The number of MySQL SHOW ENGINE MUTEX commands executed

mysql_commands.show_engine_status πŸ”—

cumulative

The number of MySQL SHOW ENGINE STATUS commands executed

mysql_commands.show_errors πŸ”—

cumulative

The number of MySQL SHOW ERRORS commands executed

mysql_commands.show_events πŸ”—

cumulative

The number of MySQL SHOW EVENTS commands executed

mysql_commands.show_fields πŸ”—

cumulative

The number of MySQL SHOW FIELDS commands executed

mysql_commands.show_function_code πŸ”—

cumulative

The number of MySQL SHOW FUNCTION CODE commands executed

mysql_commands.show_function_status πŸ”—

cumulative

The number of MySQL SHOW FUNCTION STATUS commands executed

mysql_commands.show_grants πŸ”—

cumulative

The number of MySQL SHOW GRANTS commands executed

mysql_commands.show_keys πŸ”—

cumulative

The number of MySQL SHOW KEYS commands executed

mysql_commands.show_master_status πŸ”—

cumulative

The number of MySQL SHOW MASTER STATUS commands executed

mysql_commands.show_open_tables πŸ”—

cumulative

The number of MySQL SHOW OPEN TABLES commands executed

mysql_commands.show_plugins πŸ”—

cumulative

The number of MySQL SHOW PLUGINS commands executed

mysql_commands.show_privileges πŸ”—

cumulative

The number of MySQL SHOW PRIVILEGES commands executed

mysql_commands.show_procedure_code πŸ”—

cumulative

The number of MySQL SHOW PROCEDURE CODE commands executed

mysql_commands.show_procedure_status πŸ”—

cumulative

The number of MySQL SHOW PROCEDURE STATUS commands executed

mysql_commands.show_processlist πŸ”—

cumulative

The number of MySQL SHOW PROCESSLIST commands executed

mysql_commands.show_profile πŸ”—

cumulative

The number of MySQL SHOW PROFILE commands executed

mysql_commands.show_profiles πŸ”—

cumulative

The number of MySQL SHOW PROFILES commands executed

mysql_commands.show_relaylog_events πŸ”—

cumulative

The number of MySQL SHOW RELAYLOG EVENTS commands executed

mysql_commands.show_slave_hosts πŸ”—

cumulative

The number of MySQL SHOW SLAVE HOSTS commands executed

mysql_commands.show_slave_status πŸ”—

cumulative

The number of MySQL SHOW SLAVE STATUS commands executed

mysql_commands.show_status πŸ”—

cumulative

The number of MySQL SHOW STATUS commands executed

mysql_commands.show_storage_engines πŸ”—

cumulative

The number of MySQL SHOW STORAGE ENGINES commands executed

mysql_commands.show_table_status πŸ”—

cumulative

The number of MySQL SHOW TABLE STATUS commands executed

mysql_commands.show_tables πŸ”—

cumulative

The number of MySQL SHOW TABLES commands executed

mysql_commands.show_triggers πŸ”—

cumulative

The number of MySQL SHOW TRIGGERS commands executed

mysql_commands.show_variables πŸ”—

cumulative

The number of MySQL SHOW VARIABLES commands executed

mysql_commands.show_warnings πŸ”—

cumulative

The number of MySQL SHOW WARNINGS commands executed

mysql_commands.signal πŸ”—

cumulative

The number of MySQL SIGNAL commands executed

mysql_commands.slave_start πŸ”—

cumulative

The number of MySQL SLAVE START commands executed

mysql_commands.slave_stop πŸ”—

cumulative

The number of MySQL SLAVE STOP commands executed

mysql_commands.truncate πŸ”—

cumulative

The number of MySQL TRUNCATE commands executed

mysql_commands.uninstall_plugin πŸ”—

cumulative

The number of MySQL UNINSTALL PLUGIN commands executed

mysql_commands.unlock_tables πŸ”—

cumulative

The number of MySQL UNLOCK TABLES commands executed

mysql_commands.update πŸ”—

cumulative

The number of MySQL UPDATE commands executed

mysql_commands.update_multi πŸ”—

cumulative

The number of MySQL UPDATE MULTI commands executed

mysql_commands.xa_commit πŸ”—

cumulative

The number of MySQL XA COMMIT commands executed

mysql_commands.xa_end πŸ”—

cumulative

The number of MySQL XA END commands executed

mysql_commands.xa_prepare πŸ”—

cumulative

The number of MySQL XA PREPARE commands executed

mysql_commands.xa_recover πŸ”—

cumulative

The number of MySQL XA RECOVER commands executed

mysql_commands.xa_rollback πŸ”—

cumulative

The number of MySQL XA ROLLBACK commands executed

mysql_commands.xa_start πŸ”—

cumulative

The number of MySQL XA START commands executed

mysql_handler.commit πŸ”—

cumulative

The number of internal COMMIT statements.

mysql_handler.delete πŸ”—

cumulative

The number of times rows have been deleted from tables.

mysql_handler.external_lock πŸ”—

cumulative

The number of external_lock occurences.

mysql_handler.prepare πŸ”—

cumulative

The number of times β€œPrepare” phase was executed in the two-phase commit operations.

mysql_handler.read_first πŸ”—

cumulative

The number of times the first entry in an index was read.

mysql_handler.read_key πŸ”—

cumulative

The number of times a row was read based on a key.

mysql_handler.read_prev πŸ”—

cumulative

The number of requests to read the previous row in key order.

mysql_handler.read_rnd πŸ”—

cumulative

The number of requests that read a random fixed position in the data file.

mysql_handler.read_rnd_next πŸ”—

cumulative

The number of requests for the next row in the data file.

mysql_handler.rollback πŸ”—

cumulative

The number of requests for a rollback operation on the storage engine.

mysql_handler.savepoint πŸ”—

cumulative

The number of requests to place a savepoint on the storage engine. This can be used to roll back later.

mysql_handler.savepoint_rollback πŸ”—

cumulative

The number of requests to roll back to a savepoint.

mysql_handler.update πŸ”—

cumulative

The number of requests to update a row in a table.

mysql_handler.write πŸ”—

cumulative

The number of requests to insert a row in a table.

mysql_locks.immediate πŸ”—

cumulative

The number of MySQL table locks which were granted immediately.

mysql_locks.waited πŸ”—

cumulative

The number of MySQL table locks which had to wait before being granted.

mysql_octets.rx πŸ”—

cumulative

The number of bytes received by MySQL server from all clients.

mysql_octets.tx πŸ”—

cumulative

The number of bytes sent by MySQL server to all clients.

mysql_select.full_join πŸ”—

cumulative

The number of joins that perform full table scans.

mysql_select.full_range_join πŸ”—

cumulative

The number of joins that used a range search on a reference table.

mysql_select.range πŸ”—

cumulative

The number of joins that used a range on the first table.

mysql_select.range_check πŸ”—

cumulative

The number of joins without keys that check for key usage after each row.

mysql_select.scan πŸ”—

cumulative

The number of joins that did a full scan of the first table.

mysql_slow_queries πŸ”—

cumulative

The number of queries that have taken more than long_query_time seconds.

mysql_sort.range πŸ”—

cumulative

The number of sorts that were done using ranges.

mysql_sort.scan πŸ”—

cumulative

The number of sorts that were done by scanning the table.

mysql_sort_merge_passes πŸ”—

cumulative

The number of merge passes done by the sorting algorithm.

mysql_sort_rows πŸ”—

cumulative

The number of rows that were sorted.

threads.cached πŸ”—

gauge

The number of threads cached by MySQL for re-use on a new client connection. A MySQL thread corresponds to a single MySQL connection.

threads.connected πŸ”—

gauge

The number of currently open MySQL connections. A MySQL thread corresponds to a single MySQL connection.

threads.running πŸ”—

gauge

The number of MySQL threads that are processing a query. A MySQL thread corresponds to a single MySQL connection.

total_threads.created πŸ”—

cumulative

The total number of threads created by MySQL for client connections. A MySQL thread corresponds to a single MySQL connection.

Metrics that are categorized as container/host (default) are in bold and italics in the list below.

These are the metrics available for this integration.

  • cache_result.cache_size (gauge)
    MySQL Qcache Size
  • cache_result.qcache-hits (cumulative)
    The number of hits on MySQL query cache.
  • cache_result.qcache-inserts (cumulative)
    The number of inserts into MySQL query cache.
  • cache_result.qcache-not_cached (cumulative)
    The number of MySQL queries that were not cacheable or not cached.
  • cache_result.qcache-prunes (cumulative)
    The number of queries that were pruned from query cache because of low-memory condition.
  • cache_size.qcache (gauge)
    The number of queries in MySQL query cache.
  • mysql_commands.admin_commands (cumulative)
    The number of MySQL ADMIN commands executed
  • mysql_commands.alter_db (cumulative)
    The number of MySQL ALTER DB commands executed
  • mysql_commands.alter_db_upgrade (cumulative)
    The number of MySQL ALTER DB UPGRADE commands executed
  • mysql_commands.alter_event (cumulative)
    The number of MySQL ALTER EVENT commands executed
  • mysql_commands.alter_function (cumulative)
    The number of MySQL ALTER FUNCTION commands executed
  • mysql_commands.alter_procedure (cumulative)
    The number of MySQL ALTER PROCEDURE commands executed
  • mysql_commands.alter_server (cumulative)
    The number of MySQL ALTER SERVER commands executed
  • mysql_commands.alter_table (cumulative)
    The number of MySQL ALTER TABLE commands executed
  • mysql_commands.alter_tablespace (cumulative)
    The number of MySQL ALTER TABLESPACE commands executed
  • mysql_commands.alter_user (cumulative)
    The number of MySQL ALTER USER commands executed
  • mysql_commands.analyze (cumulative)
    The number of MySQL ANALYZE commands executed
  • mysql_commands.assign_to_keycache (cumulative)
    The number of MySQL ASSIGN TO KEYCACHE commands executed
  • mysql_commands.begin (cumulative)
    The number of MySQL BEGIN commands executed
  • mysql_commands.binlog (cumulative)
    The number of MySQL BINLOG commands executed
  • mysql_commands.call_procedure (cumulative)
    The number of MySQL CALL PROCEDURE commands executed
  • mysql_commands.change_db (cumulative)
    The number of MySQL CHANGE DB commands executed
  • mysql_commands.change_master (cumulative)
    The number of MySQL CHANGE MASTER commands executed
  • mysql_commands.check (cumulative)
    The number of MySQL CHECK commands executed
  • mysql_commands.checksum (cumulative)
    The number of MySQL CHECKSUM commands executed
  • mysql_commands.commit (cumulative)
    The number of MySQL COMMIT commands executed
  • mysql_commands.create_db (cumulative)
    The number of MySQL CREATE DB commands executed
  • mysql_commands.create_event (cumulative)
    The number of MySQL CREATE EVENT commands executed
  • mysql_commands.create_function (cumulative)
    The number of MySQL CREATE FUNCTION commands executed
  • mysql_commands.create_index (cumulative)
    The number of MySQL CREATE INDEX commands executed
  • mysql_commands.create_procedure (cumulative)
    The number of MySQL CREATE PROCEDURE commands executed
  • mysql_commands.create_server (cumulative)
    The number of MySQL CREATE SERVER commands executed
  • mysql_commands.create_table (cumulative)
    The number of MySQL CREATE TABLE commands executed
  • mysql_commands.create_trigger (cumulative)
    The number of MySQL CREATE TRIGGER commands executed
  • mysql_commands.create_udf (cumulative)
    The number of MySQL CREATE UDF commands executed
  • mysql_commands.create_user (cumulative)
    The number of MySQL CREATE USER commands executed
  • mysql_commands.create_view (cumulative)
    The number of MySQL CREATE VIEW commands executed
  • mysql_commands.dealloc_sql (cumulative)
    The number of MySQL DEALLOC SQL commands executed
  • mysql_commands.delete (cumulative)
    The number of MySQL DELETE commands executed
  • mysql_commands.delete_multi (cumulative)
    The number of MySQL DELETE MULTI commands executed
  • mysql_commands.do (cumulative)
    The number of MySQL DO commands executed
  • mysql_commands.drop_db (cumulative)
    The number of MySQL DROP DB commands executed
  • mysql_commands.drop_event (cumulative)
    The number of MySQL DROP EVENT commands executed
  • mysql_commands.drop_function (cumulative)
    The number of MySQL DROP FUNCTION commands executed
  • mysql_commands.drop_index (cumulative)
    The number of MySQL DROP INDEX commands executed
  • mysql_commands.drop_procedure (cumulative)
    The number of MySQL DROP PROCEDURE commands executed
  • mysql_commands.drop_server (cumulative)
    The number of MySQL DROP SERVER commands executed
  • mysql_commands.drop_table (cumulative)
    The number of MySQL DROP TABLE commands executed
  • mysql_commands.drop_trigger (cumulative)
    The number of MySQL DROP TRIGGER commands executed
  • mysql_commands.drop_user (cumulative)
    The number of MySQL DROP USER commands executed
  • mysql_commands.drop_view (cumulative)
    The number of MySQL DROP VIEW commands executed
  • mysql_commands.empty_query (cumulative)
    The number of MySQL EMPTY QUERY commands executed
  • mysql_commands.execute_sql (cumulative)
    The number of MySQL EXECUTE SQL commands executed
  • mysql_commands.flush (cumulative)
    The number of MySQL FLUSH commands executed
  • mysql_commands.get_diagnostics (cumulative)
    The number of MySQL GET DIAGNOSTICS commands executed
  • mysql_commands.grant (cumulative)
    The number of MySQL GRANT commands executed
  • mysql_commands.ha_close (cumulative)
    The number of MySQL HA CLOSE commands executed
  • mysql_commands.ha_open (cumulative)
    The number of MySQL HA OPEN commands executed
  • mysql_commands.ha_read (cumulative)
    The number of MySQL HA READ commands executed
  • mysql_commands.help (cumulative)
    The number of MySQL HELP commands executed
  • mysql_commands.insert (cumulative)
    The number of MySQL INSERT commands executed
  • mysql_commands.insert_select (cumulative)
    The number of MySQL INSERT SELECT commands executed
  • mysql_commands.install_plugin (cumulative)
    The number of MySQL INSTALL PLUGIN commands executed
  • mysql_commands.kill (cumulative)
    The number of MySQL KILL commands executed
  • mysql_commands.load (cumulative)
    The number of MySQL LOAD commands executed
  • mysql_commands.lock_tables (cumulative)
    The number of MySQL LOCK TABLES commands executed
  • mysql_commands.optimize (cumulative)
    The number of MySQL OPTIMIZE commands executed
  • mysql_commands.preload_keys (cumulative)
    The number of MySQL PRELOAD KEYS commands executed
  • mysql_commands.prepare_sql (cumulative)
    The number of MySQL PREPARE SQL commands executed
  • mysql_commands.purge (cumulative)
    The number of MySQL PURGE commands executed
  • mysql_commands.purge_before_date (cumulative)
    The number of MySQL PURGE BEFORE DATE commands executed
  • mysql_commands.release_savepoint (cumulative)
    The number of MySQL RELEASE SAVEPOINT commands executed
  • mysql_commands.rename_table (cumulative)
    The number of MySQL RENAME TABLE commands executed
  • mysql_commands.rename_user (cumulative)
    The number of MySQL RENAME USER commands executed
  • mysql_commands.repair (cumulative)
    The number of MySQL REPAIR commands executed
  • mysql_commands.replace (cumulative)
    The number of MySQL REPLACE commands executed
  • mysql_commands.replace_select (cumulative)
    The number of MySQL REPLACE SELECT commands executed
  • mysql_commands.reset (cumulative)
    The number of MySQL RESET commands executed
  • mysql_commands.resignal (cumulative)
    The number of MySQL RESIGNAL commands executed
  • mysql_commands.revoke (cumulative)
    The number of MySQL REVOKE commands executed
  • mysql_commands.revoke_all (cumulative)
    The number of MySQL REVOKE ALL commands executed
  • mysql_commands.rollback (cumulative)
    The number of MySQL ROLLBACK commands executed
  • mysql_commands.rollback_to_savepoint (cumulative)
    The number of MySQL ROLLBACK TO SAVEPOINT commands executed
  • mysql_commands.savepoint (cumulative)
    The number of MySQL SAVEPOINT commands executed
  • mysql_commands.select (cumulative)
    The number of MySQL SELECT commands executed
  • mysql_commands.set_option (cumulative)
    The number of MySQL SET OPTION commands executed
  • mysql_commands.show_binlog_events (cumulative)
    The number of MySQL SHOW BINLOG EVENTS commands executed
  • mysql_commands.show_binlogs (cumulative)
    The number of MySQL SHOW BINLOGS commands executed
  • mysql_commands.show_charsets (cumulative)
    The number of MySQL SHOW CHARSETS commands executed
  • mysql_commands.show_collations (cumulative)
    The number of MySQL SHOW COLLATIONS commands executed
  • mysql_commands.show_create_db (cumulative)
    The number of MySQL SHOW CREATE DB commands executed
  • mysql_commands.show_create_event (cumulative)
    The number of MySQL SHOW CREATE EVENT commands executed
  • mysql_commands.show_create_func (cumulative)
    The number of MySQL SHOW CREATE FUNC commands executed
  • mysql_commands.show_create_proc (cumulative)
    The number of MySQL SHOW CREATE PROC commands executed
  • mysql_commands.show_create_table (cumulative)
    The number of MySQL SHOW CREATE TABLE commands executed
  • mysql_commands.show_create_trigger (cumulative)
    The number of MySQL SHOW CREATE TRIGGER commands executed
  • mysql_commands.show_databases (cumulative)
    The number of MySQL SHOW DATABASES commands executed
  • mysql_commands.show_engine_logs (cumulative)
    The number of MySQL SHOW ENGINE LOGS commands executed
  • mysql_commands.show_engine_mutex (cumulative)
    The number of MySQL SHOW ENGINE MUTEX commands executed
  • mysql_commands.show_engine_status (cumulative)
    The number of MySQL SHOW ENGINE STATUS commands executed
  • mysql_commands.show_errors (cumulative)
    The number of MySQL SHOW ERRORS commands executed
  • mysql_commands.show_events (cumulative)
    The number of MySQL SHOW EVENTS commands executed
  • mysql_commands.show_fields (cumulative)
    The number of MySQL SHOW FIELDS commands executed
  • mysql_commands.show_function_code (cumulative)
    The number of MySQL SHOW FUNCTION CODE commands executed
  • mysql_commands.show_function_status (cumulative)
    The number of MySQL SHOW FUNCTION STATUS commands executed
  • mysql_commands.show_grants (cumulative)
    The number of MySQL SHOW GRANTS commands executed
  • mysql_commands.show_keys (cumulative)
    The number of MySQL SHOW KEYS commands executed
  • mysql_commands.show_master_status (cumulative)
    The number of MySQL SHOW MASTER STATUS commands executed
  • mysql_commands.show_open_tables (cumulative)
    The number of MySQL SHOW OPEN TABLES commands executed
  • mysql_commands.show_plugins (cumulative)
    The number of MySQL SHOW PLUGINS commands executed
  • mysql_commands.show_privileges (cumulative)
    The number of MySQL SHOW PRIVILEGES commands executed
  • mysql_commands.show_procedure_code (cumulative)
    The number of MySQL SHOW PROCEDURE CODE commands executed
  • mysql_commands.show_procedure_status (cumulative)
    The number of MySQL SHOW PROCEDURE STATUS commands executed
  • mysql_commands.show_processlist (cumulative)
    The number of MySQL SHOW PROCESSLIST commands executed
  • mysql_commands.show_profile (cumulative)
    The number of MySQL SHOW PROFILE commands executed
  • mysql_commands.show_profiles (cumulative)
    The number of MySQL SHOW PROFILES commands executed
  • mysql_commands.show_relaylog_events (cumulative)
    The number of MySQL SHOW RELAYLOG EVENTS commands executed
  • mysql_commands.show_slave_hosts (cumulative)
    The number of MySQL SHOW SLAVE HOSTS commands executed
  • mysql_commands.show_slave_status (cumulative)
    The number of MySQL SHOW SLAVE STATUS commands executed
  • mysql_commands.show_status (cumulative)
    The number of MySQL SHOW STATUS commands executed
  • mysql_commands.show_storage_engines (cumulative)
    The number of MySQL SHOW STORAGE ENGINES commands executed
  • mysql_commands.show_table_status (cumulative)
    The number of MySQL SHOW TABLE STATUS commands executed
  • mysql_commands.show_tables (cumulative)
    The number of MySQL SHOW TABLES commands executed
  • mysql_commands.show_triggers (cumulative)
    The number of MySQL SHOW TRIGGERS commands executed
  • mysql_commands.show_variables (cumulative)
    The number of MySQL SHOW VARIABLES commands executed
  • mysql_commands.show_warnings (cumulative)
    The number of MySQL SHOW WARNINGS commands executed
  • mysql_commands.signal (cumulative)
    The number of MySQL SIGNAL commands executed
  • mysql_commands.slave_start (cumulative)
    The number of MySQL SLAVE START commands executed
  • mysql_commands.slave_stop (cumulative)
    The number of MySQL SLAVE STOP commands executed
  • mysql_commands.truncate (cumulative)
    The number of MySQL TRUNCATE commands executed
  • mysql_commands.uninstall_plugin (cumulative)
    The number of MySQL UNINSTALL PLUGIN commands executed
  • mysql_commands.unlock_tables (cumulative)
    The number of MySQL UNLOCK TABLES commands executed
  • mysql_commands.update (cumulative)
    The number of MySQL UPDATE commands executed
  • mysql_commands.update_multi (cumulative)
    The number of MySQL UPDATE MULTI commands executed
  • mysql_commands.xa_commit (cumulative)
    The number of MySQL XA COMMIT commands executed
  • mysql_commands.xa_end (cumulative)
    The number of MySQL XA END commands executed
  • mysql_commands.xa_prepare (cumulative)
    The number of MySQL XA PREPARE commands executed
  • mysql_commands.xa_recover (cumulative)
    The number of MySQL XA RECOVER commands executed
  • mysql_commands.xa_rollback (cumulative)
    The number of MySQL XA ROLLBACK commands executed
  • mysql_commands.xa_start (cumulative)
    The number of MySQL XA START commands executed
  • mysql_handler.commit (cumulative)
    The number of internal COMMIT statements.
  • mysql_handler.delete (cumulative)
    The number of times rows have been deleted from tables.
  • mysql_handler.external_lock (cumulative)
    The number of external_lock occurences.
  • mysql_handler.prepare (cumulative)
    The number of times β€œPrepare” phase was executed in the two-phase commit operations.
  • mysql_handler.read_first (cumulative)
    The number of times the first entry in an index was read.
  • mysql_handler.read_key (cumulative)
    The number of times a row was read based on a key.
  • mysql_handler.read_next (cumulative)
    The number of requests to read the next row in key order.
  • mysql_handler.read_prev (cumulative)
    The number of requests to read the previous row in key order.
  • mysql_handler.read_rnd (cumulative)
    The number of requests that read a random fixed position in the data file.
  • mysql_handler.read_rnd_next (cumulative)
    The number of requests for the next row in the data file.
  • mysql_handler.rollback (cumulative)
    The number of requests for a rollback operation on the storage engine.
  • mysql_handler.savepoint (cumulative)
    The number of requests to place a savepoint on the storage engine. This can be used to roll back later.
  • mysql_handler.savepoint_rollback (cumulative)
    The number of requests to roll back to a savepoint.
  • mysql_handler.update (cumulative)
    The number of requests to update a row in a table.
  • mysql_handler.write (cumulative)
    The number of requests to insert a row in a table.
  • mysql_locks.immediate (cumulative)
    The number of MySQL table locks which were granted immediately.
  • mysql_locks.waited (cumulative)
    The number of MySQL table locks which had to wait before being granted.
  • mysql_octets.rx (cumulative)
    The number of bytes received by MySQL server from all clients.
  • mysql_octets.tx (cumulative)
    The number of bytes sent by MySQL server to all clients.
  • mysql_select.full_join (cumulative)
    The number of joins that perform full table scans.
  • mysql_select.full_range_join (cumulative)
    The number of joins that used a range search on a reference table.
  • mysql_select.range (cumulative)
    The number of joins that used a range on the first table.
  • mysql_select.range_check (cumulative)
    The number of joins without keys that check for key usage after each row.
  • mysql_select.scan (cumulative)
    The number of joins that did a full scan of the first table.
  • mysql_slow_queries (cumulative)
    The number of queries that have taken more than long_query_time seconds.
  • mysql_sort.range (cumulative)
    The number of sorts that were done using ranges.
  • mysql_sort.scan (cumulative)
    The number of sorts that were done by scanning the table.
  • mysql_sort_merge_passes (cumulative)
    The number of merge passes done by the sorting algorithm.
  • mysql_sort_rows (cumulative)
    The number of rows that were sorted.
  • threads.cached (gauge)
    The number of threads cached by MySQL for re-use on a new client connection. A MySQL thread corresponds to a single MySQL connection.
  • threads.connected (gauge)
    The number of currently open MySQL connections. A MySQL thread corresponds to a single MySQL connection.
  • threads.running (gauge)
    The number of MySQL threads that are processing a query. A MySQL thread corresponds to a single MySQL connection.
  • total_threads.created (cumulative)
    The total number of threads created by MySQL for client connections. A MySQL thread corresponds to a single MySQL connection.

Non-default metrics (version 4.7.0+) πŸ”—

The following information applies to the agent version 4.7.0+ that has enableBuiltInFiltering: true set on the top level of the agent config.

To emit metrics that are not default, you can add those metrics in the generic monitor-level extraMetrics config option. Metrics that are derived from specific configuration options that do not appear in the above list of metrics do not need to be added to extraMetrics.

To see a list of metrics that will be emitted you can run agent-status monitors after configuring this monitor in a running agent instance.

Legacy non-default metrics (version < 4.7.0) πŸ”—

The following information only applies to agent version older than 4.7.0. If you have a newer agent and have set enableBuiltInFiltering: true at the top level of your agent config, see the section above. See upgrade instructions in Old-style whitelist filtering.

If you have a reference to the whitelist.json in your agent’s top-level metricsToExclude config option, and you want to emit metrics that are not in that whitelist, then you need to add an item to the top-level metricsToInclude config option to override that whitelist (see Inclusion filtering. Or you can just copy the whitelist.json, modify it, and reference that in metricsToExclude.