[Ilugc] Too many connection in MYSQL
- From: technocraze@xxxxxxxxx (senthilraja P)
- Date: Thu Sep 3 00:07:37 2009
On Thu, Aug 27, 2009 at 6:11 PM, Ramkumar <ramkumarcrk@xxxxxxxxx> wrote:
Dear Friends,
I changed max_connection value into 500.Then when i login
through MYSQL Administrator and try to see threads.That shows number of
sleeping threads.How can i rectify this sleeping threads.Then these threads
will affect MYSQL DataBase's performance?.Thanks in advance again...
We faced this issue for long time.. atlast found out that this occurs when
the number of connections configured in Apache is more than the number of
mysql connections..
So, check the apache configuration, and also Mysql configuration, and make
sure, that the number of mysql connections is more than the number of
max_connection in apache.
This should definitely solve the problem..
Regards,
Senthil
Other related posts:
