Skip to content

New information schema tables

Jump to bottom
Manuel edited this page Aug 25, 2016 · 1 revision

Information Schema

ERROR_STATISTICS

Stats about total number of errors and when they were last seen

  • ERROR_CODE
  • ERROR_NAME
    • eg. ER_NO_SUCH_TABLE
  • ERROR_LAST_SEEN
    • Timestamp of when error last seen
  • ERRORS_TOTAL
    • Total count of such error

INDEX_STATISTICS

  • TABLE_SCHEMA
  • TABLE_NAME
  • INDEX_NAME
  • TABLE_ENGINE
    • eg. InnoDB, MyISAM
  • ROWS_INSERTED
  • ROWS_UPDATED
  • ROWS_DELETED
  • ROWS_READ
  • ROWS_REQUESTED
    • Number of row read attempts for an index of this table. This counts requests that do not return a row.
  • ROWS_INDEX_FIRST
    • Total number of rows fetched on index scans from first cursor use.
    • Excludes rows counted for ROWS_INDEX_NEXT.
    • Excludes rows fetched from table scans.
  • ROWS_INDEX_NEXT
    • Total number of rows fetched on index scans after the first row.
    • This includes rows fetched from index_next and index_prev.
    • Excludes rows fetched from table scans.
  • IO_READ_BYTES
    • Total bytes read.
  • IO_READ_REQUESTS
    • Total read requests.
  • IO_READ_SVC_USECS
    • Total microseconds spent doing reads.
  • IO_READ_SVC_USECS_MAX
    • Max microseconds doing a single read.
  • IO_READ_WAIT_USECS
    • Total microseconds waiting for reads.
  • IO_READ_WAIT_USECS_MAX
    • Max microseconds waiting for a single read.
  • IO_READ_SLOW_IOS
    • Number of reads resulting in "slow" ios. (configuerable through global variable)

TABLE_STATISTICS

Per-tablespace stats. Special tables are included under the “sys:innodb” schema for system tablespace, doublewrite, log and “other” unknown tables.

  • TABLE_SCHEMA
  • TABLE_NAME
  • TABLE_ENGINE
  • ROWS_INSERTED
  • ROWS_UPDATED
  • ROWS_DELETED
  • ROWS_READ
  • ROWS_REQUESTED
  • COMPRESSED_PAGE_SIZE
    • Size of the compressed data on the page
  • COMPRESS_PADDING
    • Current padding for compression
  • COMPRESS_OPS
    • Number of page compressions
  • COMPRESS_OPS_OK
    • Number of successful page compressions
  • COMPRESS_PRIMARY_OPS
    • Number of compressions in primary index
  • COMPRESS_PRIMARY_OPS_OK
    • Number of successful compressions in primary index
  • COMPRESS_USECS
    • Total duration of page compressions
  • COMPRESS_OK_USECS
    • Total duration of successful page compressions
  • COMPRESS_PRIMARY_USECS
    • Total duration of primary index page compressions
  • COMPRESS_PRIMARY_OK_USECS
    • Total duration of successful primary index page compressions
  • UNCOMPRESS_OPS
  • UNCOMPRESS_USECS
  • ROWS_INDEX_FIRST
    • Total number of rows fetched on index scans from first cursor use.
    • Excludes rows counted for ROWS_INDEX_NEXT.
    • Excludes rows fetched from table scans.
  • ROWS_INDEX_NEXT
    • Total number of rows fetched on index scans after the first row.
    • This includes rows fetched from index_next and index_prev.
    • Excludes rows fetched from table scans.
  • IO_READ_BYTES
  • IO_READ_REQUESTS
  • IO_READ_SVC_USECS
  • IO_READ_SVC_USECS_MAX
  • IO_READ_WAIT_USECS
    • total time in the request array
  • IO_READ_WAIT_USECS_MAX
  • IO_READ_SLOW_IOS
    • Stats for reads
  • IO_WRITE_BYTES
  • IO_WRITE_REQUESTS
  • IO_WRITE_SVC_USECS
  • IO_WRITE_SVC_USECS_MAX
  • IO_WRITE_WAIT_USECS
  • IO_WRITE_WAIT_USECS_MAX
  • IO_WRITE_SLOW_IOS
    • Stats for writes
  • IO_READ_BYTES_BLOB
  • IO_READ_REQUESTS_BLOB
  • IO_READ_SVC_USECS_BLOB
  • IO_READ_SVC_USECS_MAX_BLOB
  • IO_READ_WAIT_USECS_BLOB
  • IO_READ_WAIT_USECS_MAX_BLOB
  • IO_READ_SLOW_IOS_BLOB
    • Stats for blob reads
  • IO_READ_BYTES_PRIMARY
  • IO_READ_REQUESTS_PRIMARY
  • IO_READ_SVC_USECS_PRIMARY
  • IO_READ_SVC_USECS_MAX_PRIMARY
  • IO_READ_WAIT_USECS_PRIMARY
  • IO_READ_WAIT_USECS_MAX_PRIMARY
  • IO_READ_SLOW_IOS_PRIMARY
    • Reads for PK indexes
  • IO_READ_BYTES_SECONDARY
  • IO_READ_REQUESTS_SECONDARY
  • IO_READ_SVC_USECS_SECONDARY
  • IO_READ_SVC_USECS_MAX_SECONDARY
  • IO_READ_WAIT_USECS_SECONDARY
  • IO_READ_WAIT_USECS_MAX_SECONDARY
  • IO_READ_SLOW_IOS_SECONDARY
    • Reads for secondary indexes
  • IO_INDEX_INSERTS
    • Total number of inserts into index
  • QUERIES_USED
    • Total number of times a table has been used in an SQL statement.
  • QUERIES_EMPTY
    • Number of select queries that return no rows (joins increment all tables)
  • COMMENT_BYTES
    • Number of bytes in the query that are comments (joins increment all tables)
  • INNODB_ROW_LOCK_WAITS
    • Number of lock waits (DB_LOCK_WAIT)
  • INNODB_ROW_LOCK_WAIT_TIMEOUTS
    • Number of lock wait timeouts (DB_LOCK_WAIT_TIMEOUT)
  • INNODB_PAGES_READ
  • INNODB_PAGES_READ_INDEX
  • INNODB_PAGES_READ_BLOB
  • INNODB_PAGES_WRITTEN
  • INNODB_PAGES_WRITTEN_INDEX
  • INNODB_PAGES_WRITTEN_BLOB

