Threads The number of active threads (clients). Questions The number of questions (queries) from clients since the server was started.
Threads The number of active threads (clients). Questions The number of questions (queries) from clients since the server was started.
Threads活跃线程(客户)的数量 越小越好
从mysqld启动起来自客户问题的数量 越少越好
slow queries 最好为0
等等
mysql Ver 12.22 Distrib 4.0.24, for Win32 (ia32)Connection id: 126727771
Current database:
Current user: [email protected]
SSL: Not in use
Server version: 4.0.17-nt
Protocol version: 10
Connection: xxx.xxx.xxx.xxx via TCP/IP
Client characterset: latin1
Server characterset: gbk
TCP port: 3306
Uptime: 19 days 18 hours 8 min 42 secThreads: 10 Questions: 622343100 Slow queries: 6 Opens: 29265 Flush tables:
1 Open tables: 29 Queries per second avg: 364.600
--------------
可是select却找不到相关记录,后来我删除了10000多条记录就OK了