Server Status Variables

Contents

  1. List of Server Status Variables
    1. Aborted_clients
    2. Aborted_connects
    3. Aborted_connects_preauth
    4. Access_denied_errors
    5. Acl_column_grants
    6. Acl_database_grants
    7. Acl_function_grants
    8. Acl_package_body_grants
    9. Acl_package_spec_grants
    10. Acl_procedure_grants
    11. Acl_proxy_users
    12. Acl_role_grants
    13. Acl_roles
    14. Acl_table_grants
    15. Acl_users
    16. Aria_pagecache_blocks_not_flushed
    17. Aria_pagecache_blocks_unused
    18. Aria_pagecache_blocks_used
    19. Aria_pagecache_read_requests
    20. Aria_pagecache_reads
    21. Aria_pagecache_write_requests
    22. Aria_pagecache_writes
    23. Aria_transaction_log_syncs
    24. Binlog_bytes_written
    25. Binlog_cache_disk_use
    26. Binlog_commits
    27. Binlog_group_commit_trigger_count
    28. Binlog_group_commit_trigger_lock_wait
    29. Binlog_group_commit_trigger_timeout
    30. Binlog_group_commits
    31. Binlog_snapshot_file
    32. Binlog_snapshot_position
    33. Binlog_stmt_cache_disk_use
    34. Binlog_stmt_cache_use
    35. Busy_time
    36. Bytes_received
    37. Bytes_sent
    38. Cassandra_multiget_keys_scanned
    39. Cassandra_multiget_reads
    40. Cassandra_multiget_rows_read
    41. Cassandra_row_inserts
    42. Cassandra_row_insert_batches
    43. Cassandra_timeout_exceptions
    44. Cassandra_unavailable_exceptions
    45. Column_compressions
    46. Column_decompressions
    47. Com_admin_commands
    48. Com_alter_db
    49. Com_alter_db_upgrade
    50. Com_alter_event
    51. Com_alter_function
    52. Com_alter_procedure
    53. Com_alter_sequence
    54. Com_alter_server
    55. Com_alter_table
    56. Com_alter_tablespace
    57. Com_alter_user
    58. Com_analyze
    59. Com_assign_to_keycache
    60. Com_backup
    61. Com_backup_lock
    62. Com_backup_table
    63. Com_begin
    64. Com_binlog
    65. Com_call_procedure
    66. Com_change_db
    67. Com_change_master
    68. Com_check
    69. Com_checksum
    70. Com_commit
    71. Com_compound_sql
    72. Com_create_db
    73. Com_create_event
    74. Com_create_function
    75. Com_create_index
    76. Com_create_package
    77. Com_create_package_body
    78. Com_create_procedure
    79. Com_create_role
    80. Com_create_sequence
    81. Com_create_server
    82. Com_create_table
    83. Com_create_temporary_table
    84. Com_create_trigger
    85. Com_create_udf
    86. Com_create_user
    87. Com_create_view
    88. Com_dealloc_sql
    89. Com_delete
    90. Com_delete_multi
    91. Com_do
    92. Com_drop_db
    93. Com_drop_event
    94. Com_drop_function
    95. Com_drop_index
    96. Com_drop_package
    97. Com_drop_package_body
    98. Com_drop_procedure
    99. Com_drop_role
    100. Com_drop_sequence
    101. Com_drop_server
    102. Com_drop_table
    103. Com_drop_temporary_table
    104. Com_drop_trigger
    105. Com_drop_user
    106. Com_drop_view
    107. Com_empty_query
    108. Com_execute_immediate
    109. Com_execute_sql
    110. Com_flush
    111. Com_get_diagnostics
    112. Com_grant
    113. Com_grant_role
    114. Com_ha_close
    115. Com_ha_open
    116. Com_ha_read
    117. Com_help
    118. Com_insert
    119. Com_insert_select
    120. Com_install_plugin
    121. Com_kill
    122. Com_load
    123. Com_load_master_data
    124. Com_load_master_table
    125. Com_multi
    126. Com_lock_tables
    127. Com_optimize
    128. Com_preload_keys
    129. Com_prepare_sql
    130. Com_purge
    131. Com_purge_before_date
    132. Com_release_savepoint
    133. Com_rename_table
    134. Com_rename_user
    135. Com_repair
    136. Com_replace
    137. Com_replace_select
    138. Com_reset
    139. Com_resignal
    140. Com_restore_table
    141. Com_revoke
    142. Com_revoke_all
    143. Com_revoke_grant
    144. Com_rollback
    145. Com_rollback_to_savepoint
    146. Com_savepoint
    147. Com_select
    148. Com_set_option
    149. Com_signal
    150. Com_show_authors
    151. Com_show_binlog_events
    152. Com_show_binlogs
    153. Com_show_charsets
    154. Com_show_client_statistics
    155. Com_show_collations
    156. Com_show_column_types
    157. Com_show_contributors
    158. Com_show_create_db
    159. Com_show_create_event
    160. Com_show_create_func
    161. Com_show_create_package
    162. Com_show_create_package_body
    163. Com_show_create_proc
    164. Com_show_create_table
    165. Com_show_create_trigger
    166. Com_show_create_user
    167. Com_show_databases
    168. Com_show_engine_logs
    169. Com_show_engine_mutex
    170. Com_show_engine_status
    171. Com_show_events
    172. Com_show_errors
    173. Com_show_explain
    174. Com_show_fields
    175. Com_show_function_status
    176. Com_show_generic
    177. Com_show_grants
    178. Com_show_keys
    179. Com_show_index_statistics
    180. com_show_master_status
    181. com_show_new_master
    182. Com_show_open_tables
    183. Com_show_package_status
    184. Com_show_package_body_status
    185. Com_show_plugins
    186. Com_show_privileges
    187. Com_show_procedure_status
    188. Com_show_processlist
    189. Com_show_profile
    190. Com_show_profiles
    191. Com_show_relaylog_events
    192. com_show_slave_hosts
    193. com_show_slave_status
    194. Com_show_status
    195. Com_show_storage_engines
    196. Com_show_table_statistics
    197. Com_show_table_status
    198. Com_show_tables
    199. Com_show_triggers
    200. Com_show_user_statistics
    201. Com_show_variable
    202. Com_show_warnings
    203. Com_shutdown
    204. Com_slave_start
    205. Com_slave_stop
    206. Com_start_all_slaves
    207. Com_start_slave
    208. Com_stmt_close
    209. Com_stmt_execute
    210. Com_stmt_fetch
    211. Com_stmt_prepare
    212. Com_stmt_reprepare
    213. Com_stmt_reset
    214. Com_stmt_send_long_data
    215. Com_stop_all_slaves
    216. Com_stop_slave
    217. Com_truncate
    218. Com_uninstall_plugin
    219. Com_unlock_tables
    220. Com_update
    221. Com_update_multi
    222. Com_xa_commit
    223. Com_xa_end
    224. Com_xa_prepare
    225. Com_xa_recover
    226. Com_xa_rollback
    227. Com_xa_start
    228. Compression
    229. Connection_errors_accept
    230. Connection_errors_internal
    231. Connection_errors_max_connections
    232. Connection_errors_peer_address
    233. Connection_errors_select
    234. Connection_errors_tcpwrap
    235. Connections
    236. Cpu_time
    237. Created_tmp_disk_tables
    238. Created_tmp_files
    239. Created_tmp_tables
    240. Delayed_errors
    241. Delayed_insert_threads
    242. Delayed_writes
    243. Delete_scan
    244. Empty_queries
    245. Executed_events
    246. Executed_triggers
    247. Feature_application_time_periods
    248. Feature_check_constraint
    249. Feature_custom_aggregate_functions
    250. Feature_delay_key_write
    251. Feature_dynamic_columns
    252. Feature_fulltext
    253. Feature_gis
    254. Feature_insert_returning
    255. Feature_invisible_columns
    256. Feature_json
    257. Feature_locale
    258. Feature_subquery
    259. Feature_system_versioning
    260. Feature_timezone
    261. Feature_trigger
    262. Feature_window_functions
    263. Feature_xml
    264. Flush_commands
    265. Handler_commit
    266. Handler_delete
    267. Handler_discover
    268. Handler_external_lock
    269. Handler_icp_attempts
    270. Handler_icp_match
    271. Handler_mrr_init
    272. Handler_mrr_key_refills
    273. Handler_mrr_rowid_refills
    274. Handler_prepare
    275. Handler_read_first
    276. Handler_read_key
    277. Handler_read_last
    278. Handler_read_next
    279. Handler_read_prev
    280. Handler_read_retry
    281. Handler_read_rnd
    282. Handler_read_rnd_deleted
    283. Handler_read_rnd_next
    284. Handler_rollback
    285. Handler_savepoint
    286. Handler_savepoint_rollback
    287. Handler_tmp_delete
    288. Handler_tmp_update
    289. Handler_tmp_write
    290. Handler_update
    291. Handler_write
    292. Innodb_adaptive_hash_cells
    293. Innodb_adaptive_hash_hash_searches
    294. Innodb_adaptive_hash_heap_buffers
    295. Innodb_adaptive_hash_non_hash_searches
    296. Innodb_async_reads_queue_size
    297. Innodb_async_reads_pending
    298. Innodb_async_reads_tasks_running
    299. Innodb_async_reads_total_count
    300. Innodb_async_reads_total_enqueues
    301. Innodb_async_reads_wait_slot_sec
    302. Innodb_async_writes_queue_size
    303. Innodb_async_writes_pending
    304. Innodb_async_writes_tasks_running
    305. Innodb_async_writes_total_count
    306. Innodb_async_writes_total_enqueues
    307. Innodb_async_writes_wait_slot_sec
    308. Innodb_available_undo_logs
    309. Innodb_background_log_sync
    310. Innodb_buffer_pool_bytes_data
    311. Innodb_buffer_pool_bytes_dirty
    312. Innodb_buffer_pool_dump_status
    313. innodb_buffer_pool_load_incomplete
    314. innodb_buffer_pool_load_status
    315. Innodb_buffer_pool_pages_data
    316. Innodb_buffer_pool_pages_dirty
    317. Innodb_buffer_pool_pages_flushed
    318. Innodb_buffer_pool_pages_LRU_flushed
    319. Innodb_buffer_pool_pages_LRU_freed
    320. Innodb_buffer_pool_pages_free
    321. Innodb_buffer_pool_pages_made_not_young
    322. Innodb_buffer_pool_pages_made_young
    323. Innodb_buffer_pool_pages_misc
    324. Innodb_buffer_pool_pages_old
    325. Innodb_buffer_pool_pages_total
    326. Innodb_buffer_pool_read_ahead_rnd
    327. Innodb_buffer_pool_read_ahead
    328. Innodb_buffer_pool_read_ahead_evicted
    329. Innodb_buffer_pool_read_requests
    330. Innodb_buffer_pool_reads
    331. Innodb_buffer_pool_resize_status
    332. Innodb_buffer_pool_wait_free
    333. Innodb_buffer_pool_write_requests
    334. Innodb_buffered_aio_submitted
    335. Innodb_checkpoint_age
    336. Innodb_checkpoint_max_age
    337. Innodb_checkpoint_target_age
    338. Innodb_current_row_locks
    339. Innodb_data_fsyncs
    340. Innodb_data_pending_fsyncs
    341. Innodb_data_pending_reads
    342. Innodb_data_pending_writes
    343. Innodb_data_read
    344. Innodb_data_reads
    345. Innodb_data_writes
    346. Innodb_data_written
    347. Innodb_dblwr_pages_written
    348. Innodb_dblwr_writes
    349. Innodb_deadlocks
    350. Innodb_defragment_compression_failures
    351. Innodb_defragment_count
    352. Innodb_defragment_failures
    353. Innodb_dict_tables
    354. Innodb_encryption_n_merge_blocks_decrypted
    355. Innodb_encryption_n_merge_blocks_encrypted
    356. Innodb_encryption_n_rowlog_blocks_decrypted
    357. Innodb_encryption_n_rowlog_blocks_encrypted
    358. Innodb_encryption_n_temp_blocks_decrypted
    359. Innodb_encryption_n_temp_blocks_encrypted
    360. Innodb_encryption_num_key_requests
    361. Innodb_encryption_rotation_estimated_iops
    362. Innodb_encryption_rotation_pages_flushed
    363. Innodb_encryption_rotation_pages_modified
    364. Innodb_encryption_rotation_pages_read_from_cache
    365. Innodb_encryption_rotation_pages_read_from_disk
    366. Innodb_have_atomic_builtins
    367. Innodb_have_bzip2
    368. Innodb_have_lz4
    369. Innodb_have_lzma
    370. Innodb_have_lzo
    371. Innodb_have_snappy
    372. Innodb_history_list_length
    373. Innodb_ibuf_discarded_delete_marks
    374. Innodb_ibuf_discarded_deletes
    375. Innodb_ibuf_discarded_inserts
    376. Innodb_ibuf_free_list
    377. Innodb_ibuf_merged_delete_marks
    378. Innodb_ibuf_merged_deletes
    379. Innodb_ibuf_merged_inserts
    380. Innodb_ibuf_merges
    381. Innodb_ibuf_segment_size
    382. Innodb_ibuf_size
    383. Innodb_instant_alter_column
    384. Innodb_log_waits
    385. Innodb_log_write_requests
    386. Innodb_log_writes
    387. Innodb_lsn_current
    388. Innodb_lsn_flushed
    389. Innodb_lsn_last_checkpoint
    390. Innodb_master_thread_1_second_loops
    391. Innodb_master_thread_10_second_loops
    392. Innodb_master_thread_background_loops
    393. Innodb_master_thread_main_flush_loops
    394. Innodb_master_thread_sleeps
    395. Innodb_max_trx_id
    396. Innodb_mem_adaptive_hash
    397. Innodb_mem_dictionary
    398. Innodb_mem_total
    399. Innodb_mutex_os_waits
    400. Innodb_mutex_spin_rounds
    401. Innodb_mutex_spin_waits
    402. Innodb_num_index_pages_written
    403. Innodb_num_non_index_pages_written
    404. Innodb_num_open_files
    405. Innodb_num_page_compressed_trim_op
    406. Innodb_num_page_compressed_trim_op_saved
    407. Innodb_num_pages_encrypted
    408. Innodb_num_pages_page_compressed
    409. Innodb_num_pages_page_compression_error
    410. Innodb_num_pages_page_decompressed
    411. Innodb_num_pages_page_decrypted
    412. Innodb_num_pages_page_encryption_error
    413. Innodb_oldest_view_low_limit_trx_id
    414. Innodb_onlineddl_pct_progress
    415. Innodb_onlineddl_rowlog_pct_used
    416. Innodb_onlineddl_rowlog_rows
    417. Innodb_os_log_fsyncs
    418. Innodb_os_log_pending_fsyncs
    419. Innodb_os_log_pending_writes
    420. Innodb_os_log_written
    421. Innodb_page_compression_saved
    422. Innodb_page_compression_trim_sect512
    423. Innodb_page_compression_trim_sect1024
    424. Innodb_page_compression_trim_sect2048
    425. Innodb_page_compression_trim_sect4096
    426. Innodb_page_compression_trim_sect8192
    427. Innodb_page_compression_trim_sect16384
    428. Innodb_page_compression_trim_sect32768
    429. Innodb_page_size
    430. Innodb_pages_created
    431. Innodb_pages_read
    432. Innodb_pages_written
    433. Innodb_purge_trx_id
    434. Innodb_purge_undo_no
    435. Innodb_row_lock_current_waits
    436. Innodb_row_lock_numbers
    437. Innodb_row_lock_time
    438. Innodb_row_lock_time_avg
    439. Innodb_row_lock_time_max
    440. Innodb_row_lock_waits
    441. Innodb_rows_deleted
    442. Innodb_rows_inserted
    443. Innodb_rows_read
    444. Innodb_rows_updated
    445. Innodb_s_lock_os_waits
    446. Innodb_s_lock_spin_rounds
    447. Innodb_s_lock_spin_waits
    448. Innodb_scrub_background_page_reorganizations
    449. Innodb_scrub_background_page_split_failures_missing_index
    450. Innodb_scrub_background_page_split_failures_out_of_filespace
    451. Innodb_scrub_background_page_split_failures_underflow
    452. Innodb_scrub_background_page_split_failures_unknown
    453. Innodb_scrub_background_page_splits
    454. Innodb_secondary_index_triggered_cluster_reads
    455. Innodb_secondary_index_triggered_cluster_reads_avoided
    456. Innodb_system_rows_deleted
    457. Innodb_system_rows_inserted
    458. Innodb_system_rows_read
    459. Innodb_system_rows_updated
    460. Innodb_truncated_status_writes
    461. Innodb_undo_truncations
    462. Innodb_x_lock_os_waits
    463. Innodb_x_lock_spin_rounds
    464. Innodb_x_lock_spin_waits
    465. Key_blocks_not_flushed
    466. Key_blocks_unused
    467. Key_blocks_used
    468. Key_blocks_warm
    469. Key_read_requests
    470. Key_reads
    471. Key_write_requests
    472. Key_writes
    473. Last_query_cost
    474. Maria_*
    475. Master_gtid_wait_count
    476. Master_gtid_wait_time
    477. Master_gtid_wait_timeouts
    478. Max_memory_used
    479. Max_statement_time_exceeded
    480. Max_tmp_space_used
    481. Max_used_connections
    482. Max_used_connections_time
    483. Memory_used
    484. Memory_used_initial
    485. Mroonga_count_skip
    486. Mroonga_fast_order_limit
    487. Not_flushed_delayed_rows
    488. Open_files
    489. Open_streams
    490. Open_table_definitions
    491. Open_tables
    492. Opened_files
    493. Opened_plugin_libraries
    494. Opened_table_definitions
    495. Opened_tables
    496. Opened_views
    497. Oqgraph_boost_version
    498. Oqgraph_compat_mode
    499. Oqgraph_verbose_debug
    500. Performance_schema_accounts_lost
    501. Performance_cond_classes_accounts_lost
    502. Performance_schema_cond_instances_lost
    503. Performance_schema_digest_lost
    504. Performance_schema_file_classes_lost
    505. Performance_schema_file_handles_lost
    506. Performance_schema_file_instances_lost
    507. Performance_schema_hosts_lost
    508. Performance_schema_index_stat_lost
    509. Performance_schema_locker_lost
    510. Performance_schema_memory_classes_lost
    511. Performance_metadata_lock_classes_lost
    512. Performance_schema_mutex_classes_lost
    513. Performance_schema_mutex_instances_lost
    514. Performance_schema_nested_statement_lost
    515. Performance_schema_prepared_statements_lost
    516. Performance_schema_program_lost
    517. Performance_schema_rwlock_classes_lost
    518. Performance_schema_rwlock_instances_lost
    519. Performance_schema_session_connect_attrs_lost
    520. Performance_schema_socket_classes_lost
    521. Performance_schema_socket_instances_lost
    522. Performance_schema_stage_classes_lost
    523. Performance_schema_statement_classes_lost
    524. Performance_schema_table_handles_lost
    525. Performance_schema_table_instances_lost
    526. Performance_schema_table_lock_stat_lost
    527. Performance_schema_thread_classes_lost
    528. Performance_schema_thread_instances_lost
    529. Performance_schema_users_lost
    530. Prepared_stmt_count
    531. Qcache_free_blocks
    532. Qcache_free_memory
    533. Qcache_hits
    534. Qcache_inserts
    535. Qcache_lowmem_prunes
    536. Qcache_not_cached
    537. Qcache_queries_in_cache
    538. Qcache_total_blocks
    539. Queries
    540. Query_time
    541. Questions
    542. Resultset_metadata_skipped
    543. Rocksdb_block_cache_add
    544. Rocksdb_block_cache_add_failures
    545. Rocksdb_block_cache_bytes_read
    546. Rocksdb_block_cache_bytes_write
    547. Rocksdb_block_cache_data_add
    548. Rocksdb_block_cache_data_bytes_insert
    549. Rocksdb_block_cache_data_hit
    550. Rocksdb_block_cache_data_miss
    551. Rocksdb_block_cache_filter_add
    552. Rocksdb_block_cache_filter_bytes_evict
    553. Rocksdb_block_cache_filter_bytes_insert
    554. Rocksdb_block_cache_filter_hit
    555. Rocksdb_block_cache_filter_miss
    556. Rocksdb_block_cache_hit
    557. Rocksdb_block_cache_index_add
    558. Rocksdb_block_cache_index_bytes_evict
    559. Rocksdb_block_cache_index_bytes_insert
    560. Rocksdb_block_cache_index_hit
    561. Rocksdb_block_cache_index_miss
    562. Rocksdb_block_cache_miss
    563. Rocksdb_block_cachecompressed_hit
    564. Rocksdb_block_cachecompressed_miss
    565. Rocksdb_bloom_filter_full_positive
    566. Rocksdb_bloom_filter_full_true_positive
    567. Rocksdb_bloom_filter_prefix_checked
    568. Rocksdb_bloom_filter_prefix_useful
    569. Rocksdb_bloom_filter_useful
    570. Rocksdb_bytes_read
    571. Rocksdb_bytes_written
    572. Rocksdb_compact_read_bytes
    573. Rocksdb_compact_write_bytes
    574. Rocksdb_compaction_key_drop_new
    575. Rocksdb_compaction_key_drop_obsolete
    576. Rocksdb_compaction_key_drop_user
    577. Rocksdb_covered_secondary_key_lookups
    578. Rocksdb_flush_write_bytes
    579. Rocksdb_get_hit_l0
    580. Rocksdb_get_hit_l1
    581. Rocksdb_get_hit_l2_and_up
    582. Rocksdb_getupdatessince_calls
    583. Rocksdb_iter_bytes_read
    584. Rocksdb_l0_num_files_stall_micros
    585. Rocksdb_l0_slowdown_micros
    586. Rocksdb_manual_compactions_processed
    587. Rocksdb_manual_compactions_running
    588. Rocksdb_memtable_compaction_micros
    589. Rocksdb_memtable_hit
    590. Rocksdb_memtable_miss
    591. Rocksdb_memtable_total
    592. Rocksdb_memtable_unflushed
    593. Rocksdb_no_file_closes
    594. Rocksdb_no_file_errors
    595. Rocksdb_no_file_opens
    596. Rocksdb_num_iterators
    597. Rocksdb_number_block_not_compressed
    598. Rocksdb_number_db_next
    599. Rocksdb_number_db_next_found
    600. Rocksdb_number_db_prev
    601. Rocksdb_number_db_prev_found
    602. Rocksdb_number_db_seek
    603. Rocksdb_number_db_seek_found
    604. Rocksdb_number_deletes_filtered
    605. Rocksdb_number_keys_read
    606. Rocksdb_number_keys_updated
    607. Rocksdb_number_keys_written
    608. Rocksdb_number_merge_failures
    609. Rocksdb_number_multiget_bytes_read
    610. Rocksdb_number_multiget_get
    611. Rocksdb_number_multiget_keys_read
    612. Rocksdb_number_reseeks_iteration
    613. Rocksdb_number_sst_entry_delete
    614. Rocksdb_number_sst_entry_merge
    615. Rocksdb_number_sst_entry_other
    616. Rocksdb_number_sst_entry_put
    617. Rocksdb_number_sst_entry_singledelete
    618. Rocksdb_number_superversion_acquires
    619. Rocksdb_number_superversion_cleanups
    620. Rocksdb_number_superversion_releases
    621. Rocksdb_queries_point
    622. Rocksdb_queries_range
    623. Rocksdb_row_lock_deadlocks
    624. Rocksdb_row_lock_wait_timeouts
    625. Rocksdb_rows_deleted
    626. Rocksdb_rows_deleted_blind
    627. Rocksdb_rows_expired
    628. Rocksdb_rows_filtered
    629. Rocksdb_rows_inserted
    630. Rocksdb_rows_read
    631. Rocksdb_rows_updated
    632. Rocksdb_snapshot_conflict_errors
    633. Rocksdb_stall_l0_file_count_limit_slowdowns
    634. Rocksdb_stall_l0_file_count_limit_stops
    635. Rocksdb_stall_locked_l0_file_count_limit_slowdowns
    636. Rocksdb_stall_locked_l0_file_count_limit_stops
    637. Rocksdb_stall_memtable_limit_slowdowns
    638. Rocksdb_stall_memtable_limit_stops
    639. Rocksdb_stall_micros
    640. Rocksdb_stall_pending_compaction_limit_slowdowns
    641. Rocksdb_stall_pending_compaction_limit_stops
    642. Rocksdb_stall_total_slowdowns
    643. Rocksdb_stall_total_stops
    644. Rocksdb_system_rows_deleted
    645. Rocksdb_system_rows_inserted
    646. Rocksdb_system_rows_read
    647. Rocksdb_system_rows_updated
    648. Rocksdb_wal_bytes
    649. Rocksdb_wal_group_syncs
    650. Rocksdb_wal_synced
    651. Rocksdb_write_other
    652. Rocksdb_write_self
    653. Rocksdb_write_timedout
    654. Rocksdb_write_wal
    655. Rows_read
    656. Rows_sent
    657. Rows_tmp_read
    658. Rpl_semi_sync_master_clients
    659. Rpl_semi_sync_master_net_avg_wait_time
    660. Rpl_semi_sync_master_net_wait_time
    661. Rpl_semi_sync_master_net_waits
    662. Rpl_semi_sync_master_no_times
    663. Rpl_semi_sync_master_no_tx
    664. Rpl_semi_sync_master_status
    665. Rpl_semi_sync_master_timefunc_failures
    666. Rpl_semi_sync_master_tx_avg_wait_time
    667. Rpl_semi_sync_master_tx_wait_time
    668. Rpl_semi_sync_master_tx_waits
    669. Rpl_semi_sync_master_wait_pos_backtraverse
    670. Rpl_semi_sync_master_wait_sessions
    671. Rpl_semi_sync_master_yes_tx
    672. Rpl_semi_sync_slave_status
    673. Rpl_status
    674. Rpl_transactions_multi_engine
    675. S3_pagecache_blocks_not_flushed
    676. S3_pagecache_blocks_unused
    677. S3_pagecache_blocks_used
    678. S3_pagecache_read_requests
    679. S3_pagecache_reads
    680. Select_full_join
    681. Select_full_range_join
    682. Select_range
    683. Select_range_check
    684. Select_scan
    685. Server_audit_active
    686. Server_audit_current_log
    687. Server_audit_last_error
    688. Server_audit_writes_failed
    689. Slave_connections
    690. Slave_heartbeat_period
    691. Slave_open_temp_tables
    692. Slave_received_heartbeats
    693. Slave_retried_transactions
    694. Slave_running
    695. Slave_skipped_errors
    696. Slaves_connected
    697. Slaves_running
    698. Slow_launch_threads
    699. Slow_queries
    700. Sort_merge_passes
    701. Sort_priority_queue_sorts
    702. Sort_range
    703. Sort_rows
    704. Sort_scan
    705. Sphinx_error
    706. Sphinx_time
    707. Sphinx_total
    708. Sphinx_total_found
    709. Sphinx_word_count
    710. Sphinx_words
    711. Spider_direct_aggregate
    712. Spider_direct_delete
    713. Spider_direct_order_limit
    714. Spider_direct_update
    715. Spider_direct_mon_table_cache_version
    716. Spider_direct_mon_table_cache_version_req
    717. Spider_parallel_search
    718. Ssl_accept_renegotiates
    719. Ssl_accepts
    720. Ssl_callback_cache_hits
    721. Ssl_cipher
    722. Ssl_cipher_list
    723. Ssl_client_connects
    724. Ssl_connect_renegotiates
    725. Ssl_ctx_verify_depth
    726. Ssl_ctx_verify_mode
    727. Ssl_default_timeout
    728. Ssl_finished_accepts
    729. Ssl_finished_connects
    730. Ssl_server_not_after
    731. Ssl_server_not_before
    732. Ssl_session_cache_hits
    733. Ssl_session_cache_misses
    734. Ssl_session_cache_mode
    735. Ssl_session_cache_overflows
    736. Ssl_session_cache_size
    737. Ssl_session_cache_timeouts
    738. Ssl_sessions_reused
    739. Ssl_used_session_cache_entries
    740. Ssl_verify_depth
    741. Ssl_verify_mode
    742. Ssl_version
    743. Subquery_cache_hit
    744. Subquery_cache_miss
    745. Syncs
    746. Table_locks_immediate
    747. Table_locks_waited
    748. Table_open_cache_active_instances
    749. Table_open_cache_hits
    750. Table_open_cache_misses
    751. Table_open_cache_overflows
    752. Tc_log_max_pages_used
    753. Tc_log_page_size
    754. Tc_log_page_waits
    755. Threadpool_idle_threads
    756. Threadpool_threads
    757. Threads_cached
    758. Threads_connected
    759. Threads_created
    760. Threads_running
    761. Tmp_space_used
    762. Tokudb_basement_deserialization_fixed_key
    763. Tokudb_basement_deserialization_variable_key
    764. Tokudb_basements_decompressed_for_write
    765. Tokudb_basements_decompressed_prefetch
    766. Tokudb_basements_decompressed_prelocked_range
    767. Tokudb_basements_decompressed_target_query
    768. Tokudb_basements_fetched_prefetch
    769. Tokudb_basements_fetched_for_write
    770. Tokudb_basements_fetched_for_write_bytes
    771. Tokudb_basements_fetched_for_write_seconds
    772. Tokudb_basements_fetched_prefetch_bytes
    773. Tokudb_basements_fetched_prefetch_seconds
    774. Tokudb_basements_fetched_prelocked_range
    775. Tokudb_basements_fetched_prelocked_range_bytes
    776. Tokudb_basements_fetched_prelocked_range_seconds
    777. Tokudb_basements_fetched_target_query
    778. Tokudb_basements_fetched_target_query_bytes
    779. Tokudb_basements_fetched_target_query_seconds
    780. Tokudb_broadcase_messages_injected_at_root
    781. Tokudb_buffers_decompressed_for_write
    782. Tokudb_buffers_decompressed_prefetch
    783. Tokudb_buffers_decompressed_prelocked_range
    784. Tokudb_buffers_decompressed_target_query
    785. Tokudb_buffers_fetched_for_write
    786. Tokudb_buffers_fetched_for_write_bytes
    787. Tokudb_buffers_fetched_for_write_seconds
    788. Tokudb_buffers_fetched_prefetch
    789. Tokudb_buffers_fetched_prefetch_bytes
    790. Tokudb_buffers_fetched_prefetch_seconds
    791. Tokudb_buffers_fetched_prelocked_range
    792. Tokudb_buffers_fetched_prelocked_range_bytes
    793. Tokudb_buffers_fetched_prelocked_range_seconds
    794. Tokudb_buffers_fetched_target_query
    795. Tokudb_buffers_fetched_target_query_bytes
    796. Tokudb_buffers_fetched_target_query_seconds
    797. Tokudb_cachetable_cleaner_executions
    798. Tokudb_cachetable_cleaner_iterations
    799. Tokudb_cachetable_cleaner_period
    800. Tokudb_cachetable_evictions
    801. Tokudb_cachetable_long_wait_pressure_count
    802. Tokudb_cachetable_long_wait_pressure_time
    803. Tokudb_cachetable_miss
    804. Tokudb_cachetable_miss_time
    805. Tokudb_cachetable_prefetches
    806. Tokudb_cachetable_size_cachepressure
    807. Tokudb_cachetable_size_cloned
    808. Tokudb_cachetable_size_current
    809. Tokudb_cachetable_size_leaf
    810. Tokudb_cachetable_size_limit
    811. Tokudb_cachetable_size_nonleaf
    812. Tokudb_cachetable_size_rollback
    813. Tokudb_cachetable_size_writing
    814. Tokudb_cachetable_wait_pressure_count
    815. Tokudb_cachetable_wait_pressure_time
    816. Tokudb_checkpoint_begin_time
    817. Tokudb_checkpoint_duration
    818. Tokudb_checkpoint_duration_last
    819. Tokudb_checkpoint_failed
    820. Tokudb_checkpoint_last_began
    821. Tokudb_checkpoint_last_complete_began
    822. Tokudb_checkpoint_last_complete_ended
    823. Tokudb_checkpoint_long_begin_count
    824. Tokudb_checkpoint_long_begin_time
    825. Tokudb_checkpoint_period
    826. Tokudb_checkpoint_taken
    827. Tokudb_cursor_skip_deleted_leaf_entry
    828. Tokudb_db_closes
    829. Tokudb_db_open_current
    830. Tokudb_db_open_max
    831. Tokudb_db_opens
    832. Tokudb_descriptor_set
    833. Tokudb_dictionary_broadcast_updates
    834. Tokudb_dictionary_updates
    835. Tokudb_filesystem_fsync_num
    836. Tokudb_filesystem_fsync_time
    837. Tokudb_filesystem_long_fsync_num
    838. Tokudb_filesystem_long_fsync_time
    839. Tokudb_filesystem_threads_blocked_by_full_disk
    840. Tokudb_leaf_compression_to_memory_seconds
    841. Tokudb_leaf_decompression_to_memory_seconds
    842. Tokudb_leaf_deserialization_to_memory_seconds
    843. Tokudb_leaf_node_compression_ratio
    844. Tokudb_leaf_node_full_evictions
    845. Tokudb_leaf_node_full_evictions_bytes
    846. Tokudb_leaf_node_partial_evictions
    847. Tokudb_leaf_node_partial_evictions_bytes
    848. Tokudb_leaf_nodes_created
    849. Tokudb_leaf_nodes_destroyed
    850. Tokudb_leaf_nodes_flushed_to_disk_checkpoint
    851. Tokudb_leaf_nodes_flushed_to_disk_checkpoint_bytes
    852. Tokudb_leaf_nodes_flushed_to_disk_checkpoint_seconds
    853. Tokudb_leaf_nodes_flushed_to_disk_checkpoint_uncompressed_bytes
    854. Tokudb_leaf_nodes_flushed_to_disk_not_checkpoint
    855. Tokudb_leaf_nodes_flushed_to_disk_not_checkpoint_bytes
    856. Tokudb_leaf_nodes_flushed_to_disk_not_checkpoint_seconds
    857. Tokudb_leaf_nodes_flushed_to_disk_not_checkpoint_uncompressed_bytes
    858. Tokudb_leaf_serialization_to_memory_seconds
    859. Tokudb_loader_num_created
    860. Tokudb_loader_num_current
    861. Tokudb_loader_num_max
    862. Tokudb_locktree_escalation_num
    863. Tokudb_locktree_escalation_seconds
    864. Tokudb_locktree_latest_post_escalation_memory_size
    865. Tokudb_locktree_long_wait_count
    866. Tokudb_locktree_long_wait_escalation_count
    867. Tokudb_locktree_long_wait_escalation_time
    868. Tokudb_locktree_long_wait_time
    869. Tokudb_locktree_memory_size
    870. Tokudb_locktree_memory_size_limit
    871. Tokudb_locktree_open_current
    872. Tokudb_locktree_pending_lock_requests
    873. Tokudb_locktree_sto_eligible_num
    874. Tokudb_locktree_sto_ended_num
    875. Tokudb_locktree_sto_ended_seconds
    876. Tokudb_locktree_timeout_count
    877. Tokudb_locktree_wait_count
    878. Tokudb_locktree_wait_escalation_count
    879. Tokudb_locktree_wait_escalation_time
    880. Tokudb_locktree_wait_time
    881. Tokudb_logger_wait_long
    882. Tokudb_logger_writes
    883. Tokudb_logger_writes_bytes
    884. Tokudb_logger_writes_seconds
    885. Tokudb_logger_writes_uncompressed_bytes
    886. Tokudb_mem_estimated_maximum_memory_footprint
    887. Tokudb_messages_flushed_from_h1_to_leaves_bytes
    888. Tokudb_messages_ignored_by_leaf_due_to_msn
    889. Tokudb_messages_in_trees_estimate_bytes
    890. Tokudb_messages_injected_at_root
    891. Tokudb_messages_injected_at_root_bytes
    892. Tokudb_nonleaf_compression_to_memory_seconds
    893. Tokudb_nonleaf_decompression_to_memory_seconds
    894. Tokudb_nonleaf_deserialization_to_memory_seconds
    895. Tokudb_nonleaf_node_compression_ratio
    896. Tokudb_nonleaf_node_full_evictions
    897. Tokudb_nonleaf_node_full_evictions_bytes
    898. Tokudb_nonleaf_node_partial_evictions
    899. Tokudb_nonleaf_node_partial_evictions_bytes
    900. Tokudb_nonleaf_nodes_created
    901. Tokudb_nonleaf_nodes_destroyed
    902. Tokudb_nonleaf_nodes_flushed_checkpoint
    903. Tokudb_nonleaf_nodes_flushed_checkpoint_bytes
    904. Tokudb_nonleaf_nodes_flushed_checkpoint_seconds
    905. Tokudb_nonleaf_nodes_flushed_checkpoint_uncompressed_bytes
    906. Tokudb_nonleaf_nodes_flushed_not_checkpoint
    907. Tokudb_nonleaf_nodes_flushed_not_checkpoint_bytes
    908. Tokudb_nonleaf_nodes_flushed_not_checkpoint_seconds
    909. Tokudb_nonleaf_nodes_flushed_not_checkpoint_uncompressed_bytes
    910. Tokudb_nonleaf_serialization_to_memory_seconds
    911. Tokudb_overall_node_compression_ratio
    912. Tokudb_pivots_fetched_for_query
    913. Tokudb_pivots_fetched_for_query_bytes
    914. Tokudb_pivots_fetched_for_query_seconds
    915. Tokudb_pivots_fetched_for_prefetch
    916. Tokudb_pivots_fetched_for_prefetch_bytes
    917. Tokudb_pivots_fetched_for_prefetch_seconds
    918. Tokudb_pivots_fetched_for_write
    919. Tokudb_pivots_fetched_for_write_bytes
    920. Tokudb_pivots_fetched_for_write_seconds
    921. Tokudb_promotion_h1_roots_injected_into
    922. Tokudb_promotion_injections_at_depth_0
    923. Tokudb_promotion_injections_at_depth_1
    924. Tokudb_promotion_injections_at_depth_2
    925. Tokudb_promotion_injections_at_depth_3
    926. Tokudb_promotion_injections_lower_than_depth_3
    927. Tokudb_promotion_leaf_roots_injected_into
    928. Tokudb_promotion_roots_split
    929. Tokudb_promotion_stopped_after_locking_child
    930. Tokudb_promotion_stopped_at_height_1
    931. Tokudb_promotion_stopped_child_not_fully_in_memory
    932. Tokudb_promotion_stopped_child_locked_or_not_in_memory
    933. Tokudb_promotion_stopped_nonempty_buffer
    934. Tokudb_txn_aborts
    935. Tokudb_txn_begin
    936. Tokudb_txn_begin_read_only
    937. Tokudb_txn_commits
    938. Transactions_gtid_foreign_engine
    939. Transactions_multi_engine
    940. Update_scan
    941. Uptime
    942. Uptime_since_flush_status
    943. wsrep
    944. wsrep_applier_thread_count
    945. wsrep_apply_oooe
    946. wsrep_apply_oool
    947. wsrep_cert_deps_distance
    948. wsrep_cluster_capabilities
    949. wsrep_cluster_conf_id
    950. wsrep_cluster_size
    951. wsrep_cluster_state_uuid
    952. wsrep_cluster_status
    953. wsrep_connected
    954. wsrep_flow_control_paused
    955. wsrep_flow_control_recv
    956. wsrep_flow_control_sent
    957. wsrep_last_committed
    958. wsrep_local_bf_aborts
    959. wsrep_local_cert_failures
    960. wsrep_local_commits
    961. wsrep_local_index
    962. wsrep_local_recv_queue
    963. wsrep_local_recv_queue_avg
    964. wsrep_local_replays
    965. wsrep_local_send_queue
    966. wsrep_local_send_queue_avg
    967. wsrep_local_state
    968. wsrep_local_state_comment
    969. wsrep_local_state_uuid
    970. wsrep_protocol_version
    971. wsrep_provider_name
    972. wsrep_provider_vendor
    973. wsrep_provider_version
    974. wsrep_ready
    975. wsrep_received
    976. wsrep_received_bytes
    977. wsrep_replicated
    978. wsrep_replicated_bytes
    979. wsrep_rollbacker_thread_count
    980. wsrep_thread_count

