Connecting Tech Pros Worldwide Help | Site Map

Too many connection error

Member
 
Join Date: Mar 2008
Location: India, Kerala
Posts: 49
#1: Jan 10 '09
When I found " Too many connection error" may occur because of mysql default allowed maximum connection of 100. I changed it to a big value. but even my fedora shows the same error what are the other causes for "Too many connection error"

Thanks in advance
john
ashitpro's Avatar
Expert
 
Join Date: Aug 2007
Posts: 389
#2: Jan 11 '09

re: Too many connection error


Quote:

Originally Posted by mvjohn100 View Post

When I found " Too many connection error" may occur because of mysql default allowed maximum connection of 100. I changed it to a big value. but even my fedora shows the same error what are the other causes for "Too many connection error"

Thanks in advance
john

If you've modified my.conf, have you tried restarting the mysql service?
Member
 
Join Date: Mar 2008
Location: India, Kerala
Posts: 49
#3: Jan 12 '09

re: Too many connection error


Thanks for the suggestion, I done that, but the problem exists. Is there any other things cause for "too many connections"

john
ashitpro's Avatar
Expert
 
Join Date: Aug 2007
Posts: 389
#4: Jan 13 '09

re: Too many connection error


It looks like some process is utilizing your resources without controll
you can list out the processes which are using mysql...
just hit "[FONT=courtier,monospace]show processlist" command at mysql command prompt and see whats going wrong...

Regards,
Ash
[/FONT]
Reply