MySQL max concurrent connections

[Eikinskjaldi]

Originally Posted by MrEyes

Hello,

At first this may not seem like a programming question, bear with me it will turn into one

I am trying to get my head around the mx concurrent connection limit in MySQL. Is this as the name suggests the maximum concurrent connections that can be made to the database for all db users? Or is it the maximum concurrent connections that can be made to the database for a single db user?

Both options are independently settable. You can find out what the settings are by running the mysql command show variables (you need specific permission to do this, which your host may not have provided)

As an alternative you could look at /etc/my.cnf which might also contain the information.

The reason I ask is that my current hosting is causing me no end of grief with their low connection cap, and I am looking for a way to get around it.

Move to a new host.

It the connections are per user and not per server, then I can create a hack in VB that rather than use a single DB account it uses multiple. So rather than have this in the config:

Many shared hosts limit the number of mysql accounts you can have. Having said that, yes what you ask is possible, probably best done as a round-robin scheduler. It would involve alot more that a few lines in config.

and does VB use a single class/php function for DB access?

single class.