The full list of status variables are listed in the contents on this page; most are described on this page, but some are described elsewhere:

See also the Full list of MariaDB options, system and status variables.

Use the SHOW STATUS statement to view status variables. This information also can be obtained using the mariadb-admin extended-status command, or by querying the Information Schema GLOBAL_STATUS and SESSION_STATUS tables.

Issuing a FLUSH STATUS will reset many status variables to zero.

List of Server Status Variables

Aborted_clients

  • Description: Number of aborted client connections. This can be due to the client not calling mysql_close() before exiting, the client sleeping without issuing a request to the server for more seconds than specified by wait_timeout or interactive_timeout, or by the client program ending in the midst of transferring data. The global value can be flushed by FLUSH STATUS.
  • Scope: Global
  • Data Type: numeric

Aborted_connects

  • Description: Number of failed server connection attempts. This can be due to a client using an incorrect password, a client not having privileges to connect to a database, a connection packet not containing the correct information, or if it takes more than connect_timeout seconds to get a connect packet. The global value can be flushed by FLUSH STATUS.
  • Scope: Global
  • Data Type: numeric

Aborted_connects_preauth

  • Description: Number of connection attempts that were aborted prior to authentication (regardless of whether or not an error occured).
  • Scope: Global
  • Data Type: numeric

