bhanuprasad1981

Well-Known Member
Aug 5, 2008
222
0
66
India
one of my client say while tries to make backup of his account , he cant access his site and all visitors are kicked off with message "too many connections" what maybe the issue and solution ?
 

asiams

Well-Known Member
May 28, 2003
89
0
156
Hokkaido, JAPAN
optimal connections number for 2GB of memory?

Hello

What would be the optimal connection numbers for a server with 2GB of Ram?

Current setting is 500

Thanks.
 

jdarow

Well-Known Member
PartnerNOC
May 30, 2003
88
1
156
Michigan, US
cPanel Access Level
DataCenter Provider
That would depend on what each connection is doing... how much server resources each connection is using. Having a low setting will cause errors like you've seen. It's a safeguard. Preventing so many connections that MySQL eats up all your system resources. So, the optimal setting is where MYSQL doesn't kill you server's performance. If it's too low you get errors. If it's too high your server could crash. Unless you're running a very low-end server, 500 connections should be fine. Consider it more as a safeguard than an optimization setting with a perfect value. If your server can handle 500 MySQL connection, 500 is fine.

Hope that helps.