Server Status Variables

You are viewing an old version of this article. View the current version here.

Contents

  1. List of Server Status Variables
    1. Aborted_clients
    2. Aborted_connects
    3. Access_denied_errors
    4. Acl_column_grants
    5. Acl_database_grants
    6. Acl_function_grants
    7. Acl_procedure_grants
    8. Acl_proxy_users
    9. Acl_role_grants
    10. Acl_roles
    11. Acl_table_grants
    12. Acl_users
    13. Aria_pagecache_blocks_not_flushed
    14. Aria_pagecache_blocks_unused
    15. Aria_pagecache_blocks_used
    16. Aria_pagecache_read_requests
    17. Aria_pagecache_reads
    18. Aria_pagecache_write_requests
    19. Aria_pagecache_writes
    20. Aria_transaction_log_syncs
    21. Binlog_bytes_written
    22. Binlog_cache_disk_use
    23. Binlog_commits
    24. Binlog_group_commit_trigger_count
    25. Binlog_group_commit_trigger_lock_wait
    26. Binlog_group_commit_trigger_timeout
    27. Binlog_group_commits
    28. Binlog_snapshot_file
    29. Binlog_snapshot_position
    30. Binlog_stmt_cache_disk_use
    31. Binlog_stmt_cache_use
    32. Busy_time
    33. Bytes_received
    34. Bytes_sent
    35. Cassandra_multiget_keys_scanned
    36. Cassandra_multiget_reads
    37. Cassandra_multiget_rows_read
    38. Cassandra_row_inserts
    39. Cassandra_row_insert_batches
    40. Cassandra_timeout_exceptions
    41. Cassandra_unavailable_exceptions
    42. Com_admin_commands
    43. Com_alter_db
    44. Com_alter_db_upgrade
    45. Com_alter_event
    46. Com_alter_function
    47. Com_alter_procedure
    48. Com_alter_server
    49. Com_alter_table
    50. Com_alter_tablespace
    51. Com_analyze
    52. Com_assign_to_keycache
    53. Com_backup_table
    54. Com_begin
    55. Com_binlog
    56. Com_call_procedure
    57. Com_change_db
    58. Com_change_master
    59. Com_check
    60. Com_checksum
    61. Com_commit
    62. Com_compound_sql
    63. Com_create_db
    64. Com_create_event
    65. Com_create_function
    66. Com_create_index
    67. Com_create_procedure
    68. Com_create_role
    69. Com_create_server
    70. Com_create_table
    71. Com_create_trigger
    72. Com_create_udf
    73. Com_create_user
    74. Com_create_view
    75. Com_dealloc_sql
    76. Com_delete
    77. Com_delete_multi
    78. Com_do
    79. Com_drop_db
    80. Com_drop_event
    81. Com_drop_function
    82. Com_drop_index
    83. Com_drop_procedure
    84. Com_drop_role
    85. Com_drop_server
    86. Com_drop_table
    87. Com_drop_trigger
    88. Com_drop_user
    89. Com_drop_view
    90. Com_empty_query
    91. Com_execute_sql
    92. Com_flush
    93. Com_get_diagnostics
    94. Com_grant
    95. Com_grant_role
    96. Com_ha_close
    97. Com_ha_open
    98. Com_ha_read
    99. Com_help
    100. Com_insert
    101. Com_insert_select
    102. Com_install_plugin
    103. Com_kill
    104. Com_load
    105. Com_load_master_data
    106. Com_load_master_table
    107. Com_lock_tables
    108. Com_optimize
    109. Com_preload_keys
    110. Com_prepare_sql
    111. Com_purge
    112. Com_purge_before_date
    113. Com_release_savepoint
    114. Com_rename_table
    115. Com_rename_user
    116. Com_repair
    117. Com_replace
    118. Com_replace_select
    119. Com_reset
    120. Com_resignal
    121. Com_restore_table
    122. Com_revoke
    123. Com_revoke_all
    124. Com_revoke_grant
    125. Com_rollback
    126. Com_rollback_to_savepoint
    127. Com_savepoint
    128. Com_select
    129. Com_set_option
    130. Com_signal
    131. Com_show_authors
    132. Com_show_binlog_events
    133. Com_show_binlogs
    134. Com_show_charsets
    135. Com_show_client_statistics
    136. Com_show_collations
    137. Com_show_column_types
    138. Com_show_contributors
    139. Com_show_create_db
    140. Com_show_create_event
    141. Com_show_create_func
    142. Com_show_create_proc
    143. Com_show_create_table
    144. Com_show_create_trigger
    145. Com_show_databases
    146. Com_show_engine_logs
    147. Com_show_engine_mutex
    148. Com_show_engine_status
    149. Com_show_events
    150. Com_show_errors
    151. Com_show_explain
    152. Com_show_fields
    153. Com_show_function_status
    154. Com_show_generic
    155. Com_show_grants
    156. Com_show_keys
    157. Com_show_index_statistics
    158. com_show_master_status
    159. com_show_new_master
    160. Com_show_open_tables
    161. Com_show_plugins
    162. Com_show_privileges
    163. Com_show_procedure_status
    164. Com_show_processlist
    165. Com_show_profile
    166. Com_show_profiles
    167. Com_show_relaylog_events
    168. com_show_slave_hosts
    169. com_show_slave_status
    170. Com_show_status
    171. Com_show_storage_engines
    172. Com_show_table_statistics
    173. Com_show_table_status
    174. Com_show_tables
    175. Com_show_triggers
    176. Com_show_user_statistics
    177. Com_show_variable
    178. Com_show_warnings
    179. Com_shutdown
    180. Com_slave_start
    181. Com_slave_stop
    182. Com_start_all_slaves
    183. Com_start_slave
    184. Com_stmt_close
    185. Com_stmt_execute
    186. Com_stmt_fetch
    187. Com_stmt_prepare
    188. Com_stmt_reprepare
    189. Com_stmt_reset
    190. Com_stmt_send_long_data
    191. Com_stop_all_slaves
    192. Com_stop_slave
    193. Com_truncate
    194. Com_uninstall_plugin
    195. Com_unlock_tables
    196. Com_update
    197. Com_update_multi
    198. Com_xa_commit
    199. Com_xa_end
    200. Com_xa_prepare
    201. Com_xa_recover
    202. Com_xa_rollback
    203. Com_xa_start
    204. Compression
    205. Connection_errors_accept
    206. Connection_errors_internal
    207. Connection_errors_max_connections
    208. Connection_errors_peer_address
    209. Connection_errors_select
    210. Connection_errors_tcpwrap
    211. Connections
    212. Cpu_time
    213. Created_tmp_disk_tables
    214. Created_tmp_files
    215. Created_tmp_tables
    216. Delayed_errors
    217. Delayed_insert_threads
    218. Delayed_writes
    219. Empty_queries
    220. Executed_events
    221. Executed_triggers
    222. Feature_delay_key_write
    223. Feature_dynamic_columns
    224. Feature_fulltext
    225. Feature_gis
    226. Feature_locale
    227. Feature_subquery
    228. Feature_timezone
    229. Feature_trigger
    230. Feature_xml
    231. Flush_commands
    232. Handler_commit
    233. Handler_delete
    234. Handler_discover
    235. Handler_external_lock
    236. Handler_icp_attempts
    237. Handler_icp_match
    238. Handler_mrr_init
    239. Handler_mrr_key_refills
    240. Handler_mrr_rowid_refills
    241. Handler_prepare
    242. Handler_read_first
    243. Handler_read_key
    244. Handler_read_last
    245. Handler_read_next
    246. Handler_read_prev
    247. Handler_read_rnd
    248. Handler_read_rnd_deleted
    249. Handler_read_rnd_next
    250. Handler_rollback
    251. Handler_savepoint
    252. Handler_savepoint_rollback
    253. Handler_tmp_update
    254. Handler_tmp_write
    255. Handler_update
    256. Handler_write
    257. Innodb_adaptive_hash_cells
    258. Innodb_adaptive_hash_hash_searches
    259. Innodb_adaptive_hash_heap_buffers
    260. Innodb_adaptive_hash_non_hash_searches
    261. Innodb_available_undo_logs
    262. Innodb_background_log_sync
    263. Innodb_buffer_pool_bytes_data
    264. Innodb_buffer_pool_bytes_dirty
    265. Innodb_buffer_pool_dump_status
    266. innodb_buffer_pool_load_status
    267. Innodb_buffer_pool_pages_data
    268. Innodb_buffer_pool_pages_dirty
    269. Innodb_buffer_pool_pages_flushed
    270. Innodb_buffer_pool_pages_LRU_flushed
    271. Innodb_buffer_pool_pages_free
    272. Innodb_buffer_pool_pages_made_not_young
    273. Innodb_buffer_pool_pages_made_young
    274. Innodb_buffer_pool_pages_misc
    275. Innodb_buffer_pool_pages_old
    276. Innodb_buffer_pool_pages_total
    277. Innodb_buffer_pool_read_ahead_rnd
    278. Innodb_buffer_pool_read_ahead
    279. Innodb_buffer_pool_read_ahead_evicted
    280. Innodb_buffer_pool_read_requests
    281. Innodb_buffer_pool_reads
    282. Innodb_buffer_pool_wait_free
    283. Innodb_buffer_pool_write_requests
    284. Innodb_checkpoint_age
    285. Innodb_checkpoint_max_age
    286. Innodb_checkpoint_target_age
    287. Innodb_current_row_locks
    288. Innodb_data_fsyncs
    289. Innodb_data_pending_fsyncs
    290. Innodb_data_pending_reads
    291. Innodb_data_pending_writes
    292. Innodb_data_read
    293. Innodb_data_reads
    294. Innodb_data_writes
    295. Innodb_data_written
    296. Innodb_dblwr_pages_written
    297. Innodb_dblwr_writes
    298. Innodb_deadlocks
    299. Innodb_defragment_compression_failures
    300. Innodb_defragment_count
    301. Innodb_defragment_failures
    302. Innodb_dict_tables
    303. Innodb_encryption_rotation_estimated_iops
    304. Innodb_encryption_rotation_pages_flushed
    305. Innodb_encryption_rotation_pages_modified
    306. Innodb_encryption_rotation_pages_read_from_cache
    307. Innodb_encryption_rotation_pages_read_from_disk
    308. Innodb_have_atomic_builtins
    309. Innodb_have_bzip2
    310. Innodb_have_lz4
    311. Innodb_have_lzma
    312. Innodb_have_lzo
    313. Innodb_have_snappy
    314. Innodb_history_list_length
    315. Innodb_ibuf_discarded_delete_marks
    316. Innodb_ibuf_discarded_deletes
    317. Innodb_ibuf_discarded_inserts
    318. Innodb_ibuf_free_list
    319. Innodb_ibuf_merged_delete_marks
    320. Innodb_ibuf_merged_deletes
    321. Innodb_ibuf_merged_inserts
    322. Innodb_ibuf_merges
    323. Innodb_ibuf_segment_size
    324. Innodb_ibuf_size
    325. Innodb_log_waits
    326. Innodb_log_write_requests
    327. Innodb_log_writes
    328. Innodb_lsn_current
    329. Innodb_lsn_flushed
    330. Innodb_lsn_last_checkpoint
    331. Innodb_master_thread_1_second_loops
    332. Innodb_master_thread_10_second_loops
    333. Innodb_master_thread_background_loops
    334. Innodb_master_thread_main_flush_loops
    335. Innodb_master_thread_sleeps
    336. Innodb_max_trx_id
    337. Innodb_mem_adaptive_hash
    338. Innodb_mem_dictionary
    339. Innodb_mem_total
    340. Innodb_mutex_os_waits
    341. Innodb_mutex_spin_rounds
    342. Innodb_mutex_spin_waits
    343. Innodb_num_index_pages_written
    344. Innodb_num_non_index_pages_written
    345. Innodb_num_open_files
    346. Innodb_num_page_compressed_trim_op
    347. Innodb_num_page_compressed_trim_op_saved
    348. Innodb_num_pages_encrypted
    349. Innodb_num_pages_page_compressed
    350. Innodb_num_pages_page_compression_error
    351. Innodb_num_pages_page_decompressed
    352. Innodb_num_pages_page_decrypted
    353. Innodb_num_pages_page_encryption_error
    354. Innodb_oldest_view_low_limit_trx_id
    355. Innodb_onlineddl_pct_progress
    356. Innodb_onlineddl_rowlog_pct_used
    357. Innodb_onlineddl_rowlog_rows
    358. Innodb_os_log_fsyncs
    359. Innodb_os_log_pending_fsyncs
    360. Innodb_os_log_pending_writes
    361. Innodb_os_log_written
    362. Innodb_page_compression_saved
    363. Innodb_page_compression_trim_sect512
    364. Innodb_page_compression_trim_sect1024
    365. Innodb_page_compression_trim_sect2048
    366. Innodb_page_compression_trim_sect4096
    367. Innodb_page_compression_trim_sect8192
    368. Innodb_page_compression_trim_sect16384
    369. Innodb_page_compression_trim_sect32768
    370. Innodb_page_size
    371. Innodb_pages_created
    372. Innodb_pages_read
    373. Innodb_pages_written
    374. Innodb_purge_trx_id
    375. Innodb_purge_undo_no
    376. Innodb_row_lock_current_waits
    377. Innodb_row_lock_numbers
    378. Innodb_row_lock_time
    379. Innodb_row_lock_time_avg
    380. Innodb_row_lock_time_max
    381. Innodb_row_lock_time_waits
    382. Innodb_rows_deleted
    383. Innodb_rows_inserted
    384. Innodb_rows_read
    385. Innodb_rows_updated
    386. Innodb_s_lock_os_waits
    387. Innodb_s_lock_spin_rounds
    388. Innodb_s_lock_spin_waits
    389. Innodb_scrub_background_page_reorganizations
    390. Innodb_scrub_background_page_split_failures_missing_index
    391. Innodb_scrub_background_page_split_failures_out_of_filespace
    392. Innodb_scrub_background_page_split_failures_underflow
    393. Innodb_scrub_background_page_split_failures_unknown
    394. Innodb_scrub_background_page_splits
    395. Innodb_secondary_index_triggered_cluster_reads
    396. Innodb_secondary_index_triggered_cluster_reads_avoided
    397. Innodb_system_rows_deleted
    398. Innodb_system_rows_inserted
    399. Innodb_system_rows_read
    400. Innodb_system_rows_updated
    401. Innodb_truncated_status_writes
    402. Innodb_x_lock_os_waits
    403. Innodb_x_lock_spin_rounds
    404. Innodb_x_lock_spin_waits
    405. Key_blocks_not_flushed
    406. Key_blocks_unused
    407. Key_blocks_used
    408. Key_blocks_warm
    409. Key_read_requests
    410. Key_reads
    411. Key_write_requests
    412. Key_writes
    413. Last_query_cost
    414. Maria_*
    415. Master_gtid_wait_count
    416. Master_gtid_wait_time
    417. Master_gtid_wait_timeouts
    418. Max_statement_time_exceeded
    419. Max_used_connections
    420. Memory_used
    421. Mroonga_count_skip
    422. Mroonga_fast_order_limit
    423. Not_flushed_delayed_rows
    424. Open_files
    425. Open_streams
    426. Open_table_definitions
    427. Open_tables
    428. Opened_files
    429. Opened_table_definitions
    430. Opened_tables
    431. Opened_views
    432. Oqgraph_boost_version
    433. Performance_schema_accounts_lost
    434. Performance_schema_cond_classes_lost
    435. Performance_schema_cond_instances_lost
    436. Performance_schema_digest_lost
    437. Performance_schema_file_classes_lost
    438. Performance_schema_file_handles_lost
    439. Performance_schema_file_instances_lost
    440. Performance_schema_hosts_lost
    441. Performance_schema_locker_lost
    442. Performance_schema_mutex_classes_lost
    443. Performance_schema_mutex_instances_lost
    444. Performance_schema_rwlock_classes_lost
    445. Performance_schema_rwlock_instances_lost
    446. Performance_schema_socket_classes_lost
    447. Performance_schema_socket_instances_lost
    448. Performance_schema_stage_classes_lost
    449. Performance_schema_statement_classes_lost
    450. Performance_schema_table_handles_lost
    451. Performance_schema_table_instances_lost
    452. Performance_schema_thread_classes_lost
    453. Performance_schema_thread_instances_lost
    454. Performance_schema_users_lost
    455. Prepared_stmt_count
    456. Qcache_free_blocks
    457. Qcache_free_memory
    458. Qcache_hits
    459. Qcache_inserts
    460. Qcache_lowmem_prunes
    461. Qcache_not_cached
    462. Qcache_queries_in_cache
    463. Qcache_total_blocks
    464. Queries
    465. Questions
    466. Rows_read
    467. Rows_sent
    468. Rows_tmp_read
    469. Rpl_status
    470. Select_full_join
    471. Select_full_range_join
    472. Select_range
    473. Select_range_check
    474. Select_scan
    475. Server_audit_active
    476. Server_audit_current_log
    477. Server_audit_last_error
    478. Server_audit_writes_failed
    479. Slave_heartbeat_period
    480. Slave_open_temp_tables
    481. Slave_received_heartbeats
    482. Slave_retried_transactions
    483. Slave_running
    484. Slave_skipped_errors
    485. Slow_launch_threads
    486. Slow_queries
    487. Sort_merge_passes
    488. Sort_priority_queue_sorts
    489. Sort_range
    490. Sort_rows
    491. Sort_scan
    492. Sphinx_error
    493. Sphinx_time
    494. Sphinx_total
    495. Sphinx_total_found
    496. Sphinx_word_count
    497. Sphinx_words
    498. Ssl_accept_renegotiates
    499. Ssl_accepts
    500. Ssl_callback_cache_hits
    501. Ssl_cipher
    502. Ssl_cipher_list
    503. Ssl_client_connects
    504. Ssl_connect_renegotiates
    505. Ssl_ctx_verify_depth
    506. Ssl_ctx_verify_mode
    507. Ssl_default_timeout
    508. Ssl_finished_accepts
    509. Ssl_finished_connects
    510. Ssl_server_not_after
    511. Ssl_server_not_before
    512. Ssl_session_cache_hits
    513. Ssl_session_cache_misses
    514. Ssl_session_cache_mode
    515. Ssl_session_cache_overflows
    516. Ssl_session_cache_size
    517. Ssl_session_cache_timeouts
    518. Ssl_sessions_reused
    519. Ssl_used_session_cache_entries
    520. Ssl_verify_depth
    521. Ssl_verify_mode
    522. Ssl_version
    523. Subquery_cache_hit
    524. Subquery_cache_miss
    525. Syncs
    526. Table_locks_immediate
    527. Table_locks_waited
    528. Tc_log_max_pages_used
    529. Tc_log_page_size
    530. Tc_log_page_waits
    531. Threadpool_idle_threads
    532. Threadpool_threads
    533. Threads_cached
    534. Threads_connected
    535. Threads_created
    536. Threads_running
    537. Tokudb_basements_decompressed_for_write
    538. Tokudb_basements_decompressed_prefetch
    539. Tokudb_basements_decompressed_prelocked_range
    540. Tokudb_basements_decompressed_target_query
    541. Tokudb_basements_fetched_prefetch
    542. Tokudb_basements_fetched_for_write
    543. Tokudb_basements_fetched_for_write_bytes
    544. Tokudb_basements_fetched_for_write_seconds
    545. Tokudb_basements_fetched_prefetch_bytes
    546. Tokudb_basements_fetched_prefetch_seconds
    547. Tokudb_basements_fetched_prelocked_range
    548. Tokudb_basements_fetched_prelocked_range_bytes
    549. Tokudb_basements_fetched_prelocked_range_seconds
    550. Tokudb_basements_fetched_target_query
    551. Tokudb_basements_fetched_target_query_bytes
    552. Tokudb_basements_fetched_target_query_seconds
    553. Tokudb_broadcase_messages_injected_at_root
    554. Tokudb_buffers_decompressed_for_write
    555. Tokudb_buffers_decompressed_prefetch
    556. Tokudb_buffers_decompressed_prelocked_range
    557. Tokudb_buffers_decompressed_target_query
    558. Tokudb_buffers_fetched_for_write
    559. Tokudb_buffers_fetched_for_write_bytes
    560. Tokudb_buffers_fetched_for_write_seconds
    561. Tokudb_buffers_fetched_prefetch
    562. Tokudb_buffers_fetched_prefetch_bytes
    563. Tokudb_buffers_fetched_prefetch_seconds
    564. Tokudb_buffers_fetched_prelocked_range
    565. Tokudb_buffers_fetched_prelocked_range_bytes
    566. Tokudb_buffers_fetched_prelocked_range_seconds
    567. Tokudb_buffers_fetched_target_query
    568. Tokudb_buffers_fetched_target_query_bytes
    569. Tokudb_buffers_fetched_target_query_seconds
    570. Tokudb_cachetable_cleaner_executions
    571. Tokudb_cachetable_cleaner_iterations
    572. Tokudb_cachetable_cleaner_period
    573. Tokudb_cachetable_evictions
    574. Tokudb_cachetable_long_wait_pressure_count
    575. Tokudb_cachetable_long_wait_pressure_time
    576. Tokudb_cachetable_miss
    577. Tokudb_cachetable_miss_time
    578. Tokudb_cachetable_prefetches
    579. Tokudb_cachetable_size_cachepressure
    580. Tokudb_cachetable_size_current
    581. Tokudb_cachetable_size_leaf
    582. Tokudb_cachetable_size_limit
    583. Tokudb_cachetable_size_nonleaf
    584. Tokudb_cachetable_size_rollback
    585. Tokudb_cachetable_size_writing
    586. Tokudb_cachetable_wait_pressure_count
    587. Tokudb_cachetable_wait_pressure_time
    588. Tokudb_checkpoint_begin_time
    589. Tokudb_checkpoint_duration
    590. Tokudb_checkpoint_duration_last
    591. Tokudb_checkpoint_failed
    592. Tokudb_checkpoint_last_began
    593. Tokudb_checkpoint_last_complete_began
    594. Tokudb_checkpoint_last_complete_ended
    595. Tokudb_checkpoint_long_begin_count
    596. Tokudb_checkpoint_long_begin_time
    597. Tokudb_checkpoint_period
    598. Tokudb_checkpoint_taken
    599. Tokudb_db_closes
    600. Tokudb_db_open_current
    601. Tokudb_db_open_max
    602. Tokudb_db_opens
    603. Tokudb_descriptor_set
    604. Tokudb_dictionary_broadcast_updates
    605. Tokudb_dictionary_updates
    606. Tokudb_filesystem_fsync_num
    607. Tokudb_filesystem_fsync_time
    608. Tokudb_filesystem_long_fsync_num
    609. Tokudb_filesystem_long_fsync_time
    610. Tokudb_filesystem_threads_blocked_by_full_disk
    611. Tokudb_leaf_compression_to_memory_seconds
    612. Tokudb_leaf_decompression_to_memory_seconds
    613. Tokudb_leaf_deserialization_to_memory_seconds
    614. Tokudb_leaf_node_compression_ratio
    615. Tokudb_leaf_node_full_evictions
    616. Tokudb_leaf_node_full_evictions_bytes
    617. Tokudb_leaf_node_partial_evictions
    618. Tokudb_leaf_node_partial_evictions_bytes
    619. Tokudb_leaf_nodes_created
    620. Tokudb_leaf_nodes_destroyed
    621. Tokudb_leaf_nodes_flushed_to_disk_checkpoint
    622. Tokudb_leaf_nodes_flushed_to_disk_checkpoint_bytes
    623. Tokudb_leaf_nodes_flushed_to_disk_checkpoint_seconds
    624. Tokudb_leaf_nodes_flushed_to_disk_checkpoint_uncompressed_bytes
    625. Tokudb_leaf_nodes_flushed_to_disk_not_checkpoint
    626. Tokudb_leaf_nodes_flushed_to_disk_not_checkpoint_bytes
    627. Tokudb_leaf_nodes_flushed_to_disk_not_checkpoint_seconds
    628. Tokudb_leaf_nodes_flushed_to_disk_not_checkpoint_uncompressed_bytes
    629. Tokudb_leaf_serialization_to_memory_seconds
    630. Tokudb_loader_num_created
    631. Tokudb_loader_num_current
    632. Tokudb_loader_num_max
    633. Tokudb_locktree_escalation_num
    634. Tokudb_locktree_escalation_seconds
    635. Tokudb_locktree_latest_post_escalation_memory_size
    636. Tokudb_locktree_long_wait_count
    637. Tokudb_locktree_long_wait_escalation_count
    638. Tokudb_locktree_long_wait_escalation_time
    639. Tokudb_locktree_long_wait_time
    640. Tokudb_locktree_memory_size
    641. Tokudb_locktree_memory_size_limit
    642. Tokudb_locktree_open_current
    643. Tokudb_locktree_pending_lock_requests
    644. Tokudb_locktree_sto_eligible_num
    645. Tokudb_locktree_sto_ended_num
    646. Tokudb_locktree_sto_ended_seconds
    647. Tokudb_locktree_timeout_count
    648. Tokudb_locktree_wait_count
    649. Tokudb_locktree_wait_escalation_count
    650. Tokudb_locktree_wait_escalation_time
    651. Tokudb_locktree_wait_time
    652. Tokudb_logger_wait_long
    653. Tokudb_logger_writes
    654. Tokudb_logger_writes_bytes
    655. Tokudb_logger_writes_seconds
    656. Tokudb_logger_writes_uncompressed_bytes
    657. Tokudb_mem_estimated_maximum_memory_footprint
    658. Tokudb_messages_flushed_from_h1_to_leaves_bytes
    659. Tokudb_messages_ignored_by_leaf_due_to_msn
    660. Tokudb_messages_in_trees_estimate_bytes
    661. Tokudb_messages_injected_at_root
    662. Tokudb_messages_injected_at_root_bytes
    663. Tokudb_nonleaf_compression_to_memory_seconds
    664. Tokudb_nonleaf_decompression_to_memory_seconds
    665. Tokudb_nonleaf_deserialization_to_memory_seconds
    666. Tokudb_nonleaf_node_compression_ratio
    667. Tokudb_nonleaf_node_full_evictions
    668. Tokudb_nonleaf_node_full_evictions_bytes
    669. Tokudb_nonleaf_node_partial_evictions
    670. Tokudb_nonleaf_node_partial_evictions_bytes
    671. Tokudb_nonleaf_nodes_created
    672. Tokudb_nonleaf_nodes_destroyed
    673. Tokudb_nonleaf_nodes_flushed_checkpoint
    674. Tokudb_nonleaf_nodes_flushed_checkpoint_bytes
    675. Tokudb_nonleaf_nodes_flushed_checkpoint_seconds
    676. Tokudb_nonleaf_nodes_flushed_checkpoint_uncompressed_bytes
    677. Tokudb_nonleaf_nodes_flushed_not_checkpoint
    678. Tokudb_nonleaf_nodes_flushed_not_checkpoint_bytes
    679. Tokudb_nonleaf_nodes_flushed_not_checkpoint_seconds
    680. Tokudb_nonleaf_nodes_flushed_not_checkpoint_uncompressed_bytes
    681. Tokudb_nonleaf_serialization_to_memory_seconds
    682. Tokudb_overall_node_compression_ratio
    683. Tokudb_pivots_fetched_for_query
    684. Tokudb_pivots_fetched_for_query_bytes
    685. Tokudb_pivots_fetched_for_query_seconds
    686. Tokudb_pivots_fetched_for_prefetch
    687. Tokudb_pivots_fetched_for_prefetch_bytes
    688. Tokudb_pivots_fetched_for_prefetch_seconds
    689. Tokudb_pivots_fetched_for_write
    690. Tokudb_pivots_fetched_for_write_bytes
    691. Tokudb_pivots_fetched_for_write_seconds
    692. Tokudb_promotion_h1_roots_injected_into
    693. Tokudb_promotion_injections_at_depth_0
    694. Tokudb_promotion_injections_at_depth_1
    695. Tokudb_promotion_injections_at_depth_2
    696. Tokudb_promotion_injections_at_depth_3
    697. Tokudb_promotion_injections_lower_than_depth_3
    698. Tokudb_promotion_leaf_roots_injected_into
    699. Tokudb_promotion_roots_split
    700. Tokudb_promotion_stopped_after_locking_child
    701. Tokudb_promotion_stopped_at_height_1
    702. Tokudb_promotion_stopped_child_not_fully_in_memory
    703. Tokudb_promotion_stopped_child_locked_or_not_in_memory
    704. Tokudb_promotion_stopped_nonempty_buffer
    705. Tokudb_txn_aborts
    706. Tokudb_txn_begin
    707. Tokudb_txn_begin_read_only
    708. Tokudb_txn_commits
    709. Uptime
    710. Uptime_since_flush_status
    711. wsrep_apply_oooe
    712. wsrep_apply_oool
    713. wsrep_cert_deps_distance
    714. wsrep_cluster_conf_id
    715. wsrep_cluster_size
    716. wsrep_cluster_state_uuid
    717. wsrep_cluster_status
    718. wsrep_connected
    719. wsrep_flow_control_paused
    720. wsrep_flow_control_recv
    721. wsrep_flow_control_sent
    722. wsrep_last_committed
    723. wsrep_local_bf_aborts
    724. wsrep_local_cert_failures
    725. wsrep_local_commits
    726. wsrep_local_index
    727. wsrep_local_recv_queue
    728. wsrep_local_recv_queue_avg
    729. wsrep_local_replays
    730. wsrep_local_send_queue
    731. wsrep_local_send_queue_avg
    732. wsrep_local_state_uuid
    733. wsrep_protocol_version
    734. wsrep_provider_name
    735. wsrep_provider_vendor
    736. wsrep_provider_version
    737. wsrep_ready
    738. wsrep_received
    739. wsrep_received_bytes
    740. wsrep_replicated
    741. wsrep_replicated_bytes
    742. 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 mysqladmin 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.
  • 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.
  • Scope: Global
  • Data Type: numeric