Access_denied_errors


Acl_column_grants

  • Description: Number of column permissions granted (rows in the mysql.columns_priv table).
  • Scope: Global
  • Data Type: numeric

Acl_database_grants

  • Description: Number of database permissions granted (rows in the mysql.db table).
  • Scope: Global
  • Data Type: numeric

Acl_function_grants

  • Description: Number of function permissions granted (rows in the mysql.procs_priv table with a routine type of FUNCTION).
  • Scope: Global
  • Data Type: numeric

Acl_package_body_grants

  • Description:
  • Scope: Global
  • Data Type: numeric

Acl_package_spec_grants

  • Description:
  • Scope: Global
  • Data Type: numeric

Acl_procedure_grants

  • Description: Number of procedure permissions granted (rows in the mysql.procs_priv table with a routine type of PROCEDURE).
  • Scope: Global
  • Data Type: numeric

Acl_proxy_users

  • Description: Number of proxy permissions granted (rows in the mysql.proxies_priv table).
  • Scope: Global
  • Data Type: numeric

Acl_role_grants


Acl_roles

  • Description: Number of roles (rows in the mysql.user table where is_role='Y').
  • Scope: Global
  • Data Type: numeric

Acl_table_grants

  • Description: Number of table permissions granted (rows in the mysql.tables_priv table).
  • Scope: Global
  • Data Type: numeric

