56,687
社区成员
发帖
与我相关
我的任务
分享如果查看mysql的并发访问量是多少
我的是mysql 4 windows2003
用什么方法知道，在同一时刻，我的mysql同时并发多少的操作量
用什么方法知道，在同一时刻，我的mysql同时并发多少的操作量
...全文
请发表友善的回复…
发表回复
ACMAIN_CHM 2009-05-18
- 打赏
- 举报
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.
到目前为止一共的连接数累计。
my19830419 2009-05-18
- 打赏
- 举报
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. 能不能翻译一下，说详细一下，马上我就结贴了给你分了
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. 能不能翻译一下，说详细一下，马上我就结贴了给你分了
梦无痕123 2009-05-17
- 打赏
- 举报
SHOW PROCESSLIST
ACMAIN_CHM 2009-05-16
- 打赏
- 举报
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语句。
my19830419 2009-05-16
- 打赏
- 举报
SHOW PROCESSLIST 里面就是自己当前有多少个并发操作数据库的量吗
show status;
| Threads_connected | 51 |
| Threads_created | 808652 |
| Threads_running | 1 |
| Max_used_connections | 336 |
| Connections | 902350 |
这些数据，分别表示的是什么，在show status 里没有显示当前操作的并发访问量的数据吗，
show status;
| Threads_connected | 51 |
| Threads_created | 808652 |
| Threads_running | 1 |
| Max_used_connections | 336 |
| Connections | 902350 |
这些数据，分别表示的是什么，在show status 里没有显示当前操作的并发访问量的数据吗，
ACMAIN_CHM 2009-05-16
- 打赏
- 举报
SHOW PROCESSLIST