Access_denied_errors

  • Description: Number of access denied errors.
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 5.2

Acl_column_grants


Acl_database_grants

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

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
  • Introduced: MariaDB 10.1.4

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
  • Introduced: MariaDB 10.1.4

Acl_proxy_users


Acl_role_grants


Acl_roles


Acl_table_grants


Acl_users


Busy_time

  • Description: Cumulative time in seconds of activity on connections.
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 5.3

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_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.
  • 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_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 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
  • Introduced: MariaDB 10.1.1

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_procedure

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

Com_create_role


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_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_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
  • Introduced: MariaDB 10.0.5

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_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 mysql --comments -e '-- sql comment'
  • 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


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
  • Introduced: MariaDB 10.0.5

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_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
  • Introduced: MariaDB 5.5

Com_restore_table

  • Description:
  • 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
  • Introduced: MariaDB 10.0.5

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.
  • 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
  • Introduced: MariaDB 5.5

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_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_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


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_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

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

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

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

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.
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 10.0.4 / MySQL 5.6.5

Connection_errors_internal

  • Description: Number of refused connections due to internal server errors, for example out of memory errors, or failed thread starts.
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 10.0.4 / MySQL 5.6.5

Connection_errors_max_connections

  • Description: Number of refused connections due to the max_connections limit being reached.
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 10.0.4 / MySQL 5.6.5