Acl_users

  • Description: Number of users (rows in the mysql.user table where is_role='N').
  • Scope: Global
  • Data Type: numeric

Busy_time

  • Description: Cumulative time in seconds of activity on connections. Part of User Statistics. Requires the userstat system variable to be set in order to be recorded.
  • Scope: Global
  • Data Type: numeric

Bytes_received

  • Description: Total bytes received from all clients.
  • Scope: Global
  • Data Type: numeric

Bytes_sent

  • Description: Total bytes sent to all clients.
  • Scope: Global, Session
  • Data Type: numeric

Com_admin_commands

  • Description: Number of admin commands executed. These include table dumps, change users, binary log dumps, shutdowns, pings and debugs.
  • Scope: Global, Session
  • Data Type: numeric

Com_alter_db

  • Description: Number of ALTER DATABASE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_alter_db_upgrade


Com_alter_event

  • Description: Number of ALTER EVENT commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_alter_function

  • Description: Number of ALTER FUNCTION commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_alter_procedure

  • Description: Number of ALTER PROCEDURE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_alter_sequence

  • Description: Number of ALTER SEQUENCE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_alter_server

  • Description: Number of ALTER SERVER commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_alter_table

  • Description: Number of ALTER TABLE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_alter_tablespace

  • Description: Number of ALTER TABLESPACE commands executed (unsupported by MariaDB).
  • Scope: Global, Session
  • Data Type: numeric
  • Removed: MariaDB 10.7.0

