PmaControl logo PmaControl
Resources › MySQL optimization center › MySQL Status Variables

MySQL Status Variables

Structured Markdown documentation to diagnose, measure, and optimize MySQL.

This page is original PmaControl documentation. It keeps a practical index structure for MySQL optimization work, without copying third-party content or depending on an external product.

Role

Status variables are runtime counters. They show real activity: connections, queries, errors, cache, I/O, temporary tables, and locks.

Delta Reading

SHOW GLOBAL STATUS;

Cumulative counters must be compared between two timestamps. An absolute value since startup is rarely enough.

Variables to Track

  • Questions, Com_select, Com_insert, Com_update, Com_delete.
  • Threads_connected, Threads_running, Max_used_connections.
  • Created_tmp_disk_tables, Sort_merge_passes, Handler_read_rnd_next.
  • Innodb_buffer_pool_reads, Innodb_log_waits, Innodb_row_lock_time.