Connection_errors_peer_address

  • Description: Number of errors while searching for the connecting client IP address.
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 10.0.4 / MySQL 5.6.5

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.
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 10.0.4 / MySQL 5.6.5

Connection_errors_tcpwrap

  • Description: Number of connections the libwrap library refused.
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 10.0.4 / MySQL 5.6.5

Connections

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

Cpu_time

  • Description: Total CPU time used.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 5.3

Created_tmp_disk_tables

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

Created_tmp_files

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

Created_tmp_tables

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

Delayed_errors

  • Description: Number of errors which occurred while doing INSERT DELAYED.
  • 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..
  • 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
  • Introduced: MariaDB 5.2

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
  • Introduced: MariaDB 5.5.28

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
  • Introduced: MariaDB 5.5.28

Feature_delay_key_write


Feature_dynamic_columns


Feature_fulltext


Feature_gis

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

Feature_locale

  • Description: Number of times the @@lc_messages variable was assigned into.
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 5.5

Feature_subquery

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

Feature_timezone

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

Feature_trigger

  • Description: Number of triggers loaded.
  • Scope: Global
  • Data Type: numeric
  • Introduced: MariaDB 5.5

Feature_xml


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

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
  • Introduced: MariaDB 10.0.0

Handler_icp_attempts


Handler_icp_match