Com_alter_user

  • Description: Number of ALTER USER commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_analyze

  • Description: Number of ANALYZE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_assign_to_keycache

  • Description: Number of assign to keycache commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_backup

  • Description:
  • Scope: Global, Session
  • Data Type: numeric
  • Removed: MariaDB 10.4.1

Com_backup_lock

  • Description:
  • Scope: Global, Session
  • Data Type: numeric
  • Removed: MariaDB 10.4.2

Com_backup_table

  • Description: Removed in MariaDB 5.5. In older versions, Com_backup_table contains the number of BACKUP TABLE commands executed.
  • Scope: Global, Session
  • Data Type: numeric
  • Removed: MariaDB 5.5

Com_begin

  • Description: Number of BEGIN or START TRANSACTION statements executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_binlog

  • Description: Number of BINLOG commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_call_procedure

  • Description: Number of CALL procedure_name statements executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_change_db

  • Description: Number of USE database_name commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_check

  • Description: Number of CHECK TABLE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_checksum

  • Description: Number of CHECKSUM TABLE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_commit

  • Description: Number of COMMIT commands executed. Differs from Handler_commit, which counts internal commit statements.
  • Scope: Global, Session
  • Data Type: numeric

Com_compound_sql

  • Description: Number of compund sql statements.
  • Scope: Global, Session
  • Data Type: numeric

Com_create_db

  • Description: Number of CREATE DATABASE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_create_event

  • Description: Number of CREATE EVENT commands executed. Differs from Executed_events in that it is incremented when the CREATE EVENT is run, and not when the event executes.
  • Scope: Global, Session
  • Data Type: numeric

Com_create_function

  • Description: Number of CREATE FUNCTION commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_create_index

  • Description: Number of CREATE INDEX commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_create_package

  • Description:
  • Scope: Global, Session
  • Data Type: numeric

Com_create_package_body

  • Description:
  • Scope: Global, Session
  • Data Type: numeric

Com_create_procedure

  • Description: Number of CREATE PROCEDURE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_create_role

  • Description: Number of CREATE ROLE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_create_sequence

  • Description: Number of CREATE SEQUENCE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_create_server

  • Description: Number of CREATE SERVER commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_create_table

  • Description: Number of CREATE TABLE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_create_temporary_table


Com_create_trigger

  • Description: Number of CREATE TRIGGER commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_create_udf

  • Description: Number of CREATE UDF commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_create_user

  • Description: Number of CREATE USER commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_create_view

  • Description: Number of CREATE VIEW commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_dealloc_sql

  • Description: Number of DEALLOCATE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_delete

  • Description: Number of DELETE commands executed. Differs from Handler_delete, which counts the number of times rows have been deleted from tables.
  • Scope: Global, Session
  • Data Type: numeric

Com_delete_multi

  • Description: Number of multi-table DELETE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_do

  • Description: Number of DO commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_drop_db

  • Description: Number of DROP DATABASE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_drop_event

  • Description: Number of DROP EVENT commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_drop_function

  • Description: Number of DROP FUNCTION commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_drop_index

  • Description: Number of DROP INDEX commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_drop_package

  • Description:
  • Scope: Global, Session
  • Data Type: numeric

Com_drop_package_body

  • Description:
  • Scope: Global, Session
  • Data Type: numeric

Com_drop_procedure

  • Description: Number of DROP PROCEDURE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_drop_role

  • Description: Number of DROP ROLE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_drop_sequence

  • Description: Number of DROP SEQUENCE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_drop_server

  • Description: Number of DROP SERVER commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_drop_table

  • Description: Number of DROP TABLE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_drop_temporary_table

  • Description: Number of DROP TEMPORARY TABLE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_drop_trigger

  • Description: Number of DROP TRIGGER commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_drop_user

  • Description: Number of DROP USER commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_drop_view

  • Description: Number of DROP VIEW commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_empty_query

  • Description: Number of queries to the server that do not produce SQL queries. An SQL query simply returning no results does not increment Com_empty_query - see Empty_queries instead. An example of an empty query sent to the server is mariadb --comments -e '-- sql comment'
  • Scope: Global, Session
  • Data Type: numeric

Com_execute_immediate

  • Description: Number of EXECUTE IMMEDIATE statements executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_execute_sql

  • Description: Number of EXECUTE statements executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_flush

  • Description: Number of FLUSH commands executed. This differs from Flush_commands, which also counts internal server flush requests.
  • Scope: Global, Session
  • Data Type: numeric

