se7enet purgatorio

Page 1 of 1 1
Topic Options
Rate This Topic
#10869 - 03/02/06 10:10 AM mysql max_users
doublet
Corn Flakes


Registered: 06/15/05
Posts: 89
Loc: Estonia, Pärnu

Offline
i have this error when more than 13 users online

Warning: mysql_connect(): User maffiap_don has already more than 'max_user_connections' active connections in /home/maffiap/public_html/lib.php on line 43
User maffiap_don has already more than 'max_user_connections' active connections

Help please
_________________________
Maffia Rules The Streets

Top
#10870 - 03/02/06 03:09 PM Re: mysql max_users [Re: ScriptFactory]
Santosj
Rice Krispies


Registered: 12/29/04
Posts: 292
Loc: Missouri

Offline
Well, it isn't a problem with the stock code. It is a problem with your host.

I would check to make sure that there is a mysql_close($dbconnection) at the end of the index.php file. Usually, the mysql connection is freed once it is used, which allows others to use the connection.

If you are advanced enough, you could try some caching methods.

Else, there isn't really anything else you can do except find a better host or pay for one if you are using one of the free ones.


Edited by Gold Dragon (03/02/06 03:11 PM)
_________________________
Game Company | PHP Development Company | Blog Why do I visit these forums? To help on PHP questions and I'm waiting for Dragon Scourge. Also hinting at developing possible mods with no follow through.

Top
#10871 - 03/05/06 04:11 AM Re: mysql max_users [Re: BYBYS]
xanderman
Corn Flakes


Registered: 12/06/05
Posts: 79
Loc: Australia

Offline
Gold Dragon has it right; your host has configured their system to allow only thirteen concurrent connections to your mysql database, which really blows. some hosts are nice enough to increase your limit without any additional fees if you ask them.

caching wouldnt really do much since the issue is concerned with the database itself, not data transfer.

Top
#10872 - 03/05/06 11:43 AM Re: mysql max_users [Re: BYBYS]
doublet
Corn Flakes


Registered: 06/15/05
Posts: 89
Loc: Estonia, Pärnu

Offline
It isnt always 13 users sometimes it over 30 users oline and no error. added mysql_close($dbconnection) in the end of the index file. i pay $25 in motn so it isnt cheap(100 000MB BW makes it expencive )I will write to host and ask for help.
_________________________
Maffia Rules The Streets

Top
#10873 - 03/05/06 12:04 PM Re: mysql max_users [Re: ScriptFactory]
Jamin Administrator
Cookie Crisp
****

Registered: 02/25/05
Posts: 2649
Loc: Texas

Offline
It could also be that they're trying to pack too many accounts onto one physical server. So it may have nothing to do with limitations to your particular account, it's just everyone on your server combined is overloading MySQL. That being the case, there's really nothing you can do unless your host gets their act together and stops overselling accounts.

---Jamin
_________________________
Diablo 3 Lead Designer Jay Wilson:
“The development of a Blizzard game is sometimes a long affair. This is how long it took us to be ready.”

Top
Page 1 of 1 1


Hop to:

se7enet

Barack Obama Logo