Handler_mrr_init


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
  • Introduced: MariaDB 5.3

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
  • Introduced: MariaDB 5.3

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
  • Introduced: MariaDB 5.5

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_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
  • Introduced: MariaDB 5.3

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_update

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

Handler_tmp_write

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

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
  • Introduced: MariaDB 5.1

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_statement_time_exceeded


Max_used_connections

  • Description: Max number of connections ever open at the same time.
  • Scope: Session
  • Data Type: numeric

Memory_used

  • Description: Global or per-connection memory usage.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 10.0.1

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_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
  • Introduced: MariaDB 5.5

Oqgraph_boost_version


Performance_schema_accounts_lost

  • Description: Number of times a row could not be added to the performance schema accounts table due to it being full.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 10.0.0

Performance_schema_cond_classes_lost

  • Description: Number of condition instruments that could not be loaded.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 5.5

Performance_schema_cond_instances_lost

  • Description: Number of instances a condition object could not be created.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 5.5

Performance_schema_digest_lost

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

Performance_schema_file_classes_lost

  • Description: Number of file instruments that could not be loaded.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 5.5

Performance_schema_file_handles_lost

  • Description: Number of instances a file object could not be opened.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 5.5

Performance_schema_file_instances_lost

  • Description: Number of instances a file object could not be created.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 5.5

