Common commands used for monitoring during MySQL database maintenance _ MySQL

Common commands used for monitoring during MySQL database maintenance: bitsCN.com

Status = show status like '%' [example: show status like 'com _ Select']
Variables = show variables like '%' [example: show variables like 'query _ cache_size ']

1. MySQL Query count (status)
Com_select; Com_update; Com_insert; Com_delete; Com_change_db

2. query cache space size: query_cache_size (variables)
Maximum query data set size in the cache: query_cache_limit (variables );
Number of queries in the cache: Qcache_inserts (status );
Query cache hit rate: (Qcache_hits/(Qcache_hits + Qcache_inserts) * 100% (status)

3. index cache hit rate
Index cache space size: key_buffer_size (variables)
Index cache hit rate: (Key_reads/Key_read_requests) * 100% (status)

4. concurrent connections
Maximum number of connections: max_connections (variables)
Actual maximum number of connections: max_used_connections (status)
Current connections: Threads_connected (status)
Active Connections: Threads_running (status)
Cache connections: Threads_cache (status)

5. traffic statistics (status)
Bytes_received, Bytes_sent (status)

6. number of connections
Connections per second: Connections (status)
Actual number of connections created per second: Threads_created (status)

7. table lock statistics
Number of table locks released immediately: Table_locks_immediate (status)
Number of table locks to wait: Table_locks_waited (status)

BitsCN.com