DB_STATISTICS

Shows total number of distinct pages accessed using hyperloglog based on space id and offset.

  • DB
  • WORKING_SET_SIZE

USER_LATENCY_HISTOGRAMS

Gives bucketed latencies per user for these operations: UPDATE, DELETE, INSERT, SELECT, DDL, TRANSACTION, HANDLER, OTHER, CONNECTION_CREATE

  • USER_NAME
  • TYPE
  • STEP_SIZE
  • VALUE_BIN1 ... VALUE_BIN15

USER_STATISTICS

  • USER_NAME
  • BINLOG_BYTES_WRITTEN
  • BINLOG_DISK_READS
    • Count how many disk reads are performed by mysql_binlog_send
  • BYTES_RECEIVED
  • BYTES_SENT
    • Bytes sent/received
  • COMMANDS_DDL
  • COMMANDS_DELETE
  • COMMANDS_HANDLER
  • COMMANDS_INSERT
  • COMMANDS_OTHER
  • COMMANDS_SELECT
  • COMMANDS_TRANSACTION
  • COMMANDS_UPDATE
    • Total commands of each type executed
  • CONNECTIONS_CONCURRENT
    • Current number of connections for this user
  • CONNECTIONS_DENIED_MAX_GLOBAL
    • Total connections denied over global limit
  • CONNECTIONS_DENIED_MAX_USER
    • Total connections denied over per user limit
  • CONNECTIONS_LOST
    • Total connections closed on error
  • CONNECTIONS_TOTAL
    • Total connections created
  • DISK_READ_BYTES
  • DISK_READ_REQUESTS
  • DISK_READ_SVC_USECS
  • DISK_READ_WAIT_USECS
    • Stats on disk reads
  • DISK_READ_BYTES_BLOB
  • DISK_READ_REQUESTS_BLOB
  • DISK_READ_SVC_USECS_BLOB
  • DISK_READ_WAIT_USECS_BLOB
    • Stats on disk reads for blobs
  • DISK_READ_BYTES_PRIMARY
  • DISK_READ_REQUESTS_PRIMARY
  • DISK_READ_SVC_USECS_PRIMARY
  • DISK_READ_WAIT_USECS_PRIMARY
    • Stats on disk reads for PK indexes
  • DISK_READ_BYTES_SECONDARY
  • DISK_READ_REQUESTS_SECONDARY
  • DISK_READ_SVC_USECS_SECONDARY
  • DISK_READ_WAIT_USECS_SECONDARY
    • Stats on disk reads for secondary indexes
  • ERRORS_ACCESS_DENIED
  • ERRORS_NET_TOTAL
    • Total network errors
  • ERRORS_NET_ER_NET_ERROR_ON_WRITE
  • ERRORS_NET_ER_NET_PACKETS_OUT_OF_ORDER
  • ERRORS_NET_ER_NET_PACKET_TOO_LARGE
  • ERRORS_net_ER_NET_READ_ERROR
  • ERRORS_net_ER_NET_READ_INTERRUPTED
  • ERRORS_net_ER_NET_UNCOMPRESS_ERROR
  • ERRORS_net_ER_NET_WRITE_INTERRUPTED
    • Various total counts of network errors
  • ERRORS_TOTAL
  • MICROSECONDS_WALL
    • Microseconds spent in total
  • MICROSECONDS_DDL
  • MICROSECONDS_DELETE
  • MICROSECONDS_HANDLER
  • MICROSECONDS_INSERT
  • MICROSECONDS_OTHER
  • MICROSECONDS_SELECT
  • MICROSECONDS_TRANSACTION
  • MICROSECONDS_UPDATE
    • Microseconds spent in total for each command type (OTHER denotes everything else)
  • QUERIES_EMPTY
    • Number of queries that return no rows
  • QUERY_COMMENT_BYTES
    • Number of bytes that are comments
  • RELAY_LOG_BYTES_WRITTEN
    • Bytes written to relay logs (only useful for sys:slave user)
  • ROWS_DELETED
  • ROWS_FETCHED
  • ROWS_INSERTED
  • ROWS_READ
  • ROWS_UPDATED
  • ROWS_INDEX_FIRST
  • ROWS_INDEX_NEXT
    • Same as above
  • TRANSACTIONS_COMMIT
    • Transactions committed
  • TRANSACTIONS_ROLLBACK
    • Transactions rolled back
  • GTID_UNSAFE_CREATE_SELECTk
  • GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION
  • GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
  • CONNECTIONS_SSL_TOTAL
    • Total SSL connections created

