Mysql processlist Command

Mysql processlist Command

Mysqladmin-uroot-proot processlist

MySQL view current number of connections

Command: Show Processlist;
If it is the root account, you can see the current connection for all users. If you are a normal account, you can only see the connection you are occupying.
Show Processlist; only the first 100 are listed, please use show full processlist if you want to list them all.
Mysql> show Processlist;

Command: Show status;

aborted_clients The number of connections that have been discarded because the client did not properly close the connection already dead.
aborted_connects the number of times the connection to the MySQL server has failed.
Connections The number of attempts to connect to the MySQL server.
Created_tmp_tables The number of suppressed temporary tables that have been created when the statement is executed.
delayed_insert_threads The number of deferred plug-in processor threads being used.
delayed_writes The number of rows written with the insert Delayed.
delayed_errors The number of rows written with insert Delayed for some errors (possibly repeating key values).
flush_commands the number of times the Flush command was executed.
handler_delete the number of times a row was requested to be deleted from a table.
the number of times the Handler_read_first request reads the first row in the table.
The Handler_read_key requests a number based on the key read line.
the number of times a handler_read_next request reads into a row based on one key.
the number of times a HANDLER_READ_RND request reads into a row based on a fixed position.
handler_update the number of times a row in the table was requested to be updated.
the number of times the Handler_write request inserts a row into the table.
key_blocks_used The number of blocks used for the keyword cache.
key_read_requests the number of times a key value was requested to be read from the cache.
key_reads the number of times a key value has been physically read from disk.
key_write_requests requests a keyword block to be written to the cache count.
key_writes the number of times a key-value block is physically written to disk.
Max_used_connections The maximum number of connections that are used at the same time.
Not_flushed_key_blocks a key block that has been changed in the key cache but has not been emptied to disk.
not_flushed_delayed_rows The number of rows waiting to be written in the Insert delay queue.
open_tables The number of open tables.
open_files The number of open files.
open_streams Number of open streams (primarily for log records)
opened_tables The number of tables that have been opened.
Questions The number of queries destined for the server.
slow_queries The number of queries that will take more than long_query_time time.
threads_connected The number of connections currently open.
threads_running The number of threads that are not sleeping.
Uptime How many seconds the server has worked.

Mysql processlist Command