MYSQL入门学习之十八：MYSQLADMIN命令参数详解(五)
abase will be destroyed.
Do you really want to drop the 'test_admin' database [y/N] y
Database "test_admin" dropped
C:\Users\qxl>mysqladmin -u root flush-status
C:\Users\qxl>mysqladmin -u root processlist
+----+------+----------------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+----------------+----+---------+------+-------+------------------+
| 21 | root | localhost:8925 | | Query | 0 | | show processlist |
+----+------+----------------+----+---------+------+-------+------------------+
C:\Users\qxl>mysqladmin -u root status
Uptime: 1947 Threads: 1 Questions: 32 Slow queries: 0 Opens: 18 Flush tables: 2 Open tables: 2 Queries per second
avg: 0.16
其中mysqladmin -u root status输出信息中各项的详细说明如下：
Uptime：MySQL服务器已经运行的秒数
Threads：活跃线程（客户）的数量
Questions：从mysqld启动起来自客户查询的数量
Slow queries：已经超过long_query_time秒的查询数量
Opens：mysqld已经打开了多少表
Flush tables：flush ..., refresh和reload命令数量
Open tables：现在被打开的表数量
Queries per second avg：查询平均用时