Com_get_diagnostics

  • Description: Number of GET DIAGNOSTICS commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_grant

  • Description: Number of GRANT commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_grant_role

  • Description: Number of GRANT role commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_ha_close

  • Description: Number of HANDLER table_name CLOSE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_ha_open

  • Description: Number of HANDLER table_name OPEN commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_ha_read

  • Description: Number of HANDLER table_name READ commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_help

  • Description: Number of HELP commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_insert

  • Description: Number of INSERT commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_insert_select

  • Description: Number of INSERT ... SELECT commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_install_plugin

  • Description: Number of INSTALL PLUGIN commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_kill

  • Description: Number of KILL commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_load

  • Description: Number of LOAD commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_load_master_data

  • Description:
  • Scope: Global, Session
  • Data Type: numeric
  • Removed: MariaDB 5.5

Com_load_master_table

  • Description:
  • Scope: Global, Session
  • Data Type: numeric
  • Removed: MariaDB 5.5

Com_multi

  • Description:
  • Scope: Global, Session
  • Data Type: numeric

Com_lock_tables

  • Description: Number of [lock-tables|LOCK TABLES]] commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_optimize

  • Description: Number of OPTIMIZE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_preload_keys

  • Description:
  • Scope: Global, Session
  • Data Type: numeric

Com_prepare_sql

  • Description: Number of PREPARE statements executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_purge

  • Description: Number of PURGE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_purge_before_date

  • Description: Number of PURGE BEFORE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_release_savepoint

  • Description: Number of RELEASE SAVEPOINT commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_rename_table

  • Description: Number of RENAME TABLE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_rename_user

  • Description: Number of RENAME USER commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_repair

  • Description: Number of REPAIR TABLE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_replace

  • Description: Number of REPLACE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_replace_select

  • Description: Number of REPLACE ... SELECT commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_reset

  • Description: Number of RESET commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_resignal

  • Description: Number of RESIGNAL commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_restore_table

  • Description: Removed in MariaDB 5.5. In older versions, Com_restore_table contains the number of RESTORE TABLE commands executed.
  • Scope: Global, Session
  • Data Type: numeric
  • Removed: MariaDB 5.5

Com_revoke

  • Description: Number of REVOKE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_revoke_all

  • Description: Number of REVOKE ALL commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_revoke_grant

  • Description: Number of REVOKE role commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_rollback

  • Description: Number of ROLLBACK commands executed. Differs from Handler_rollback, which is the number of transaction rollback requests given to a storage engine.
  • Scope: Global, Session
  • Data Type: numeric

Com_rollback_to_savepoint


Com_savepoint

  • Description: Number of SAVEPOINT commands executed. Differs from Handler_savepoint, which is the number of transaction savepoint creation requests.
  • Scope: Global, Session
  • Data Type: numeric

Com_select

  • Description: Number of SELECT commands executed. Also includes queries that make use of the query cache.
  • Scope: Global, Session
  • Data Type: numeric

Com_set_option

  • Description: Number of SET OPTION commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_signal

  • Description: Number of SIGNAL statements executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_authors

  • Description: Number of SHOW AUTHORS commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_binlog_events

  • Description: Number of SHOW BINLOG EVENTS statements executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_binlogs

  • Description: Number of SHOW BINARY LOGS commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_charsets

  • Description: Number of SHOW CHARACTER SET commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_client_statistics


Com_show_collations

  • Description: Number of SHOW COLLATION commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_column_types

  • Description:
  • Scope: Global, Session
  • Data Type: numeric
  • Removed: MariaDB 5.5

Com_show_contributors

  • Description: Number of SHOW CONTRIBUTORS commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_create_db

  • Description: Number of SHOW CREATE DATABASE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_create_event

  • Description: Number of SHOW CREATE EVENT commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_create_func

  • Description: Number of SHOW CREATE FUNCTION commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_create_package

  • Description:
  • Scope: Global, Session
  • Data Type: numeric

Com_show_create_package_body

  • Description:
  • Scope: Global, Session
  • Data Type: numeric

Com_show_create_proc

  • Description: Number of SHOW CREATE PROCEDURE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_create_table

  • Description: Number of SHOW CREATE TABLE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_create_trigger

  • Description: Number of SHOW CREATE TRIGGER commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_create_user

  • Description: Number of SHOW CREATE USER commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_databases

  • Description: Number of SHOW DATABASES commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_engine_logs

  • Description: Number of SHOW ENGINE LOGS commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_engine_mutex

  • Description: Number of SHOW ENGINE MUTEX commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_engine_status

  • Description: Number of SHOW ENGINE STATUS commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_events

  • Description: Number of SHOW EVENTS commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_errors

  • Description: Number of SHOW ERRORS commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_explain

  • Description: Number of SHOW EXPLAIN commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_fields

  • Description: Number of SHOW COLUMNS or SHOW FIELDS commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_function_status

  • Description: Number of SHOW FUNCTION STATUS commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_generic


Com_show_grants

  • Description: Number of SHOW GRANTS commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_keys

  • Description: Number of SHOW INDEX or SHOW KEYS commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_index_statistics


Com_show_open_tables

  • Description: Number of SHOW OPEN TABLES commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_package_status

  • Description:
  • Scope: Global, Session
  • Data Type: numeric

Com_show_package_body_status

  • Description:
  • Scope: Global, Session
  • Data Type: numeric

Com_show_plugins

  • Description: Number of SHOW PLUGINS commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_privileges

  • Description: Number of SHOW PRIVILEGES commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_procedure_status

  • Description: Number of SHOW PROCEDURE STATUS commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_processlist

  • Description: Number of SHOW PROCESSLIST commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_profile

  • Description: Number of SHOW PROFILE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_profiles

  • Description: Number of SHOW PROFILES commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_relaylog_events

  • Description: Number of SHOW RELAYLOG EVENTS commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_status

  • Description: Number of SHOW STATUS commands executed.
  • Scope: Global, Session
  • Data Type: numericst

Com_show_storage_engines

  • Description: Number of SHOW STORAGE ENGINES - or SHOW ENGINES - commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_table_statistics


Com_show_table_status

  • Description: Number of SHOW TABLE STATUS commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_tables

  • Description: Number of SHOW TABLES commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_triggers

  • Description: Number of SHOW TRIGGERS commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_user_statistics


Com_show_variable

  • Description: Number of SHOW VARIABLES commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_show_warnings

  • Description: Number of SHOW WARNINGS commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_shutdown

  • Description: Number of SHUTDOWN commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_stmt_close


Com_stmt_execute


Com_stmt_fetch


Com_stmt_prepare


Com_stmt_reprepare

  • Description: Number of prepared statements reprepared.
  • Scope: Global, Session
  • Data Type: numeric

Com_stmt_reset

  • Description: Number of prepared statements where the data of a prepared statement which was accumulated in chunks by sending long data has been reset.
  • Scope: Global, Session
  • Data Type: numeric

Com_stmt_send_long_data

  • Description: Number of prepared statements where the parameter data has been sent in chunks (long data).
  • Scope: Global, Session
  • Data Type: numeric

Com_truncate

  • Description: Number of TRUNCATE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_uninstall_plugin

  • Description: Number of UNINSTALL PLUGIN commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_unlock_tables

  • Description: Number of UNLOCK TABLES commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_update

  • Description: Number of UPDATE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_update_multi

  • Description: Number of multi-table UPDATE commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_xa_commit

  • Description: Number of XA statements committed.
  • Scope: Global, Session
  • Data Type: numeric

Com_xa_end

  • Description: Number of XA statements ended.
  • Scope: Global, Session
  • Data Type: numeric

Com_xa_prepare

  • Description: Number of XA statements prepared.
  • Scope: Global, Session
  • Data Type: numeric

Com_xa_recover

  • Description: Number of XA RECOVER statements executed.
  • Scope: Global, Session
  • Data Type: numeric

Com_xa_rollback

  • Description: Number of XA statements rolled back.
  • Scope: Global, Session
  • Data Type: numeric

Com_xa_start

  • Description: Number of XA statements started.
  • Scope: Global, Session
  • Data Type: numeric

Compression

  • Description: Whether client-server traffic is compressed.
  • Scope: Session
  • Data Type: boolean

Connection_errors_accept

  • Description: Number of errors that occurred during calls to accept() on the listening port. The global value can be flushed by FLUSH STATUS.
  • Scope: Global
  • Data Type: numeric

Connection_errors_internal

  • Description: Number of refused connections due to internal server errors, for example out of memory errors, or failed thread starts. The global value can be flushed by FLUSH STATUS.
  • Scope: Global
  • Data Type: numeric

Connection_errors_max_connections

  • Description: Number of refused connections due to the max_connections limit being reached. The global value can be flushed by FLUSH STATUS.
  • Scope: Global
  • Data Type: numeric

Connection_errors_peer_address

  • Description: Number of errors while searching for the connecting client IP address. The global value can be flushed by FLUSH STATUS.
  • Scope: Global
  • Data Type: numeric

Connection_errors_select

  • Description: Number of errors during calls to select() or poll() on the listening port. The client would not necessarily have been rejected in these cases. The global value can be flushed by FLUSH STATUS.
  • Scope: Global
  • Data Type: numeric

Connection_errors_tcpwrap

  • Description: Number of connections the libwrap library refused. The global value can be flushed by FLUSH STATUS.
  • Scope: Global
  • Data Type: numeric

Connections

  • Description: Number of connection attempts (both successful and unsuccessful)
  • Scope: Global
  • Data Type: numeric

Cpu_time

  • Description: Total CPU time used. Part of User Statistics. Requires the userstat system variable to be set in order to be recorded.
  • Scope: Global, Session
  • Data Type: numeric

Created_tmp_disk_tables

  • Description: Number of on-disk temporary tables created.
  • Scope: Global, Session
  • Data Type: numeric

Created_tmp_files

  • Description: Number of temporary files created. The global value can be flushed by FLUSH STATUS.
  • Scope: Global
  • Data Type: numeric

Created_tmp_tables

  • Description: Number of in-memory temporary tables created.
  • Scope: Global
  • Data Type: numeric

