Helpful Information

Category: General Info

Max sql connections

Hi,

I have a friend who is planning on moving hosting company and has asked me about Westhost (where I'm currently hosted). Could someone please tell me what the default value for max_user_connections is (the number of concurrent connections into the mySQL databases)?

I see that on my hosting I have access to /etc/my.cnf where I can make the changes - but is there an overriding server value set by Westhost?

Thanks.

Hi,

On my account the global value appears to be set at zero (unlimited). Why does your friend need to know this? If he's leaving his current host due to resource usage, it's not likely he'll have much more luck in another shared environment.

Hi,

Her current hoster recently dropped the value down to 3 due to abuse by other customers on the shared server. They took the sledgehammer approach and applied the limit to all customers. We're only talking about a very low volume vbulletin board here so she doesn't need anything special - but even so, 3 is ridiculous. It was causing quite a few error messages to be generated.

A lot of places she's looked at have unlimited as the value, so it's what I was hoping for here as well so I could recommend Westhost.

Many thanks.

rispku's response was correct in that the default value given is 0 (zero) for accounts. This can be changed through editing your my.cnf file, however zero is the default setting upon installing MySQL onto your server.

That's great.

Many thanks for the info.