Parsing of mysql performance commands

This article mainly introduces mysql performance command parsing, hoping to supplement and update some knowledge, if you have other questions you need to know, you can continue to follow my updated article in the industry information.

Mysql performance commands:

List the current connections for all users:

> show processlist; (only the first 100 lines are displayed)

Show full processlist; (show all connections)

View all mysql information:

> show status

Check the number of processor threads that are being inserted with latency:

> 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 queue:

> show status like'% not_flushed_delayed_rows%'

Number of tables that have been opened:

> show status like'% opened_tables%'

Number of queries sent to CVM:

> show status like'% questions%'

Number of queries that exceeded long_query_time time:

> show status like'% slow_queries%'

Number of connections currently open:

> show status like'% threads_connected%'

Number of threads that are not sleeping:

> show status like'% threads_running%'

How many seconds did the server work:

> show status like'% uptime%'

Check the table-level lock contention (the higher the value, the more serious the table-level lock contention):

> show status like'% table_locks_waited%'

Number of locks currently waiting:

> show status like'% innodb_row_lock_current_waits%'

Read the above about mysql performance command parsing, I hope it can bring some help to everyone in practical application. Due to the limited space in this article, it is inevitable that there will be deficiencies and need to be supplemented. If you need more professional answers, you can contact us on the official website for 24-hour pre-sales and after-sales to help you answer questions at any time.