I just found out from my host that there could only be 20 simultaneous connections to the database. Exceeding limit could result in having an error message on your webpage "Warning: MySQL Connection Failed: Too many connections". Does anyone know normally how many simultaneous connections your host would allow you to have?

Thanks

I'm hosting my site at OLM at I really believe it's pretty not enough to have only 20 connections. But anyway is there any method to check this number if I just telnet to the server? Like what kind of command?

I don't believe there is a way for you to check.

I am hosted at OLM and I was told theres 150 connections allow per server. Appearently any more than this can cause problems that effect other users on the server.

Hope this is helpful

Thanks twa.

I've sent an email to support to ask them clarify this and why they said I have only 20 sim. connections. I'll let you know when I got a reply.

I just got a reply from them. Pretty quick eh?

Actually 2 support guys replied me with the same answer -- 150 max connections.

But I just looked at mysql.com and found that you can check this number yourself. Just ust SHOW VARIABLES and you can see max_connection. But what I saw is only 100 there. It's a little bit confusing..

I just emailed and said I did a connection check and it showed 100, and I was told 150. They apologized and said there are some servers set at 100 and 130 also.


TWA

mysqld -O max_connections=1000

(if rpm installed [vdi servers do this] you will need to edit /etc/rc.d/init.d/mysql)


Nick
(cpanel3 developer)