How to view the status information for MySQL

Mysql> \s or status can query the MySQL status profile

--------------

MySQL Ver 14.14 distrib 5.1.69, for Redhat-linux-gnu (x86_64) using ReadLine 5.1

Connection id:28035 #连接ID

Current database: #当前数据库

Current User:root@localhost #当前登录用户

Ssl:not in use #不使用ssl连接

Current pager:stdout #当前页: standard output

Using outfile: ' #使用输出文件

Using delimiter:; #使用分隔符

Server version:5.1.69 Source Distribution #服务器版本: 5.1.69 sources distribution

Protocol version:10 #协议版本: 10

Connection:localhost via UNIX socket #当前连接主机的unix套接字

Server characterset:latin1 #服务器字符集

Db characterset:latin1 #数据库字符集

Client characterset:latin1 #客户端字符集

Conn. Characterset:latin1 #链接使用的字符集类型

UNIX Socket:/var/lib/mysql/mysql.sock #unix套接字路径存放位置

Uptime:42 hours min sec #运行时间: 42 days 22 hours 21 minutes 11 seconds

Threads:1 questions:4564414 Slow queries:0 opens:26397 Flush tables:1 Open tables:64 queries per second avg:1 .230

#Threads代表线程数.

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/MySQL/

#Questions代表已经发送给服务器的查询的个数.

#Slow queries represents the number of queries that exceed Long_query_time (log query time) seconds for query times.

#Opens代表打开的总量, including the number of files, the number of streams (mainly for records), the number of cached. frm files, and the total number of tables currently open.

#Flush tables on behalf of Refresh table

#Open tables on behalf of the table open

#Queries per second avg: the number of queries for each second

This article is from the "Imysql" blog, please be sure to keep this source http://jiechao2012.blog.51cto.com/3251753/1254344