Docs » Integrations Guide » Integrations Reference » MySQL

image0 MySQL

Metadata associated with the MySQL collectd plugin can be found here. The relevant code for the plugin can be found here.

DESCRIPTION

Use the MySQL plugin for collectd to monitor MySQL database performance.

This plugin 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

FEATURES

Built-in dashboards

  • MySQL Nodes: Overview of data from all MySQL nodes.

image1

  • MySQL Node: Focus on a single MySQL node.

image2

REQUIREMENTS AND DEPENDENCIES

Version information

Software Version
collectd 3.6 or later
MySQL 4.x or later

INSTALLATION

If you are using the new Smart Agent, see the docs for thecollectd/mysqlmonitor for more information. The configuration documentation below may be helpful as well, but consult the Smart Agent repo’s docs for the exact schema.

Follow these steps to install and configure this plugin:

  1. Installing the plugin:

    • On RHEL/CentOS and Amazon Linux systems, run the following command to install this plugin:

      yum install collectd-mysql
      
    • On Ubuntu and Debian systems, this plugin is included by default with the SignalFx collectd agent.

  2. Download SignalFx’s sample configuration file for this plugin to /etc/collectd/managed_config.

  3. Modify the sample configuration file as described in Configuration, below.

  4. Restart collectd.

CONFIGURATION

Using the example configuration file 10-mysql.conf as a guide, provide values for the configuration options listed below that make sense for your environment and allow you to connect to the MySQL instance to be monitored.

configuration option definition example value
Database (in block declaration) The value of the dimension plugin_instance that will be recorded for this database. <Database hostA_database1>
Host The host on which MySQL is running. “10.128.8.2”
Socket A socket that collectd can use to connect to the database. You may be able to find this value by looking at the command used to run MySQL on your server as follows: <code>ps auwxxx &#124; grep mysql<code> “/var/run/mysqld/mysqld.sock”
Port Can be used to connect to the database in lieu of specifying a Socket 3306
User A valid username that collectd can use to connect to MySQL. “root”
Password Password for the username given in User. “abcdABCD1.”
Database (within block) The name of the MySQL database to monitor. Database "mysql\_one"

Note: Monitoring multiple instances

The sample configuration file 10-mysql.conf illustrates how to configure this plugin to monitor multiple databases, on the same host or on different hosts.

To monitor just one database, include just one Database block and delete the others.

Note: Two different directives called “Database”

This plugin configuration file uses directives called Database in two different places: one in each block declaration, and one within each block.

The value of Database in the block declaration (<Database foo>) indicates the value of the plugin_instance dimension that will be recorded for this database. The value of Database within the block (Database "my_database") indicates the db_name of the MySQL database to monitor using this configuration.

To illustrate the difference between these two uses of “Database”, the example configuration given in 10-mysql.conf directs collectd to collect metrics for three total MySQL databases: the databases named mysql_one and mysql_two on host 10.128.8.2, and the database named mysql_one on host 10.128.8.3.

Note: Monitoring a MySQL environment that is configured for replication

If you have configured MySQL to use replication you may want to collect information relevant to the performance and status of your master and/or slave nodes. This can be achieved by utilizing the MasterStats, SlaveStats, and SlaveNotifications options as described in 10-mysql.conf

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 oncollectd.org.

Monitoring multiple MySQL nodes

image3

Example dashboard showing performance of multiple MySQL nodes.

Monitoring a single MySQL node

image4

Example dashboard showing performance of a single MySQL node.

METRICS

Note: This plugin may not emit all listed metrics

This plugin will not emit metrics about features that are not used. For example, this plugin will not emit a count of an operation that has never occurred. For another example, this plugin will not emit metrics about the query cache if MySQL is not configured to use the query cache.

Below is a list of all metrics.

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

counter.mysql_commands.admin_commands

counter

The number of MySQL ADMIN commands executed

counter.mysql_commands.alter_db

counter

The number of MySQL ALTER DB commands executed

counter.mysql_commands.alter_db_upgrade

counter

The number of MySQL ALTER DB UPGRADE commands executed

counter.mysql_commands.alter_event

counter

The number of MySQL ALTER EVENT commands executed

counter.mysql_commands.alter_function

counter

The number of MySQL ALTER FUNCTION commands executed

counter.mysql_commands.alter_procedure

counter

The number of MySQL ALTER PROCEDURE commands executed

counter.mysql_commands.alter_server

counter

The number of MySQL ALTER SERVER commands executed

counter.mysql_commands.alter_table

counter

The number of MySQL ALTER TABLE commands executed

counter.mysql_commands.alter_tablespace

counter

The number of MySQL ALTER TABLESPACE commands executed

counter.mysql_commands.alter_user

counter

The number of MySQL ALTER USER commands executed

counter.mysql_commands.analyze

counter

The number of MySQL ANALYZE commands executed

counter.mysql_commands.assign_to_keycache

counter

The number of MySQL ASSIGN TO KEYCACHE commands executed

counter.mysql_commands.begin

counter

The number of MySQL BEGIN commands executed

counter.mysql_commands.binlog

counter

The number of MySQL BINLOG commands executed

counter.mysql_commands.call_procedure

counter

The number of MySQL CALL PROCEDURE commands executed

counter.mysql_commands.change_db

counter

The number of MySQL CHANGE DB commands executed

counter.mysql_commands.change_master

counter

The number of MySQL CHANGE MASTER commands executed

counter.mysql_commands.check

counter

The number of MySQL CHECK commands executed

counter.mysql_commands.checksum

counter

The number of MySQL CHECKSUM commands executed

counter.mysql_commands.commit

counter

The number of MySQL COMMIT commands executed

counter.mysql_commands.create_db

counter

The number of MySQL CREATE DB commands executed

counter.mysql_commands.create_event

counter

The number of MySQL CREATE EVENT commands executed

counter.mysql_commands.create_function

counter

The number of MySQL CREATE FUNCTION commands executed

counter.mysql_commands.create_index

counter

The number of MySQL CREATE INDEX commands executed

counter.mysql_commands.create_procedure

counter

The number of MySQL CREATE PROCEDURE commands executed

counter.mysql_commands.create_server

counter

The number of MySQL CREATE SERVER commands executed

counter.mysql_commands.create_table

counter

The number of MySQL CREATE TABLE commands executed

counter.mysql_commands.create_trigger

counter

The number of MySQL CREATE TRIGGER commands executed

counter.mysql_commands.create_udf

counter

The number of MySQL CREATE UDF commands executed

counter.mysql_commands.create_user

counter

The number of MySQL CREATE USER commands executed

counter.mysql_commands.create_view

counter

The number of MySQL CREATE VIEW commands executed

counter.mysql_commands.dealloc_sql

counter

The number of MySQL DEALLOC SQL commands executed

counter.mysql_commands.delete

counter

The number of MySQL DELETE commands executed

counter.mysql_commands.delete_multi

counter

The number of MySQL DELETE MULTI commands executed

counter.mysql_commands.do

counter

The number of MySQL DO commands executed

counter.mysql_commands.drop_db

counter

The number of MySQL DROP DB commands executed

counter.mysql_commands.drop_event

counter

The number of MySQL DROP EVENT commands executed

counter.mysql_commands.drop_function

counter

The number of MySQL DROP FUNCTION commands executed

counter.mysql_commands.drop_index

counter

The number of MySQL DROP INDEX commands executed

counter.mysql_commands.drop_procedure

counter

The number of MySQL DROP PROCEDURE commands executed

counter.mysql_commands.drop_server

counter

The number of MySQL DROP SERVER commands executed

counter.mysql_commands.drop_table

counter

The number of MySQL DROP TABLE commands executed

counter.mysql_commands.drop_trigger

counter

The number of MySQL DROP TRIGGER commands executed

counter.mysql_commands.drop_user

counter

The number of MySQL DROP USER commands executed

counter.mysql_commands.drop_view

counter

The number of MySQL DROP VIEW commands executed

counter.mysql_commands.empty_query

counter

The number of MySQL EMPTY QUERY commands executed

counter.mysql_commands.execute_sql

counter

The number of MySQL EXECUTE SQL commands executed

counter.mysql_commands.flush

counter

The number of MySQL FLUSH commands executed

counter.mysql_commands.get_diagnostics

counter

The number of MySQL GET DIAGNOSTICS commands executed

counter.mysql_commands.grant

counter

The number of MySQL GRANT commands executed

counter.mysql_commands.ha_close

counter

The number of MySQL HA CLOSE commands executed

counter.mysql_commands.ha_open

counter

The number of MySQL HA OPEN commands executed

counter.mysql_commands.ha_read

counter

The number of MySQL HA READ commands executed

counter.mysql_commands.help

counter

The number of MySQL HELP commands executed

counter.mysql_commands.insert

counter

The number of MySQL INSERT commands executed

counter.mysql_commands.insert_select

counter

The number of MySQL INSERT SELECT commands executed

counter.mysql_commands.install_plugin

counter

The number of MySQL INSTALL PLUGIN commands executed

counter.mysql_commands.kill

counter

The number of MySQL KILL commands executed

counter.mysql_commands.load

counter

The number of MySQL LOAD commands executed

counter.mysql_commands.lock_tables

counter

The number of MySQL LOCK TABLES commands executed

counter.mysql_commands.optimize

counter

The number of MySQL OPTIMIZE commands executed

counter.mysql_commands.preload_keys

