Sysdig Documentation

MySQL Metrics

See also: MySQL integration information.

mysql.galera.wsrep_cluster_size

The current number of nodes in the Galera cluster.

mysql.innodb.buffer_pool_free

The number of free pages in the InnoDB Buffer Pool.

mysql.innodb.buffer_pool_total

The total number of pages in the InnoDB Buffer Pool.

mysql.innodb.buffer_pool_used

The number of used pages in the InnoDB Buffer Pool.

mysql.innodb.buffer_pool_utilization

The utilization of the InnoDB Buffer Pool.

mysql.innodb.current_row_locks

The number of current row locks.

mysql.innodb.data_reads

The rate of data reads.

mysql.innodb.data_writes

The rate of data writes.

mysql.innodb.mutex_os_waits

The rate of mutex OS waits.

mysql.innodb.mutex_spin_rounds

The rate of mutex spin rounds.

mysql.innodb.mutex_spin_waits

The rate of mutex spin waits.

mysql.innodb.os_log_fsyncs

The rate of fsync writes to the log file.

mysql.innodb.row_lock_time

The fraction of time spent (ms/s) acquring row locks.

mysql.innodb.row_lock_waits

The number of times per second a row lock had to be waited for.

mysql.net.connections

The rate of connections to the server.

mysql.net.max_connections

The maximum number of connections that have been in use simultaneously since the server started.

mysql.performance.com_delete

The rate of delete statements.

mysql.performance.com_delete_multi

The rate of delete-multi statements.

mysql.performance.com_insert

The rate of insert statements.

mysql.performance.com_insert_select

The rate of insert-select statements.

mysql.performance.com_replace_select

The rate of replace-select statements.

mysql.performance.com_select

The rate of select statements.

mysql.performance.com_update

The rate of update statements.

mysql.performance.com_update_multi

The rate of update-multi.

mysql.performance.created_tmp_disk_tables

The rate of internal on-disk temporary tables created by second by the server while executing statements.

mysql.performance.created_tmp_files

The rate of temporary files created by second.

mysql.performance.created_tmp_tables

The rate of internal temporary tables created by second by the server while executing statements.

mysql.performance.kernel_time

The percentage of CPU time spent in kernel space by MySQL.

mysql.performance.key_cache_utilization

The key cache utilization ratio.

mysql.performance.open_files

The number of open files.

mysql.performance.open_tables

The number of of tables that are open.

mysql.performance.qcache_hits

The rate of query cache hits.

mysql.performance.queries

The rate of queries.

mysql.performance.questions

The rate of statements executed by the server.

mysql.performance.slow_queries

The rate of slow queries.

mysql.performance.table_locks_waited

The total number of times that a request for a table lock could not be granted immediately and a wait was needed.

mysql.performance.table_locks_waited.gauge

mysql.performance.threads_connected

The number of currently open connections.

mysql.performance.threads_running

The number of threads that are not sleeping.

mysql.performance.user_time

The percentage of CPU time spent in user space by MySQL.

mysql.replication.seconds_behind_master

The lag in seconds between the master and the slave.

mysql.replication.slave_running

A boolean showing if this server is a replication slave that is connected to a replication master.

mysql.replication.slaves_connected

The number of slaves connected to a replication master.