MySQL Show Status View Info command

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