Apache Friends Support Forum

Hi All,

I find that Mysql keeps timing out ever so often when I am doing some work with it. The error I get is:

"Too many connections"

Any ideas how I can fix this ... permanently?

As ever, any help here is much appreciated.

Kenny

Use a text editor to edit the "my.cnf" file, i would tell you where it is but i only know where the linux version is. But when you find it, add this to the file.

Code: Select all

[mysqld]
set-variable = max_connections=xxx

Set the xxx to whatever number you want to default is 100.

Underdone,

Thanks for that! I already tried that out before I got your reply and so far everything seems okay. I hope it remains so.

Thanks again.

Kenny

This problem still occurs and am not sure why despite having made the change to max connections.

Please can anyone provide some help or insight to this issue? Am sure there are others having this same problem.

Many thanks ...

You have a my.cnf (or just my) file in xampp\mysql\bin\ and a my.ini file in C:\WINDOWS\.
Try adding the set-variables to both and see if it helps.

Check the mysql error log - xampp\mysql\data\(yourPC name).err and see if there are any clues there.

Check out these 2 articles at the mysql dev site for more clues:
http://dev.mysql.com/doc/refman/5.0/en/ ... tions.html
http://dev.mysql.com/doc/refman/5.0/en/ ... slist.html

Also this link might be useful:
http://www.faqts.com/knowledge_base/vie ... 230/fid/13

I also read about this being an acceptable fix for the added set-variables:
set-variable = max_connections=1000
set-variable = wait_timeout=60