MySQL error max-users

Codes here !

Moderators: macek, egami, gesf

Beady
New php-forum User
New php-forum User
Posts: 6
Joined: Sat Jan 04, 2003 3:30 am
Location: UK
Contact:

MySQL error max-users

Postby Beady » Mon May 05, 2003 1:14 am

Hi,

I have a site that uses PHP/MySQL extensively. On some individual pages I have calls to four separate tables. After browsing the site for a few moments users are receiving a MySQL error -
Server has already more than 'max_user_connections' active connections.

Is this some sort of coding error? Is it likely to be something that I have done? or is it a value that the host can change.

I'd like to know before I start shouting at them. Can some one please enlighten me.

Thanks,
Bernard Davis

User avatar
Joan Garnet
Moderator
Moderator
Posts: 387
Joined: Sat Aug 03, 2002 2:56 am
Location: Mars
Contact:

Postby Joan Garnet » Wed May 14, 2003 10:36 am

Have a look at this article, you'll find it useful:
http://www.mysql.com/doc/en/User_resources.html

Bye!

Beady
New php-forum User
New php-forum User
Posts: 6
Joined: Sat Jan 04, 2003 3:30 am
Location: UK
Contact:

Postby Beady » Wed May 14, 2003 10:51 am

Many thanks.

It looks then as though they've set an arbitrary value for max_user_connections.

I'll go shout at them.

Cheers

Bernard Davis

User avatar
Redcircle
Moderator
Moderator
Posts: 830
Joined: Tue Jan 21, 2003 10:42 pm
Location: Michigan USA
Contact:

Postby Redcircle » Tue May 20, 2003 1:17 am

another thing that might be happening is everytime you query you open a new connection without closing it when you are finished.


Return to “mySQL & php coding”

Who is online

Users browsing this forum: No registered users and 1 guest