MySQL
SHOW GLOBAL STATUS LIKE 'Aborted_connects'
Query returns the number of failed attempts to connect to the MySQL server.
SHOW GLOBAL STATUS LIKE 'Aborted_clients'
The number of connections that were aborted because the client died without closing the connection properly
SHOW GLOBAL STATUS LIKE 'Aborted_connects'
The number of failed attempts to connect to the MySQL server.
SHOW GLOBAL STATUS LIKE 'Bytes_received'
Query returns the number of bytes received from all clients.
SHOW GLOBAL STATUS LIKE 'Bytes_sent'
The number of bytes sent to all clients.
SHOW GLOBAL STATUS LIKE 'Connections'
The number of connection attempts (successful or not) to the MySQL server.
SHOW GLOBAL STATUS LIKE 'Created_tmp_files'
How many temporary files mysqld has created.
SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool_pages_data'
The number of pages containing data (dirty or clean).
SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool_pages_dirty'
The number of pages currently dirty.
SHOW GLOBAL STATUS LIKE 'Innodb_data_pending_writes'
The current number of pending writes.
SHOW GLOBAL STATUS LIKE 'Innodb_row_lock_time_avg'
The average time to acquire a row lock, in milliseconds.
SHOW GLOBAL STATUS LIKE 'Innodb_row_lock_time_max'
The maximum time to acquire a row lock, in milliseconds.
SHOW GLOBAL STATUS LIKE 'Max_used_connections'
The maximum number of connections that have been in use simultaneously since the server started.
SHOW GLOBAL STATUS LIKE 'Open_files'
The number of files that are open. This count includes regular files opened by the server. It does not include other types of files such as sockets or pipes. Also, the count does not include files that storage engines open using their own internal functions rather than asking the server level to do so.
SHOW GLOBAL STATUS LIKE 'Open_tables'
The number of tables that are open.
SHOW GLOBAL STATUS LIKE 'Qcache_free_memory'
The amount of free memory for the query cache.
SHOW GLOBAL STATUS LIKE 'Slow_queries'
The number of queries that have taken more than long_query_time seconds.
SHOW GLOBAL STATUS LIKE 'Table_locks_waited'
The number of times that a request for a table lock could not be granted immediately and a wait was needed. If this is high and you have performance problems, you should first optimize your queries, and then either split your table or tables or use replication.
SHOW GLOBAL STATUS LIKE 'Threads_connected'
The number of currently open connections.
SHOW GLOBAL STATUS LIKE 'Threads_created'
The number of threads created to handle connections. If Threads_created is big, you may want to increase the thread_cache_size value. The cache miss rate can be calculated as Threads_created/Connections.
SHOW GLOBAL STATUS LIKE 'Threads_running'
The number of threads that are not sleeping.