Close

2023-09-22

Key Variables Of SHOW STATUS for MySQL

Key Variables Of SHOW STATUS for MySQL

The SHOW STATUS command in MySQL provides information about system status variables. These variables present a snapshot of the server’s operations and performance at any moment.

Due to the extensive number of status variables, discussing each one would be exhaustive. I’ll provide an overview of some key variables and their significance. You can always consult the official MySQL documentation for a comprehensive list.

Variable NameDescription
Aborted_clientsThe number of connections were aborted because the client died without properly closing the connection.
Aborted_connectsNumber of failed connection attempts to the server.
Bytes_receivedNumber of bytes received from all clients.
Bytes_sentNumber of bytes sent to all clients.
ConnectionsTotal number of connection attempts (successful or not) to the MySQL server since startup.
Created_tmp_disk_tablesNumber of temporary tables on disk created automatically by the server during queries.
Created_tmp_filesNumber of temporary files MySQL has created.
Created_tmp_tablesNumber of in-memory temporary tables created automatically by the server during queries.
Delayed_insert_threadsNumber of delayed insert handler threads in use.
Flush_commandsNumber of executed FLUSH commands.
Handler_read_firstNumber of times the first entry in an index was read.
Key_blocks_usedNumber of used blocks from the key cache.
Max_used_connectionsMaximum number of connections that have been in use simultaneously since the server started.
Open_filesNumber of open files.
Open_tablesNumber of connections were aborted because the client died without properly closing the connection.
Opened_tablesNumber of tables that have been opened.
QueriesNumber of statements executed by the server.
Threads_connectedNumber of currently open connections.
Threads_createdThe number of threads created to handle connections.
UptimeHow long (in seconds) has the server been up and running.

This list is by no means exhaustive. Depending on the specific MySQL version and configuration, you might also encounter other variables. Monitoring and understanding these variables is crucial for diagnosing issues, optimizing performance, and ensuring the healthy operation of a MySQL server.