MySQL Performance command:
List the current connections for all users:
> Show processlist; (only the first 100 lines are shown)
> Show full processlist; (Show all connections)
View all MySQL information:
> Show status;
To view the number of processor threads that are using deferred inserts:
> Show status like '%delayed_insert_threads% ';
Maximum number of connections used at the same time:
> Show status like '%max_used_connections% ';
Number of open tables:
> Show status like '%open_tables% ';
Number of rows waiting to be written in the queue:
> Show status like '%not_flushed_delayed_rows% ';
Number of tables already open:
> Show status like '%opened_tables% ';
Number of queries sent to server:
> Show status like '%questions% '
Number of queries over Long_query_time time:
> Show status like '%slow_queries% ';
Number of connections currently open:
> Show status like '%threads_connected% ';
Number of threads not sleeping:
> Show status like '%threads_running% ';
How many seconds the server has worked:
> Show status like '%uptime% ';
View table-level lock contention (the larger the number indicates the more severe the table-level lock contention):
> Show status like '%table_locks_waited% ';
Number currently waiting to be locked:
> Show status like '%innodb_row_lock_current_waits% ';
This article is from the "Linux" blog, so be sure to keep this source http://yangzhiming.blog.51cto.com/4849999/1931812
MySQL Show Status View Info command