Performance_schema_hosts_lost

  • Description: Number of times a row could not be added to the performance schema hosts table due to it being full.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 10.0.0

Performance_schema_locker_lost

  • Description: Number of events not recorded, due to either being recursive, or having a deeper nested events stack than the implementation limit.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 5.5

Performance_schema_mutex_classes_lost

  • Description: Number of mutual exclusion instruments that could not be loaded.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 5.5

Performance_schema_mutex_instances_lost

  • Description: Number of instances a mutual exclusion object could not be created.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 5.5

Performance_schema_rwlock_classes_lost

  • Description: Number of read/write lock instruments that could not be loaded.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 5.5

Performance_schema_rwlock_instances_lost

  • Description: Number of instances a read/write lock object could not be created.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 5.5

Performance_schema_socket_classes_lost

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

Performance_schema_socket_instances_lost

  • Description: Number of instances a socket object could not be created.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 10.0.0

Performance_schema_stage_classes_lost

  • Description: Number of stage event instruments that could not be loaded.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 10.0.0

Performance_schema_statement_classes_lost

  • Description: Number of statement instruments that could not be loaded.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 10.0.0

Performance_schema_table_handles_lost

  • Description: Number of instances a table object could not be opened.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 5.5

Performance_schema_table_instances_lost

  • Description: Number of instances a table object could not be created.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 5.5

