Page 1 of 1

Too many connections in mysql

PostPosted: Wed Jul 09, 2008 2:17 am
by reland02
Hi,

How can I avoid this message ' too many connections in mysql' in my dbase server, my setup is 2 asteriskpbx and 1 mysql+web servers. when I increase the max connection in my my.cnf the system load of my dbase server was very high so I put it back to the default settings. Is thier anyone encounter this kind of problem

PostPosted: Wed Jul 09, 2008 8:04 am
by mflorell
you need to set the max connections higher and get more RAM or a faster machine for your Database. Also tweaking other my.cnf settings can help with MySQL performance.

What are the Database server specifications?

PostPosted: Wed Jul 09, 2008 5:17 pm
by reland02
Hi Matt,

My Dbase Servers Specs,

Intel(R) Xeon(R) CPU 5110 @ 1.60GHz
CPU Speed 1.6 GHz

2 Gig of RAM

what are the other tweaking should be modify besides with max connection to better the performance

PostPosted: Wed Jul 09, 2008 5:29 pm
by mflorell
is this a single core CPU?

what was the loadavg up to when you set the max connections higher?

how many agents do you have across this system?

PostPosted: Thu Jul 10, 2008 2:15 pm
by reland02
Nope it is separated with the asterisk server and the total agents is about 55. When I set the max connections to 150 the load goes 12.5 :oops:

PostPosted: Fri Jul 11, 2008 2:48 am
by mflorell
You need a better database server for 55 agents. a single core Xeon 1.6GHz is very old technology. You should go for a quad core at least, and the more RAM the better.

Probably disk issue

PostPosted: Mon Jul 14, 2008 8:29 am
by angelos
Why don't you tell us what kind of disks you have ?

Try to enable dma for your IDE disks.

reland02 wrote:Hi Matt,

My Dbase Servers Specs,

Intel(R) Xeon(R) CPU 5110 @ 1.60GHz
CPU Speed 1.6 GHz

2 Gig of RAM

what are the other tweaking should be modify besides with max connection to better the performance

PostPosted: Mon Jul 14, 2008 1:59 pm
by reland02
Hi Angelos,

Im using a ata hardisk drive. or should I disable some of the component in the cmos like pci, usb, etc. that is not needed by the vicidial?

PostPosted: Fri Jul 18, 2008 2:22 pm
by mcargile
You should get a Quad core system with as much RAM as you can get and a caching RAID controller.

If you are interested we do offer hardware that is proven to withstand the load Vicidial produces. Please contact sales staff at 1-888-894-VICI (8424).

PostPosted: Sat Jul 19, 2008 5:57 am
by codehaxor
mflorell wrote:You need a better database server for 55 agents. a single core Xeon 1.6GHz is very old technology. You should go for a quad core at least, and the more RAM the better.


get at least 8GB of DDR2 RAM, and an intel quadcore 2.4 GHZ, western digital raptor 160GB SATA 10,000 RPM HDD or SCSI hard drive if you have the budget