How does one view the MySql status? How does one view the number of connections and status?

How does one view the MySql status? How does one view the number of connections and status? If it is a root account, you can see the current connection of all users. For other common accounts, only the connections occupied by the account can be viewed.

How can I access the mysql command line? There is a bin directory under the mysql installation directory. use the command line to enter the directory, and then use mysql-uroot-p123456 to log on (note: the user name and password do not include "")

Command: show processlist;

If it is a root account, you can see the current connection of all users. For other common accounts, you can only view the connections you are using.

Show processlist; only the first 100 items are listed. if you want to list them all, use show full processlist;

Mysql> show processlist;

Command: show status;

Command: show status like '% variable % ';

Aborted_clients indicates the number of dropped connections because the client fails to properly close the connection.

The number of connection times of the MySQL server that failed the Aborted_connects attempt.

The number of times that Connections attempted to connect to the MySQL server.

Created_tmp_tables: Number of implicit temporary tables created when the statement is executed.

The number of threads that Delayed_insert_threads is using to insert a delayed processor.

The number of rows written by Delayed_writes using insert delayed.

The number of rows in which Delayed_errors writes data using insert delayed (which may duplicate key values.

The number of times Flush_commands executes the FLUSH command.

The number of rows that Handler_delete requests to delete from a table.

The number of times the Handler_read_first request reads the first row of the table.

The Handler_read_key request number is based on the key-read row.

The number of times the Handler_read_next request reads a row based on a key.

The number of times the Handler_read_rnd request reads a row based on a fixed position.

The number of times Handler_update requests to update a row in the table.

The number of times a Handler_write request inserts a row into a table.

The number of Key_blocks_used blocks used for keyword cache.

The number of times Key_read_requests requests read a key value from the cache.

The number of times that Key_reads reads a key value from the disk physically.

Number of times that Key_write_requests requests write a key block to the cache.

The number of times that Key_writes physically writes a key-value block to a disk.

The maximum number of connections simultaneously used by Max_used_connections.

Not_flushed_key_blocks has been changed in the key cache but has not been cleared to the disk.

The number of rows that Not_flushed_delayed_rows is waiting to write in the insert delay queue.

The number of open tables in Open_tables. (Www.jbxue.com)

The number of open files in Open_files.

Number of open streams in Open_streams (mainly used for log recording)

The number of open tables in Opened_tables.

The number of queries sent by Questions to the server.

Slow_queries takes more than long_query_time.

The number of connections currently opened by Threads_connected.

The number of threads whose Threads_running is not sleeping.

How many seconds does the Uptime server work.