Performance_schema_thread_classes_lost

  • Description: Number of thread instruments that could not be loaded.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 5.5

Performance_schema_thread_instances_lost

  • Description: Number of instances thread object could not be created.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 5.5

Performance_schema_users_lost

  • Description: Number of times a row could not be added to the performance schema users table due to it being full.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 5.5

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.
  • Scope: Global
  • Data Type: numeric

Qcache_inserts

  • Description: Number of queries ever cached in the query cache.
  • 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.
  • Scope: Global
  • Data Type: numeric

Qcache_not_cached

  • Description: Number of queries that are uncacheable by the query cache, or use SQL_NO_CACHE.
  • 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

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

Rows_read

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

Rows_sent

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

Rows_tmp_read

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

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


Subquery_cache_miss


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
  • Introduced: MariaDB 5.1

Table_locks_immediate

  • Description: Number of table locks which were completed immediately.
  • Scope: Global
  • Data Type: numeric

Table_locks_waited

  • Description: Number of table locks which had to wait. Indicates table lock contention.
  • Scope: Global
  • Data Type: numeric

Tc_log_max_pages_used

  • Description: Max number of pages used by the transaction coordinator recovery log.
  • Scope: Global
  • Data Type: numeric

Tc_log_page_size

  • Description: Page size of the transaction coordinator recovery log.
  • Scope: Global
  • Data Type: numeric

Tc_log_page_waits

  • Description: Number of times a two-phase commit was forced to wait for a free transaction coordinator recovery log page.
  • Scope: Global
  • Data Type: numeric

Threadpool_idle_threads

  • Description: Number of inactive threads in the thread pool. Only meaningful on Unixes, not tracked on Windows. Threads become idle either by waiting for new work, or if it's blocked due to disk io, row or table lock etc.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 5.5

Threadpool_threads

  • Description: Number of threads in the thread pool.
  • Scope: Global, Session
  • Data Type: numeric
  • Introduced: MariaDB 5.5

Threads_cached

  • Description: Number of threads cached in the thread cache. Will be zero if the thread pool is in use (see Thread pool in MariaDB 5.5).
  • Scope: Global
  • Data Type: numeric

Threads_connected

  • Description: Number of open connections.
  • 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 threads that are actively running, not sleeping.
  • 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.