Mysql Timeouts

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Mysql Timeouts

Postby pccsq1 » 15. November 2006 04:13

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
User avatar
pccsq1
 
Posts: 8
Joined: 12. November 2006 20:54

Postby underdone » 15. November 2006 23:23

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.
User avatar
underdone
 
Posts: 34
Joined: 15. October 2006 04:56
Location: Albuquerque, NM

Postby pccsq1 » 15. November 2006 23:54

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
User avatar
pccsq1
 
Posts: 8
Joined: 12. November 2006 20:54

Postby pccsq1 » 18. November 2006 16:04

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 ...
User avatar
pccsq1
 
Posts: 8
Joined: 12. November 2006 20:54

Postby Izzy » 18. November 2006 18:42

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
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 78 guests