Mysql Health Query Method introduction _mysql

Show STATUS
Login directly under the command line MySQL run show STATUS; query statements, detailed below

The same statement and show Variables;,show status is to look at the MySQL operation, and the above kind of information through the PMA look at the basic similarity.

Show VARIABLES
Show VARIABLES is looking at MySQL's configuration parameters, and you can also use a VARIABLES like ' key% '

Show Processlist
Show Processlist is a review of ongoing processes and is useful for troubleshooting situations such as locking tables. Under normal circumstances, open MySQL slow query record is also conducive to troubleshooting.

Show OPEN TABLES
Show open tables displays a list of the tables that are currently open.

Mysqladmin status
Use the Mysqladmin tool with MySQL to view status, using the following command
Mysqladmin-uroot--password= ' password ' status
The results shown are as follows:
uptime:87117 threads:1 questions:5481626 Slow queries:16 opens:2211 Flush tables:1 Open tables:512 queries per Seco nd avg:62.923
You can also add the-I 5 parameter to automatically refresh every five seconds.
Mysqladmin-uroot--password= ' Password ' status-i 5

Mysqladmin Extended-status
You can also use the Mysqladmin-uroot--password= ' password ' extended-status to see more MySQL running information, which is basically the same as the first view of the information.