vicidial.org

by **reland02** » Wed Jul 09, 2008 2:17 am

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

by **mflorell** » Wed Jul 09, 2008 8:04 am

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?

by **reland02** » Wed Jul 09, 2008 5:17 pm

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

by **mflorell** » Wed Jul 09, 2008 5:29 pm

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?

by **reland02** » Thu Jul 10, 2008 2:15 pm

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:

by **mflorell** » Fri Jul 11, 2008 2:48 am

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.

by **angelos** » Mon Jul 14, 2008 8:29 am

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

by **reland02** » Mon Jul 14, 2008 1:59 pm

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?

by **mcargile** » Fri Jul 18, 2008 2:22 pm

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).

by **codehaxor** » Sat Jul 19, 2008 5:57 am

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

vicidial.org

Too many connections in mysql

Too many connections in mysql

Probably disk issue

Who is online