counter

The number of MySQL PRELOAD KEYS commands executed

counter.mysql_commands.prepare_sql

counter

The number of MySQL PREPARE SQL commands executed

counter.mysql_commands.purge

counter

The number of MySQL PURGE commands executed

counter.mysql_commands.purge_before_date

counter

The number of MySQL PURGE BEFORE DATE commands executed

counter.mysql_commands.release_savepoint

counter

The number of MySQL RELEASE SAVEPOINT commands executed

counter.mysql_commands.rename_table

counter

The number of MySQL RENAME TABLE commands executed

counter.mysql_commands.rename_user

counter

The number of MySQL RENAME USER commands executed

counter.mysql_commands.repair

counter

The number of MySQL REPAIR commands executed

counter.mysql_commands.replace

counter

The number of MySQL REPLACE commands executed

counter.mysql_commands.replace_select

counter

The number of MySQL REPLACE SELECT commands executed

counter.mysql_commands.reset

counter

The number of MySQL RESET commands executed

counter.mysql_commands.resignal

counter

The number of MySQL RESIGNAL commands executed

counter.mysql_commands.revoke

counter

The number of MySQL REVOKE commands executed

counter.mysql_commands.revoke_all

counter

The number of MySQL REVOKE ALL commands executed

counter.mysql_commands.rollback

counter

The number of MySQL ROLLBACK commands executed

counter.mysql_commands.rollback_to_savepoint

counter

The number of MySQL ROLLBACK TO SAVEPOINT commands executed

counter.mysql_commands.savepoint

counter

The number of MySQL SAVEPOINT commands executed

counter.mysql_commands.select

counter

The number of MySQL SELECT commands executed

counter.mysql_commands.set_option

counter

The number of MySQL SET OPTION commands executed

counter.mysql_commands.show_binlog_events

counter

The number of MySQL SHOW BINLOG EVENTS commands executed

counter.mysql_commands.show_binlogs

counter

The number of MySQL SHOW BINLOGS commands executed

counter.mysql_commands.show_charsets

counter

The number of MySQL SHOW CHARSETS commands executed

counter.mysql_commands.show_collations

counter

The number of MySQL SHOW COLLATIONS commands executed

counter.mysql_commands.show_create_db

counter

The number of MySQL SHOW CREATE DB commands executed

counter.mysql_commands.show_create_event

counter

The number of MySQL SHOW CREATE EVENT commands executed

counter.mysql_commands.show_create_func

counter

The number of MySQL SHOW CREATE FUNC commands executed

counter.mysql_commands.show_create_proc

counter

The number of MySQL SHOW CREATE PROC commands executed

counter.mysql_commands.show_create_table

counter

The number of MySQL SHOW CREATE TABLE commands executed

counter.mysql_commands.show_create_trigger

counter

The number of MySQL SHOW CREATE TRIGGER commands executed

counter.mysql_commands.show_databases

counter

The number of MySQL SHOW DATABASES commands executed

counter.mysql_commands.show_engine_logs

counter

The number of MySQL SHOW ENGINE LOGS commands executed

counter.mysql_commands.show_engine_mutex

counter

The number of MySQL SHOW ENGINE MUTEX commands executed

counter.mysql_commands.show_engine_status

counter

The number of MySQL SHOW ENGINE STATUS commands executed

counter.mysql_commands.show_errors

counter

The number of MySQL SHOW ERRORS commands executed

counter.mysql_commands.show_events

counter

The number of MySQL SHOW EVENTS commands executed

counter.mysql_commands.show_fields

counter

The number of MySQL SHOW FIELDS commands executed

counter.mysql_commands.show_function_code

counter

The number of MySQL SHOW FUNCTION CODE commands executed

counter.mysql_commands.show_function_status

counter

The number of MySQL SHOW FUNCTION STATUS commands executed

counter.mysql_commands.show_grants

counter

The number of MySQL SHOW GRANTS commands executed

counter.mysql_commands.show_keys

counter

The number of MySQL SHOW KEYS commands executed

counter.mysql_commands.show_master_status

counter

The number of MySQL SHOW MASTER STATUS commands executed

counter.mysql_commands.show_open_tables

counter

The number of MySQL SHOW OPEN TABLES commands executed

counter.mysql_commands.show_plugins

counter

The number of MySQL SHOW PLUGINS commands executed

counter.mysql_commands.show_privileges

counter

The number of MySQL SHOW PRIVILEGES commands executed

counter.mysql_commands.show_procedure_code

counter

The number of MySQL SHOW PROCEDURE CODE commands executed

counter.mysql_commands.show_procedure_status

counter

The number of MySQL SHOW PROCEDURE STATUS commands executed

counter.mysql_commands.show_processlist

counter