Delayed_errors

  • Description: Number of errors which occurred while doing INSERT DELAYED. The global value can be flushed by FLUSH STATUS.
  • Scope: Global
  • Data Type: numeric

Delayed_insert_threads

  • Description: Number of INSERT DELAYED threads.
  • Scope: Global
  • Data Type: numeric

Delayed_writes

  • Description: Number of INSERT DELAYED rows written. The global value can be flushed by FLUSH STATUS.
  • Scope: Global
  • Data Type: numeric

Delete_scan

  • Description: Number of DELETEs that required a full table scan.
  • Scope: Global
  • Data Type: numeric

Empty_queries

  • Description: Number of queries returning no results. Note this is not the same as Com_empty_query.
  • Scope: Global, Session
  • Data Type: numeric

Executed_events

  • Description: Number of times events created with CREATE EVENT have executed. This differs from Com_create_event in that it is only incremented when the event has run, not when it executes.
  • Scope: Global, Session
  • Data Type: numeric

Executed_triggers

  • Description: Number of times triggers created with CREATE TRIGGER have executed. This differs from Com_create_trigger in that it is only incremented when the trigger has run, not when it executes.
  • Scope: Global, Session
  • Data Type: numeric

Feature_application_time_periods

  • Description: Number of times a table created with periods has been opened.
  • Scope: Global, Session
  • Data Type: numeric

Feature_check_constraint

  • Description: Number of times constraints were checked. The global value can be flushed by FLUSH STATUS.
  • Scope: Global, Session
  • Data Type: numeric

Feature_custom_aggregate_functions


Feature_delay_key_write

  • Description: Number of tables opened that are using delay_key_write. The global value can be flushed by FLUSH STATUS.
  • Scope: Global, Session
  • Data Type: numeric

Feature_dynamic_columns

  • Description: Number of times the COLUMN_CREATE() function was used.
  • Scope: Global, Session
  • Data Type: numeric

Feature_fulltext

  • Description: Number of times the MATCH … AGAINST() function was used.
  • Scope: Global, Session
  • Data Type: numeric

Feature_gis

  • Description: Number of times a table with a any of the geometry columns was opened.
  • Scope: Global, Session
  • Data Type: numeric

Feature_insert_returning

  • Description:
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 10.5.0

Feature_invisible_columns

  • Description: Number of invisible columns in all opened tables.
  • Scope: Global, Session
  • Data Type: numeric

Feature_json


Feature_locale

  • Description: Number of times the @@lc_messages variable was assigned into.
  • Scope: Global, Session
  • Data Type: numeric

Feature_subquery

  • Description: Number of subqueries (excluding subqueries in the FROM clause) used.
  • Scope: Global, Session
  • Data Type: numeric

Feature_system_versioning

  • Description: Number of times system versioning functionality has been used (opening a table WITH SYSTEM VERSIONING).
  • Scope: Global, Session
  • Data Type: numeric

Feature_timezone

  • Description: Number of times an explicit timezone (excluding UTC and SYSTEM) was specified.
  • Scope: Global, Session
  • Data Type: numeric

Feature_trigger

  • Description: Number of triggers loaded.
  • Scope: Global, Session
  • Data Type: numeric

Feature_window_functions

  • Description: Number of times window functions were used.
  • Scope: Global, Session
  • Data Type: numeric

Feature_xml

  • Description: Number of times XML functions (EXTRACTVALUE() and UPDATEXML()) were used.
  • Scope: Global, Session
  • Data Type: numeric

Flush_commands

  • Description: Number of FLUSH statements executed, as well as due to internal server flush requests. This differs from Com_flush, which simply counts FLUSH statements, not internal server flush operations.
  • Scope: Global
  • Data Type: numeric
  • Removed: MariaDB 10.5.1

Handler_commit

  • Description: Number of internal COMMIT requests. Differs from Com_commit, which counts the number of COMMIT statements executed.
  • Scope: Global, Session
  • Data Type: numeric

Handler_delete

  • Description: Number of times rows have been deleted from tables. Differs from Com_delete, which counts DELETE statements.
  • Scope: Global, Session
  • Data Type: numeric

Handler_discover

  • Description: Discovery is when the server asks the NDBCLUSTER storage engine if it knows about a table with a given name. Handler_discover indicates the number of times that tables have been discovered in this way.
  • Scope: Global, Session
  • Data Type: numeric

Handler_external_lock

  • Description: Incremented for each call to the external_lock() function, which generally occurs at the beginning and end of access to a table instance.
  • Scope: Global, Session
  • Data Type: numeric

Handler_icp_attempts

  • Description: Number of times pushed index condition was checked. The smaller the ratio of Handler_icp_attempts to Handler_icp_match the better the filtering. See Index Condition Pushdown.
  • Scope: Global, Session
  • Data Type: numeric

Handler_icp_match

  • Description: Number of times pushed index condition was matched. The smaller the ratio of Handler_icp_attempts to Handler_icp_match the better the filtering. See See Index Condition Pushdown.
  • Scope: Global, Session
  • Data Type: numeric

Handler_mrr_init

  • Description: Counts how many MRR (multi-range read) scans were performed. See Multi Range Read optimization.
  • Scope: Global, Session
  • Data Type: numeric

Handler_mrr_key_refills

  • Description: Number of times key buffer was refilled (not counting the initial fill). A non-zero value indicates there wasn't enough memory to do key sort-and-sweep passes in one go. See Multi Range Read optimization.
  • Scope: Global, Session
  • Data Type: numeric

Handler_mrr_rowid_refills

  • Description: Number of times rowid buffer was refilled (not counting the initial fill). A non-zero value indicates there wasn't enough memory to do rowid sort-and-sweep passes in one go. See Multi Range Read optimization.
  • Scope: Global, Session
  • Data Type: numeric

Handler_prepare

  • Description: Number of two-phase commit prepares.
  • Scope: Global, Session
  • Data Type: numeric

Handler_read_first

  • Description: Number of requests to read the first row from an index. A high value indicates many full index scans, e.g. SELECT a FROM table_name where a is an indexed column.
  • Scope: Global, Session
  • Data Type: numeric

Handler_read_key

  • Description: Number of row read requests based on an index value. A high value indicates indexes are regularly being used, which is usually positive.
  • Scope: Global, Session
  • Data Type: numeric

Handler_read_last

  • Description: Number of requests to read the last row from an index. ORDER BY DESC results in a last-key request followed by several previous-key requests.
  • Scope: Global, Session
  • Data Type: numeric

Handler_read_next

  • Description: Number of requests to read the next row from an index (in order). Increments when doing an index scan or querying an index column with a range constraint.
  • Scope: Global, Session
  • Data Type: numeric

Handler_read_prev

  • Description: Number of requests to read the previous row from an index (in order). Mostly used with ORDER BY DESC.
  • Scope: Global, Session
  • Data Type: numeric

Handler_read_retry

  • Description: Number of read retrys triggered by semi_consistent_read (InnoDB feature).
  • Scope: Global
  • Data Type: numeric

Handler_read_rnd

  • Description: Number of requests to read a row based on its position. If this value is high, you may not be using joins that don't use indexes properly, or be doing many full table scans.
  • Scope: Global, Session
  • Data Type: numeric

Handler_read_rnd_deleted

  • Description: Number of requests to delete a row based on its position.
  • Scope: Global, Session
  • Data Type: numeric

Handler_read_rnd_next

  • Description: Number of requests to read the next row. A large number of these may indicate many table scans and improperly used indexes.
  • Scope: Global, Session
  • Data Type: numeric

Handler_rollback

  • Description: Number of transaction rollback requests given to a storage engine. Differs from Com_rollback, which is the number of ROLLBACK commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Handler_savepoint

  • Description: Number of transaction savepoint creation requests. Differs from Com_savepoint which is the number of SAVEPOINT commands executed.
  • Scope: Global, Session
  • Data Type: numeric

Handler_savepoint_rollback

  • Description: Number of requests to rollback to a transaction savepoint.
  • Scope: Global, Session
  • Data Type: numeric

Handler_tmp_delete

  • Description: Number of requests to delete a row in a temporary table.
  • Scope: Global, Session
  • Data Type: numeric

Handler_tmp_update

  • Description: Number of requests to update a row to a temporary table.
  • Scope: Global, Session
  • Data Type: numeric

Handler_tmp_write

  • Description: Number of requests to write a row to a temporary table.
  • Scope: Global, Session
  • Data Type: numeric

Handler_update

  • Description: Number of requests to update a row in a table. Since MariaDB 5.3, this no longer counts temporary tables - see Handler_tmp_update.
  • Scope: Global, Session
  • Data Type: numeric

Handler_write

  • Description: Number of requests to write a row to a table. Since MariaDB 5.3, this no longer counts temporary tables - see Handler_tmp_write.
  • Scope: Global, Session
  • Data Type: numeric

Key_blocks_not_flushed

  • Description: Number of key cache blocks which have been modified but not flushed to disk.
  • Scope: Global
  • Data Type: numeric

Key_blocks_unused

  • Description: Number of unused key cache blocks.
  • Scope: Global
  • Data Type: numeric

Key_blocks_used

  • Description: Max number of key cache blocks which have been used simultaneously.
  • Scope: Global
  • Data Type: numeric

Key_blocks_warm

  • Description: Number of key cache blocks in the warm list.
  • Scope: Global
  • Data Type: numeric

Key_read_requests


Key_reads


Key_write_requests

  • Description: Number of requests to write a block to the key cache.
  • Scope: Global
  • Data Type: numeric

Key_writes

  • Description: Number of key cache block write requests
  • Scope: Global
  • Data Type: numeric

Last_query_cost

  • Description: The most recent query optimizer query cost calculation. Can not be calculated for complex queries, such as subqueries or UNION. It will be set to 0 for complex queries.
  • Scope: Session
  • Data Type: numeric

Maria_*

  • Description: When the Maria storage engine was renamed Aria, the Maria variables existing at the time were renamed at the same time. See Aria Server Status Variables.

