MySQL Databases

[webdev]

Okay I guess this is a bit of a whinge, however because nothing had ever been said to me since I signed up as aHostGator reseller I feel it is justified.

I have a blog that forms part of my business web site.

The account (domain) is my primary account (the account I signed up under).

So this morning & every day since I started the blog things were absolutely fine.

However I just tried to go to my blog - not the admin screen - just the "normal" URL of the blog & I get the following message:

Warning: mysql_connect(): Too many connections in /home/edesign/public_html/serendipity/include/db/mysql.inc.php on line 156

Warning: mysql_select_db(): Too many connections in /home/edesign/public_html/serendipity/include/db/mysql.inc.php on line 157

Warning: mysql_select_db(): A link to the server could not be established in /home/edesign/public_html/serendipity/include/db/mysql.inc.php on line 157
DATABASE_ERROR

So I contact "support" on "live chat". They said it was because each server is limited to the amount of "concurrent" connections.

They also said (half an hour ago) that things would be fine again in a couple of minutes.

Well they are not! Still that same error message.

Now since Google & the other search engines have not listed my site, & snce it has not as yet been advertised as I am still developing it - that all means just one thing.

I am the only one who is currently using it at all - & now I can't even do that because "others" are using "other" MySQL databases on their own site(s).

This seems highly unfair to me.

I can't even have one user (me) on mine while "others" have hogged all the connections.

Surely their is something that can be done at a server administration level to even out the playing field?

Not happy Jan!

[webdev]

Just spoke with "live chat" (Geoff) & now he reckons that there is no database.

Amazing since I only posted an article this morning.

Do these "live chat" support types really have a clue?

Or are they a panecia for the gullible.

[webdev]

Well amazingly my "non existant" MySQL database is back working.

If only I could create "gold" as easy as creating a "non existant" database without doing a thing.

It really throws doubt on the skill level & knowledge of those "live chat" types though.

So now to the other part of my original post.

Surely if a reseller is paying good money there must be some way of equally sharing the server's resources.

The thought that I cannot even see my blog, (due to maximum MySQL connections being exceeded by others on their own sites), on the web server that I help pay for goes against the grain.

How about some load balancing? There must be some way to ensure that resources are equally shared among all resellers?

[GatorBrent]

Just responded to your email. Thanks!

[ltrump]

I believe it is 25 connections per account. I do not believe that you are sharing your 25 connections with anyone else. I think all that happened here was that the MySQL Database service glitched.

[se4b4ss]

Is this correct? Only 25 connections/account at one time?

Steve

[gregw]

Don't use persistent connections. This thread deals with this issue at length.

[The Angel]

I had the same problem with my site only when the db came back my content table was gone. My site is wiki based so most of it is stored in the database and with a deleted content table...well, rebuilding a site sucks.