View connections and status in Mysql

Mysql displays the number of connections and the status show processlist. If it is a root account, you can view the current connection of all users. If it is another common account, only the show processlist connections occupied by you can be seen. Only the first 100 connections can be listed; if you want to list all of them, use show full processlist show status [html] show status like '% variable %' Aborted_clients. The connection is dead because the client does not properly close the connection, the number of dropped Connections Aborted_connects attempts to connect to the MYSQL server the number of times Connections tries to connect to the MYSQL server Flush_commands executes the FLUSH command the maximum number of Connections currently opened by Max_used_connections simultaneously Threads_connected number of connections Threads_running threads not sleeping Uptime server working time