Max_memory_used

  • Description: The maximum memory allocation used by the current connection.
  • Scope: Session
  • Data Type: numeric
  • Introduced: MariaDB 10.6.21

Max_statement_time_exceeded


Max_tmp_space_used


Max_used_connections

  • Description: Max number of connections ever open at the same time. The global value can be flushed by FLUSH STATUS.
  • Scope: Global
  • Data Type: numeric

Max_used_connections_time


Memory_used

  • Description: Global or per-connection memory usage, in bytes. This includes all per-connection memory allocations, but excludes global allocations such as the key_buffer, innodb_buffer_pool etc.
  • Scope: Global, Session
  • Data Type: numeric

Memory_used_initial

  • Description: Amount of memory that was used when the server started to service the user connections.
  • Scope: Global
  • Data Type: numeric

Not_flushed_delayed_rows

  • Description: Number of INSERT DELAYED rows waiting to be written.
  • Scope: Global
  • Data Type: numeric

Open_files

  • Description: Number of regular files currently opened by the server. Does not include sockets or pipes, or storage engines using internal functions.
  • Scope: Global
  • Data Type: numeric

Open_streams

  • Description: Number of currently opened streams, usually log files.
  • Scope: Global
  • Data Type: numeric

Open_table_definitions

  • Description: Number of currently cached .frm files.
  • Scope: Global
  • Data Type: numeric

Open_tables

  • Description: Number of currently opened tables, excluding temporary tables.
  • Scope: Global, Session
  • Data Type: numeric

Opened_files

  • Description: Number of files the server has opened.
  • Scope: Global
  • Data Type: numeric

Opened_plugin_libraries

  • Description: Number of shared libraries that the server has opened to load plugins.
  • Scope: Global
  • Data Type: numeric

Opened_table_definitions

  • Description: Number of .frm files that have been cached.
  • Scope: Global, Session
  • Data Type: numeric

Opened_tables

  • Description: Number of tables the server has opened.
  • Scope: Global, Session
  • Data Type: numeric

Opened_views

  • Description: Number of views the server has opened.
  • Scope: Global, Session
  • Data Type: numeric

Prepared_stmt_count

  • Description: Current number of prepared statements.
  • Scope: Global
  • Data Type: numeric

Qcache_free_blocks

  • Description: Number of free query cache memory blocks.
  • Scope: Global
  • Data Type: numeric

Qcache_free_memory

  • Description: Amount of free query cache memory.
  • Scope: Global
  • Data Type: numeric

Qcache_hits

  • Description: Number of requests served by the query cache. The global value can be flushed by FLUSH STATUS.
  • Scope: Global
  • Data Type: numeric

Qcache_inserts

  • Description: Number of queries ever cached in the query cache. The global value can be flushed by FLUSH STATUS.
  • Scope: Global
  • Data Type: numeric

Qcache_lowmem_prunes

  • Description: Number of pruning operations performed to remove old results to make space for new results in the query cache. The global value can be flushed by FLUSH STATUS.
  • Scope: Global
  • Data Type: numeric

Qcache_not_cached

  • Description: Number of queries that are uncacheable by the query cache, or use SQL_NO_CACHE. The global value can be flushed by FLUSH STATUS.
  • Scope: Global
  • Data Type: numeric

Qcache_queries_in_cache

  • Description: Number of queries currently cached by the query cache.
  • Scope: Global
  • Data Type: numeric

Qcache_total_blocks

  • Description: Number of blocks used by the query cache.
  • Scope: Global
  • Data Type: numeric

Queries

  • Description: Number of statements executed by the server, excluding COM_PING and COM_STATISTICS. Differs from Questions in that it also counts statements executed within stored programs.
  • Scope: Global, Session
  • Data Type: numeric

Query_time

  • Description: Cumulative time in seconds, with microsecond precision, of running queries.
  • Scope: Global,Session
  • Data Type: numeric
  • Introduced: MariaDB 11.4

Questions

  • Description: Number of statements executed by the server, excluding COM_PING, COM_STATISTICS, COM_STMT_PREPARE, COM_STMT_CLOSE, and COM_STMT_RESET statements. Differs from Queries in that it doesn't count statements executed within stored programs.
  • Scope: Global, Session
  • Data Type: numeric

Resultset_metadata_skipped

  • Description: Number of times sending the metadata has been skipped. Metadata is not resent if metadata does not change between prepare and execute of prepared statement, or between executes.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 10.6.0

Rows_read

  • Description: Number of requests to read a row (excluding temporary tables).
  • Scope: Global, Session
  • Data Type: numeric

Rows_sent

  • Description:
  • Scope: Global, Session
  • Data Type: numeric

Rows_tmp_read

  • Description: Number of requests to read a row in a temporary table.
  • Scope: Global, Session
  • Data Type: numeric

Select_full_join

  • Description: Number of joins which did not use an index. If not zero, you may need to check table indexes.
  • Scope: Global, Session
  • Data Type: numeric

Select_full_range_join

  • Description: Number of joins which used a range search of the first table.
  • Scope: Global, Session
  • Data Type: numeric

Select_range

  • Description: Number of joins which used a range on the first table.
  • Scope: Global, Session
  • Data Type: numeric

Select_range_check

  • Description: Number of joins without keys that check for key usage after each row. If not zero, you may need to check table indexes.
  • Scope: Global, Session
  • Data Type: numeric

Select_scan

  • Description: Number of joins which used a full scan of the first table.
  • Scope: Global, Session
  • Data Type: numeric

Slow_launch_threads

  • Description: Number of threads which took longer than slow_launch_time to create. The global value can be flushed by FLUSH STATUS.
  • Scope: Global, Session
  • Data Type: numeric

Slow_queries

  • Description: Number of queries which took longer than long_query_time to run. The slow query log does not need to be active for this to be recorded.
  • Scope: Global, Session
  • Data Type: numeric

Sort_merge_passes

  • Description: Number of merge passes performed by the sort algorithm. If too high, you may need to look at improving your query indexes, or increasing the sort_buffer_size.
  • Scope: Global, Session
  • Data Type: numeric

Sort_priority_queue_sorts


Sort_range

  • Description: Number of sorts which used a range.
  • Scope: Global, Session
  • Data Type: numeric

Sort_rows

  • Description: Number of rows sorted.
  • Scope: Global, Session
  • Data Type: numeric

Sort_scan

  • Description: Number of sorts which used a full table scan.
  • Scope: Global, Session
  • Data Type: numeric

Subquery_cache_hit

  • Description: Counter for all subquery cache hits. The global value can be flushed by FLUSH STATUS.
  • Scope: Global, Session
  • Data Type: numeric

Subquery_cache_miss

  • Description: Counter for all subquery cache misses. The global value can be flushed by FLUSH STATUS.
  • Scope: Global, Session
  • Data Type: numeric

Syncs

  • Description: Number of times my_sync() has been called, or the number of times the server has had to force data to disk. Covers the binary log, .frm creation (if these operations are configured to sync) and some storage engines (Archive, CSV, Aria), but not XtraDB/InnoDB).
  • Scope: Global, Session
  • Data Type: numeric

Table_locks_immediate

  • Description: Number of table locks which were completed immediately. The global value can be flushed by FLUSH STATUS.
  • Scope: Global
  • Data Type: numeric

Table_locks_waited

  • Description: Number of table locks which had to wait. Indicates table lock contention. The global value can be flushed by FLUSH STATUS.
  • Scope: Global
  • Data Type: numeric

Table_open_cache_active_instances

  • Description: Number of active instances for open tables cache lookups.
  • Scope:
  • Data Type: numeric

Table_open_cache_hits

  • Description: Number of hits for open tables cache lookups.
  • Scope:
  • Data Type: numeric

Table_open_cache_misses

  • Description: Number of misses for open tables cache lookups.
  • Scope:
  • Data Type: numeric

Table_open_cache_overflows

  • Description: Number of overflows for open tables cache lookups.
  • Scope:
  • Data Type: numeric

Tc_log_max_pages_used


Tc_log_page_size


Tc_log_page_waits

  • Description: Number of times a two-phase commit was forced to wait for a free memory-mapped file-based transaction coordinator log page. The global value can be flushed by FLUSH STATUS.
  • Scope: Global
  • Data Type: numeric

Threads_cached

  • Description: Number of threads cached in the thread cache. This value will be zero if the thread pool is in use.
  • Scope: Global
  • Data Type: numeric

Threads_connected

  • Description: Number of clients connected to the server. See Handling Too Many Connections. The Threads_connected name is inaccurate when the thread pool is in use, since each client connection does not correspond to a dedicated thread in that case.
  • Scope: Global
  • Data Type: numeric

Threads_created

  • Description: Number of threads created to respond to client connections. If too large, look at increasing thread_cache_size.
  • Scope: Global
  • Data Type: numeric

Threads_running

  • Description: Number of client connections that are actively running a command, and not just sleeping while waiting to receive the next command to execute. Some internal system threads also count towards this status variable if they would show up in the output of the SHOW PROCESSLIST statement.
    • In MariaDB 10.3.2 and before, a global counter was updated each time a client connection dispatched a command. In these versions, the global and session status variable are always the same value.
    • In MariaDB 10.3.3 and later, the global counter has been removed as a performance improvement. Instead, when the global status variable is queried, it is calculated dynamically by essentially adding up all the running client connections as they would appear in SHOW PROCESSLIST output. A client connection is only considered to be running if its thread COMMAND value is not equal to Sleep. When the session status variable is queried, it always returns 1.
  • Scope: Global
  • Data Type: numeric

Tmp_space_used


Update_scan

  • Description: Number of updates that required a full table scan.
  • Scope: Global
  • Data Type: numeric

Uptime

  • Description: Number of seconds the server has been running.
  • Scope: Global
  • Data Type: numeric

Uptime_since_flush_status

  • Description: Number of seconds since the last FLUSH STATUS.
  • Scope: Global
  • Data Type: numeric

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
Back to Top