AUTHINFO

Gives authentication information, specifically the certificate (if any) used for connection

  • ID
  • USER
  • HOST
  • SSL
  • INFO

INNODB_FILE_STATUS

Per tablespace stats. Different from table statistics which merges all partitions into one table.

  • FILE
  • OPERATION
    • read or write
  • REQUESTS
  • SLOW
    • slow io (configurable)
  • BYTES
    • Total bytes
  • BYTES/R
    • bytes per request
  • SVC:SECS
  • SVC:MSECS/R
  • SVC:MAX_MSECS
  • WAIT:SECS
  • WAIT:MSECS/R
  • WAIT:MAX_MSECS

GLOBAL_STATUS

  • BINLOG_BYTES_WRITTEN
    • Binlog bytes written
  • BINLOG_FSYNC_COUNT
    • Binlog fsyncs
  • COMMAND_SECONDS
    • Wall time spent handling client commands
  • COMMAND_SLAVE_SECONDS
    • Wall time spent executing commands in slave
  • EXEC_SECONDS
    • Time spent executing client commands
  • PARSE_SECONDS
    • Time spent parsing client commands
  • PRE_EXEC_SECONDS
    • Time spent post-parse but pre-execution.
  • OPEN_TABLES_SECONDS
    • Time spent in open_table
  • READ_REQUESTS
    • Number of IO read requests
  • READ_SECONDS
    • Time spent on IO read
  • ROWS_EXAMINED
    • Total rows examined
  • ROWS_SENT
    • Total rows sent
  • CONNECTION_ERRORS_NET_ER_NET_ERROR_ON_WRITE
  • CONNECTION_ERRORS_NET_ER_NET_PACKETS_OUT_OF_ORDER
  • CONNECTION_ERRORS_NET_ER_NET_PACKET_TOO_LARGE
  • CONNECTION_ERRORS_NET_ER_NET_READ_ERROR
  • CONNECTION_ERRORS_NET_ER_NET_READ_INTERRUPTED
  • CONNECTION_ERRORS_NET_ER_NET_UNCOMPRESS_ERROR
  • CONNECTION_ERRORS_NET_ER_NET_WRITE_INTERRUPTED
    • Various errors specific to connections
  • INNODB_ADAPTIVE_HASH_HITS
  • INNODB_ADAPTIVE_HASH_MISSES
    • AHI stats
  • INNODB_BUFFERED_AIO_SUBMITTED
    • Total number of AIO requests submitted
  • INNODB_OUTSTANDING_AIO_REQUESTS
    • Number of AIO requests submitted but not processed
  • INNODB_MAX_OUTSTANDING_AIO_REQUESTS
    • Max of INNODB_OUTSTANDING_AIO_REQUESTS observed so far
  • INNODB_BUFFER_POOL_NEIGHBORS_FLUSHED_FROM_LIST
    • Number of neighbor pages flushed from the buffer pool flush list.
  • INNODB_BUFFER_POOL_NEIGHBORS_FLUSHED_FROM_LRU
    • Number of neighbor pages flushed from the buffer pool LRU list.
    • InnoDB writes dirty pages from the same extent when one of the pages in the extent is eligible to be written.
  • INNODB_BUFFER_POOL_PAGES_DIRTY_PCT
    • Percent of pages dirty
  • INNODB_BUFFER_POOL_PAGES_FLUSHED_BY_LIST
  • INNODB_BUFFER_POOL_PAGES_FLUSHED_BY_LRU
  • INNODB_BUFFER_POOL_PAGES_FLUSHED_BY_SINGLE_PAGE
    • Buffer pool pages flushed by flush list or LRU list or other reasons
  • INNODB_BUFFER_POOL_PAGES_LRU_OLD
    • Number of old pages on the LRU list.
  • INNODB_BUFFER_POOL_PAGES_UNZIP_LRU
    • Number of pages on buf_pool->unzip_LRU
  • INNODB_CHECKPOINT_LSN
    • LSN of last checkpoint
  • INNODB_DATA_ASYNC_READ_BYTES
  • INNODB_DATA_ASYNC_READ_OLD_IOS
  • INNODB_DATA_ASYNC_READ_REQUESTS
  • INNODB_DATA_ASYNC_READ_SLOW_IOS
  • INNODB_DATA_ASYNC_READ_SVC_SECONDS
  • INNODB_DATA_ASYNC_WRITE_BYTES
  • INNODB_DATA_ASYNC_WRITE_OLD_IOS
  • INNODB_DATA_ASYNC_WRITE_REQUESTS
  • INNODB_DATA_ASYNC_WRITE_SLOW_IOS
  • INNODB_DATA_ASYNC_WRITE_SVC_SECONDS
  • INNODB_DATA_DOUBLE_WRITE_BYTES
  • INNODB_DATA_DOUBLE_WRITE_REQUESTS
  • INNODB_DATA_DOUBLE_WRITE_SLOW_IOS
  • INNODB_DATA_DOUBLE_WRITE_SVC_SECONDS
  • INNODB_DATA_FSYNC_MAX_SECONDS
  • INNODB_DATA_FSYNC_SECONDS
  • INNODB_DATA_FSYNC_SLOW
  • INNODB_DATA_LOG_WRITE_BYTES
  • INNODB_DATA_LOG_WRITE_REQUESTS
  • INNODB_DATA_LOG_WRITE_SLOW_IOS
  • INNODB_DATA_LOG_WRITE_SVC_SECONDS
  • INNODB_DATA_SYNC_READ_BYTES
  • INNODB_DATA_SYNC_READ_REQUESTS
  • INNODB_DATA_SYNC_READ_SLOW_IOS
  • INNODB_DATA_SYNC_READ_SVC_SECONDS
  • INNODB_DATA_SYNC_WRITE_BYTES
  • INNODB_DATA_SYNC_WRITE_REQUESTS
  • INNODB_DATA_SYNC_WRITE_SLOW_IOS
  • INNODB_DATA_SYNC_WRITE_SVC_SECONDS
    • Various IO stats. Slow IOs are requests for which service time is too long. Old IOs are requests that wait too long to be serviced (only valid for async IOs)
  • INNODB_DBLWR_PAGE_NUMBER
    • Page number at which doublewrite buffer starts in system tablespace (used for flashcache?).
  • INNODB_DEFRAGMENT_AVG_IDLETIME
  • INNODB_DEFRAGMENT_AVG_RUNTIME
  • INNODB_DEFRAGMENT_RUNTIME_PCT
    • Average idle/runtime of defrag thread in microseconds
    • Average % of time spent running
  • INNODB_DEFRAGMENT_COMPRESSION_FAILURES
    • Number of compression failures during defrag
  • INNODB_DEFRAGMENT_COUNT
    • Number of calls to btr_defragment_n_pages
  • INNODB_DEFRAGMENT_FAILURES
    • Calls to btr_defragment_n_pages for which no pages were merged (wasted work)
  • INNODB_IBUF_DELETE_MARKS
    • Number of records added to the delete mark buffer
  • INNODB_IBUF_DELETES
    • Number of records added to the delete buffer
  • INNODB_IBUF_INSERTS
    • Number of records added to the insert buffer
  • INNODB_IBUF_MERGES
    • Number of secondary index pages updated with merged records
  • INNODB_IBUF_SIZE
    • Size of the insert buffer in pages
  • INNODB_LATENCY_HISTOGRAM_ASYNC_READ_* (in 16us increments)
  • INNODB_LATENCY_HISTOGRAM_ASYNC_WRITE_*
  • INNODB_LATENCY_HISTOGRAM_DOUBLE_WRITE_*
  • INNODB_LATENCY_HISTOGRAM_LOG_WRITE_*
  • INNODB_LATENCY_HISTOGRAM_SYNC_READ_*
  • INNODB_LATENCY_HISTOGRAM_SYNC_WRITE_*
  • INNODB_LATENCY_HISTOGRAM_FILE_FLUSH_TIME_* (in 16ms increments)
  • INNODB_LATENCY_HISTOGRAM_FSYNC_*
    • Histogram of various IO operations
  • INNODB_LOG_CHECKPOINTS
    • Number of checkpoints made so far
  • INNODB_LOG_SYNC_ARCHIVE
  • INNODB_LOG_SYNC_BACKGROUND_ASYNC
  • INNODB_LOG_SYNC_BACKGROUND_SYNC
  • INNODB_LOG_SYNC_CHECKPOINT_ASYNC
  • INNODB_LOG_SYNC_CHECKPOINT_SYNC
  • INNODB_LOG_SYNC_COMMIT_ASYNC
  • INNODB_LOG_SYNC_COMMIT_SYNC
  • INNODB_LOG_SYNC_FLUSH_DIRTY
  • INNODB_LOG_SYNC_OTHER
  • INNODB_LOG_SYNCS
    • Calls to log_write_up_to from various callers and log was sync'd
  • INNODB_LOG_WRITE_ARCHIVE
  • INNODB_LOG_WRITE_BACKGROUND_ASYNC
  • INNODB_LOG_WRITE_BACKGROUND_SYNC
  • INNODB_LOG_WRITE_CHECKPOINT_ASYNC
  • INNODB_LOG_WRITE_CHECKPOINT_SYNC
  • INNODB_LOG_WRITE_COMMIT_ASYNC
  • INNODB_LOG_WRITE_COMMIT_SYNC
  • INNODB_LOG_WRITE_FLUSH_DIRTY
  • INNODB_LOG_WRITE_OTHER
    • Calls to log_write_up_to from various callers
  • INNODB_LSN_CURRENT
    • log_sys->lsn
  • INNODB_LSN_CURRENT_MINUS_LAST_CHECKPOINT
    • lsn - last_checkpoint_lsn
  • INNODB_LSN_CURRENT_MINUS_OLDEST
    • lsn_current - lsn_oldest
  • INNODB_LSN_OLDEST
    • log_buf_pool_get_oldest_modification
  • INNODB_MUTEX_OS_WAITS
    • mutex_os_wait_count
  • INNODB_MUTEX_SPIN_ROUNDS
    • mutex_spin_round_count
  • INNODB_MUTEX_SPIN_WAITS
    • mutex_spin_wait_count
  • INNODB_PAGES_READ_ALLOCATED
  • INNODB_PAGES_READ_BLOB
  • INNODB_PAGES_READ_FSP_HDR
  • INNODB_PAGES_READ_IBUF_BITMAP
  • INNODB_PAGES_READ_IBUF_FREE_LIST
  • INNODB_PAGES_READ_INDEX
  • INNODB_PAGES_READ_INODE
  • INNODB_PAGES_READ_SYS
  • INNODB_PAGES_READ_TRX_SYS
  • INNODB_PAGES_READ_UNDO_LOG
  • INNODB_PAGES_READ_XDES
  • INNODB_PAGES_WRITTEN_{ALLOCATED, BLOB, FSP_HDR, ... (as above) }
    • Pages read and written for each page type
  • INNODB_PURGED_PAGES
    • Pages processed by trx_purge
  • INNODB_PURGE_PENDING
    • Number of transactions for which purge must be done.
  • INNODB_RECORDS_IN_RANGE_SECONDS
    • Time spent in ha_innobase::records_in_range
  • INNODB_ROW_LOCK_DEADLOCKS
    • Number of transaction aborts from lock wait
  • INNODB_ROW_LOCK_WAIT_TIMEOUTS
    • Number of transaction aborts from lock wait
  • INNODB_ROW_RECREATIONS
    • Number of times row was recreated from old version
  • INNODB_ROW_RECREATION_STEPS
    • Total number of steps that InnoDB had to walk through to find old version
  • INNODB_RWLOCK_S_OS_WAITS
  • INNODB_RWLOCK_S_SPIN_ROUNDS
  • INNODB_RWLOCK_S_SPIN_WAITS
  • INNODB_RWLOCK_X_OS_WAITS
  • INNODB_RWLOCK_X_SPIN_ROUNDS
  • INNODB_RWLOCK_X_SPIN_WAITS
    • Exported stats already tracked in rw_lock_stats
  • INNODB_SECONDARY_INDEX_RECORD_READ_CHECK
    • Number of times visibility check was done for secondary index
  • INNODB_SECONDARY_INDEX_RECORD_READ_SEES
    • Number of times leaf page does not require reading from clustered index to determine visibility
  • INNODB_SECONDARY_INDEX_TRIGGERED_CLUSTER_READS
    • Times secondary index lookup triggered cluster lookup
  • INNODB_SECONDARY_INDEX_TRIGGERED_CLUSTER_READS_AVOIDED
    • Times prefix optimization avoided triggering cluster lookup
  • INNODB_SRV_CACHE_LIMIT_SECONDS
  • INNODB_SRV_CHECKPOINT_SECONDS
  • INNODB_SRV_DROP_TABLE_SECONDS
  • INNODB_SRV_FREE_LOG_SECONDS
  • INNODB_SRV_IBUF_CONTRACT_SECONDS
  • INNODB_SRV_LOG_FLUSH_SECONDS
  • INNODB_SRV_PURGE_SECONDS
    • Time spent doing various operations
  • INNODB_SYSTEM_ROWS_DELETED
  • INNODB_SYSTEM_ROWS_INSERTED
  • INNODB_SYSTEM_ROWS_READ
  • INNODB_SYSTEM_ROWS_UPDATED
    • Stats for system rows
  • INNODB_TRANSACTION_COMMIT_ALL
  • INNODB_TRANSACTION_COMMIT_WITH_UNDO
  • INNODB_TRANSACTION_ROLLBACK_PARTIAL
  • INNODB_TRANSACTION_ROLLBACK_TOTAL
    • Stats for transactions
  • INNODB_ZIP_{1024, 2048, 4096, 8192, 16384}_COMPRESSED
  • INNODB_ZIP_{1024, 2048, 4096, 8192, 16384}_COMPRESSED_OK
  • INNODB_ZIP_{1024, 2048, 4096, 8192, 16384}_COMPRESSED_OK_SECONDS
  • INNODB_ZIP_{1024, 2048, 4096, 8192, 16384}_COMPRESSED_PRIMARY
  • INNODB_ZIP_{1024, 2048, 4096, 8192, 16384}_COMPRESSED_PRIMARY_OK
  • INNODB_ZIP_{1024, 2048, 4096, 8192, 16384}_COMPRESSED_PRIMARY_OK_SECONDS
  • INNODB_ZIP_{1024, 2048, 4096, 8192, 16384}_COMPRESSED_PRIMARY_SECONDS
  • INNODB_ZIP_{1024, 2048, 4096, 8192, 16384}_COMPRESSED_SECONDARY
  • INNODB_ZIP_{1024, 2048, 4096, 8192, 16384}_COMPRESSED_SECONDARY_OK
  • INNODB_ZIP_{1024, 2048, 4096, 8192, 16384}_COMPRESSED_SECONDARY_OK_SECONDS
  • INNODB_ZIP_{1024, 2048, 4096, 8192, 16384}_COMPRESSED_SECONDARY_SECONDS
  • INNODB_ZIP_{1024, 2048, 4096, 8192, 16384}_COMPRESSED_SECONDS
  • INNODB_ZIP_{1024, 2048, 4096, 8192, 16384}_DECOMPRESSED
  • INNODB_ZIP_{1024, 2048, 4096, 8192, 16384}_DECOMPRESSED_PRIMARY
  • INNODB_ZIP_{1024, 2048, 4096, 8192, 16384}_DECOMPRESSED_PRIMARY_SECONDS
  • INNODB_ZIP_{1024, 2048, 4096, 8192, 16384}_DECOMPRESSED_SECONDARY
  • INNODB_ZIP_{1024, 2048, 4096, 8192, 16384}_DECOMPRESSED_SECONDARY_SECONDS
  • INNODB_ZIP_{1024, 2048, 4096, 8192, 16384}_DECOMPRESSED_SECONDS
    • Various compression stats bucketed by compressed page size.
  • LAST_EVICTED_PAGE_AGE
    • Timestamp of last evicted page from buffer pool (InnoDB)
  • LATENCY_HISTOGRAM_BINLOG_FSYNC_* (in 16ms inc)
    • Histogram stats relating to binlog fsyncs
  • RELAY_LOG_BYTES_WRITTEN
    • Number of bytes written to relay log (only incremented for slaves)
  • RELAY_LOG_IO_BYTES
  • RELAY_LOG_IO_CONNECTED
  • RELAY_LOG_IO_EVENTS
    • Number of events and bytes written by the IO thread. Number of times the IO thread connected to the master
  • RELAY_LOG_SQL_BYTES
  • RELAY_LOG_SQL_EVENTS
  • RELAY_LOG_SQL_WAIT_SECONDS
    • Number of events and bytes written by the SQL thread.
    • Number of seconds that the SQL thread waits for the IO thread to provide events.
  • RPL_COUNT_APPEND_BLOCK
  • RPL_COUNT_BEGIN_LOAD_QUERY
  • RPL_COUNT_CREATE_FILE
  • RPL_COUNT_DELETE_FILE
  • RPL_COUNT_DELETE_ROWS
  • RPL_COUNT_EXEC_LOAD
  • RPL_COUNT_EXECUTE_LOAD_QUERY
  • RPL_COUNT_FORMAT_DESCRIPTION
  • RPL_COUNT_INCIDENT
  • RPL_COUNT_INTVAR
  • RPL_COUNT_LOAD
  • RPL_COUNT_NEW_LOAD
  • RPL_COUNT_OTHER
  • RPL_COUNT_PRE_GA_DELETE_ROWS
  • RPL_COUNT_PRE_GA_UPDATE_ROWS
  • RPL_COUNT_PRE_GA_WRITE_ROWS
  • RPL_COUNT_QUERY
  • RPL_COUNT_RAND
  • RPL_COUNT_ROTATE
  • RPL_COUNT_SLAVE
  • RPL_COUNT_START_V3
  • RPL_COUNT_STOP
  • RPL_COUNT_TABLE_MAP
  • RPL_COUNT_UNKNOWN
  • RPL_COUNT_UPDATE_ROWS
  • RPL_COUNT_USER_VAR
  • RPL_COUNT_WRITE_ROWS
  • RPL_COUNT_XID
    • Various counts of replication events
  • RPL_SECONDS_APPEND_BLOCK
  • RPL_SECONDS_BEGIN_LOAD_QUERY
  • RPL_SECONDS_CREATE_FILE
  • RPL_SECONDS_DELETE_FILE
  • RPL_SECONDS_DELETE_ROWS
  • RPL_SECONDS_EXEC_LOAD
  • RPL_SECONDS_EXECUTE_LOAD_QUERY
  • RPL_SECONDS_FORMAT_DESCRIPTION
  • RPL_SECONDS_INCIDENT
  • RPL_SECONDS_INTVAR
  • RPL_SECONDS_LOAD
  • RPL_SECONDS_NEW_LOAD
  • RPL_SECONDS_OTHER
  • RPL_SECONDS_PRE_GA_DELETE_ROWS
  • RPL_SECONDS_PRE_GA_UPDATE_ROWS
  • RPL_SECONDS_PRE_GA_WRITE_ROWS
  • RPL_SECONDS_QUERY
  • RPL_SECONDS_RAND
  • RPL_SECONDS_ROTATE
  • RPL_SECONDS_SLAVE
  • RPL_SECONDS_START_V3
  • RPL_SECONDS_STOP
  • RPL_SECONDS_TABLE_MAP
  • RPL_SECONDS_UNKNOWN
  • RPL_SECONDS_UPDATE_ROWS
  • RPL_SECONDS_USER_VAR
  • RPL_SECONDS_WRITE_ROWS
  • RPL_SECONDS_XID
    • Time spent on replication events (analogous to RPL_COUNT*)
  • RPL_SEMI_SYNC_MASTER_TRX_WAIT_HISTOGRAM_* (in 500us inc)
    • Histogram of transaction wait time.
  • SQL_SLAVE_SKIP_COUNTER_USAGE
    • Stats that counts usage of sql_slave_skip_counter (since it doesn't work with gtid_mode)
  • THREADS_BINLOG_CLIENT
    • Move binlog threads from Threads_running to Threads_binlog_client
  • TMP_TABLE_BYTES_WRITTEN
    • Bytes written to temporary tables.

Stats relating to new features:

  • COM_FIND_GTID_POSITION
  • COM_PURGE_GTID
  • COM_RBR_COLUMN_NAMES
  • COM_SHOW_BINLOG_CACHE
  • COM_SHOW_ENGINE_TRANS
  • COM_SHOW_GTID_EXECUTED
  • COM_SHOW_MEMORY_STATUS
    • Counts for newly added commands
  • DATABASE_ADMISSION_CONTROL_ABORTED_QUERIES
  • DATABASE_ADMISSION_CONTROL_RUNNING_QUERIES
  • DATABASE_ADMISSION_CONTROL_WAITING_QUERIES
  • FLASHCACHE_ENABLED
    • Flashcache enabled?
  • GIT_DATE
  • GIT_HASH
  • ROCKSDB_GIT_DATE
  • ROCKSDB_GIT_HASH
    • Build info
  • INNODB_BUFFER_POOL_RESIZE_STATUS
    • Backport of resizable buffer pool to 5.6
  • INNODB_DROP_TABLE_IBUF_SKIPPED_ROW
  • INNODB_DROP_TABLE_PURGE_SKIPPED_ROW
    • Forward port of fast drop table. Counts number of times ibuf merges skipped a row because table was dropped and number of times purge skipped a row because table was dropped.
  • INNODB_LOGICAL_READ_AHEAD_IN_BUF_POOL
  • INNODB_LOGICAL_READ_AHEAD_MISSES
  • INNODB_LOGICAL_READ_AHEAD_PREFETCHED
    • LRA stats
  • INNODB_LOG_LOGICAL_WRITE_BYTES
  • INNODB_LOG_PHYSICAL_WRITE_BYTES
  • INNODB_LOG_WRITE_PADDING
    • 0-padding log writes to OS block size to avoid RMW
    • INNODB_LOG_LOGICAL_WRITE_BYTES + INNODB_LOG_WRITE_PADDING = INNODB_LOG_PHYSICAL_WRITE_BYTES
  • INNODB_NUM_OPTIMISTIC_INSERT_CALLS_IN_PESSIMISTIC_DESCENT
    • Reduce Calls to btr_cur_optimistic_insert
  • INNODB_PREFLUSH_ASYNC_LIMIT
  • INNODB_PREFLUSH_ASYNC_MARGIN
  • INNODB_PREFLUSH_SYNC_LIMIT
  • INNODB_PREFLUSH_SYNC_MARGIN
    • Manual fuzzy checkpoint constraints
  • JEMALLOC_ARENAS_NARENAS
  • JEMALLOC_OPT_NARENAS
  • JEMALLOC_OPT_TCACHE
  • JEMALLOC_STATS_ACTIVE
  • JEMALLOC_STATS_ALLOCATED
  • JEMALLOC_STATS_MAPPED
    • Memory allocator stats
  • MAX_STATEMENT_TIME_EXCEEDED
  • MAX_STATEMENT_TIME_SET
  • MAX_STATEMENT_TIME_SET_FAILED
    • Backport of Server-Side Statement Timeout
  • RBR_UNSAFE_QUERIES
    • Semi-strict mode specific
    • Count of unsafe queries for RBR
  • TIMER_IN_USE
    • Fast timer support
  • READ_QUERIES
  • TOTAL_QUERIES_REJECTED
  • WRITE_QUERIES
  • WRITE_QUERIES_REJECTED
  • WRITE_QUERIES_RUNNING

INNODB_CMP

Added these columns. See global stats for description.

  • compress_ok_time
  • compress_primary_ops
  • compress_primary_ops_ok
  • compress_primary_time
  • compress_primary_ok_time
  • compress_secondary_ops
  • compress_secondary_ops_ok
  • compress_secondary_time
  • compress_secondary_ok_time
  • uncompress_primary_ops
  • uncompress_primary_time
  • uncompress_secondary_ops
  • uncompress_secondary_time

INNODB_METRICS

Added these rows:

  • buffer_row_recreations
    • Amount of row recreations
  • buffer_row_recreation_steps
    • Amount of row recreation in steps
  • buffer_flush_batch_rescan (removed by de54315)
  • buffer_LRU_batch_evict_total_pages
    • Total pages evicted as part of LRU batches
  • buffer_LRU_batches_evict
    • Number of LRU batches
  • buffer_LRU_batch_evict_pages
    • Pages queued as an LRU batch
    • (above 4 are backported)
  • dml_system_reads
  • dml_system_inserts
  • dml_system_deletes
  • dml_system_updates
    • See INNODB_SYSTEM_ROWS_* in global status variables.

Documentation license here.

Installation

MyRocks

DocStore

MySQL/InnoDB Enhancements

Clone this wiki locally