show status 也可以,但不方便。Threads_connected The number of currently open connections. Threads_created The number of threads created to handle connections.Threads_running The number of threads that are not sleeping. Max_used_connections The maximum number of connections that have been in use simultaneously since the server started.Connections The number of connection attempts (successful or not) to the MySQL server. 其中Threads_running 你可以知道当前运行的线程。不过不如show processlist来得方便。并且还可以知道在正执行什么SQL语句。
Threads_connected The number of currently open connections. Threads_created The number of threads created to handle connections. Threads_running The number of threads that are not sleeping. Max_used_connections The maximum number of connections that have been in use simultaneously since the server started. Connections The number of connection attempts (successful or not) to the MySQL server. 能不能翻译一下,说详细一下,马上我就结贴了给你分了
Threads_connected The number of currently open connections. 当前打开的连接数。Threads_created The number of threads created to handle connections. 曾经打开过的最大线程数(连接数)Threads_running The number of threads that are not sleeping. 当前运行的Max_used_connections The maximum number of connections that have been in use simultaneously since the server started. 曾经最大的连接数Connections The number of connection attempts (successful or not) to the MySQL server. 到目前为止一共的连接数累计。
| Threads_created | 808652 |
| Threads_running | 1 |
| Max_used_connections | 336 |
| Connections | 902350 |
这些数据,分别表示的是什么,在show status 里没有显示当前操作的并发访问量的数据吗,
The number of currently open connections. Threads_created
The number of threads created to handle connections.Threads_running
The number of threads that are not sleeping. Max_used_connections
The maximum number of connections that have been in use simultaneously since the server started.Connections
The number of connection attempts (successful or not) to the MySQL server.
其中Threads_running 你可以知道当前运行的线程。不过不如show processlist来得方便。并且还可以知道在正执行什么SQL语句。
The number of currently open connections. Threads_created
The number of threads created to handle connections. Threads_running
The number of threads that are not sleeping. Max_used_connections
The maximum number of connections that have been in use simultaneously since the server started. Connections
The number of connection attempts (successful or not) to the MySQL server. 能不能翻译一下,说详细一下,马上我就结贴了给你分了
The number of currently open connections.
当前打开的连接数。Threads_created
The number of threads created to handle connections.
曾经打开过的最大线程数(连接数)Threads_running
The number of threads that are not sleeping.
当前运行的Max_used_connections
The maximum number of connections that have been in use simultaneously since the server started.
曾经最大的连接数Connections
The number of connection attempts (successful or not) to the MySQL server.
到目前为止一共的连接数累计。