Home > Database > Mysql Tutorial > mysql 连接数好几千 大神指教

mysql 连接数好几千 大神指教

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-06 09:34:22
Original
1016 people have browsed it

mysql

请教个问题
我原来 mysql的服务器 是64G内存

平时 看连接数的话 基本保持几百个左右。

现在改成了8G内存。

为什么连接数是几千

但是 都是sleep的

如果是处理不过来 应该是很多并发处理的线程啊 但是都是sleep的 应该就是处理的过来

那为啥这么多connection

还都是sleep

show PROCESSLIST

我连mysql的 是十几个tomcat,用的spring

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
MySQL stops process
From 1970-01-01 08:00:00
0
0
0
Error when installing mysql on linux
From 1970-01-01 08:00:00
0
0
0
phpstudy cannot start mysql?
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template