MySQL running condition query method _ MySQL

How to query MySQL running STATUS: bitsCN. comSHOW STATUS
Log on to MySQL directly under the command line to run the show status command. the query statement is as follows:

The same statement also has show variables; and show status is used to view the MySQL running STATUS, which is similar to the above information viewed through pma.

SHOW VARIABLES
Show variables is used to view the configuration parameters of MySQL. you can also use show variables like 'key %'

SHOW PROCESSLIST
Show processlist is a process that is currently in progress. it is useful for troubleshooting situations such as locked tables. In general, enabling MySQL slow query records is also helpful for troubleshooting.

SHOW OPEN TABLES
Show open tables displays the list of opened TABLES.

Mysqladmin status
Run the following command to view the status using the mysqladmin tool that comes with MySQL:
Mysqladmin-uroot -- password = 'password' status
The result is as follows:
Uptime: 87117 Threads: 1 Questions: 5481626 Slow queries: 16 Opens: 2211 Flush tables: 1 Open tables: 512 Queries per second avg: 62.923
You can also add the-I 5 parameter to automatically refresh it every five seconds.
Mysqladmin-uroot -- password = 'password' status-I 5

Mysqladmin extended-status
Similarly, you can use mysqladmin-uroot -- password = 'password' extended-status to view more MySQL running information. this method is basically the same as that of the first method. BitsCN.com