The number of MySQL SHOW PROCESSLIST commands executed

counter.mysql_commands.show_profile

counter

The number of MySQL SHOW PROFILE commands executed

counter.mysql_commands.show_profiles

counter

The number of MySQL SHOW PROFILES commands executed

counter.mysql_commands.show_relaylog_events

counter

The number of MySQL SHOW RELAYLOG EVENTS commands executed

counter.mysql_commands.show_slave_hosts

counter

The number of MySQL SHOW SLAVE HOSTS commands executed

counter.mysql_commands.show_slave_status

counter

The number of MySQL SHOW SLAVE STATUS commands executed

counter.mysql_commands.show_status

counter

The number of MySQL SHOW STATUS commands executed

counter.mysql_commands.show_storage_engines

counter

The number of MySQL SHOW STORAGE ENGINES commands executed

counter.mysql_commands.show_table_status

counter

The number of MySQL SHOW TABLE STATUS commands executed

counter.mysql_commands.show_tables

counter

The number of MySQL SHOW TABLES commands executed

counter.mysql_commands.show_triggers

counter

The number of MySQL SHOW TRIGGERS commands executed

counter.mysql_commands.show_variables

counter

The number of MySQL SHOW VARIABLES commands executed

counter.mysql_commands.show_warnings

counter

The number of MySQL SHOW WARNINGS commands executed

counter.mysql_commands.signal

counter

The number of MySQL SIGNAL commands executed

counter.mysql_commands.slave_start

counter

The number of MySQL SLAVE START commands executed

counter.mysql_commands.slave_stop

counter

The number of MySQL SLAVE STOP commands executed

counter.mysql_commands.truncate

counter

The number of MySQL TRUNCATE commands executed

counter.mysql_commands.uninstall_plugin

counter

The number of MySQL UNINSTALL PLUGIN commands executed

counter.mysql_commands.unlock_tables

counter

The number of MySQL UNLOCK TABLES commands executed

counter.mysql_commands.update

counter

The number of MySQL UPDATE commands executed

counter.mysql_commands.update_multi

counter

The number of MySQL UPDATE MULTI commands executed

counter.mysql_commands.xa_commit

counter

The number of MySQL XA COMMIT commands executed

counter.mysql_commands.xa_end

counter

The number of MySQL XA END commands executed

counter.mysql_commands.xa_prepare

counter

The number of MySQL XA PREPARE commands executed

counter.mysql_commands.xa_recover

counter

The number of MySQL XA RECOVER commands executed

counter.mysql_commands.xa_rollback

counter

The number of MySQL XA ROLLBACK commands executed

counter.mysql_commands.xa_start

counter

The number of MySQL XA START commands executed

counter.mysql_handler.commit

counter

The number of internal COMMIT statements.

counter.mysql_handler.delete

counter

The number of times rows have been deleted from tables.

counter.mysql_handler.prepare

counter

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

counter.mysql_handler.read_first

counter

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

counter.mysql_handler.read_key

counter

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

counter.mysql_handler.read_prev

counter

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

counter.mysql_handler.read_rnd

counter

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

counter.mysql_handler.read_rnd_next

counter

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

counter.mysql_handler.rollback

counter

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

counter.mysql_handler.savepoint

counter

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

counter.mysql_handler.savepoint_rollback

counter

The number of requests to roll back to a savepoint.

counter.mysql_handler.update

counter

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

counter.mysql_handler.write

counter

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

counter.mysql_locks.immediate

counter

The number of MySQL table locks which were granted immediately.

counter.mysql_locks.waited

counter

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

counter.mysql_select.full_join

counter

The number of joins that perform full table scans.

counter.mysql_select.full_range_join

counter

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

counter.mysql_select.range

counter

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

counter.mysql_select.range_check

counter

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

counter.mysql_sort.merge_passes

counter

The number of merge passes done by the sorting algorithm.

counter.mysql_sort.range

counter

The number of sorts that were done using ranges.

counter.mysql_sort.rows

counter

The number of rows that were sorted.

counter.mysql_sort.scan

counter

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

derive.cache_result.qcache-hits

cumulative counter

The number of hits on MySQL query cache.

derive.cache_result.qcache-inserts

cumulative counter

The number of inserts into MySQL query cache.

derive.cache_results.qcache-not_cached

cumulative counter

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

derive.cache_results.qcache-prunes

cumulative counter

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

derive.mysql_octets.rx

cumulative counter

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

derive.mysql_octets.tx

cumulative counter

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

derive.total_threads.created

cumulative counter

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

gauge.cache_results.cache_size

gauge

The number of queries in MySQL query cache.

gauge.cache_size.qcache

gauge

The number of queries in MySQL query cache.

gauge.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.

gauge.threads.connected

gauge

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

gauge.threads.running

gauge

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