max_user_connections
Moderator: General Moderators
max_user_connections
I had a site running fine and it has been doing so for months. Then suddenly this came:
Warning: mysql_connect(): User dvdtown_sqledit has already more than 'max_user_connections' active connections in
What could be wrong? Is there a way to fix this in the code or? Any help or ideas are appreciated.
The whole thing is coded in PHP and MySQL.
Warning: mysql_connect(): User dvdtown_sqledit has already more than 'max_user_connections' active connections in
What could be wrong? Is there a way to fix this in the code or? Any help or ideas are appreciated.
The whole thing is coded in PHP and MySQL.
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
Doesn't unlimited mean unlimited? Or is it something else I have to ask about?
Also, this has not been a problem in the past. The site has run with many visitors for months with no problems. So it comes as a big supprise.
What I need is some information about how to solve this. Where to look. Perhaps some web sites dealing with it etc.
Also, this has not been a problem in the past. The site has run with many visitors for months with no problems. So it comes as a big supprise.
What I need is some information about how to solve this. Where to look. Perhaps some web sites dealing with it etc.
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
Your host may have only just implemented this and I doubt there'd be a way around it without getting them to tweak your user account. Of course if this is a user that you've created you may have more luck:
http://www.mysql.com/doc/en/User_resources.html
Mac
http://www.mysql.com/doc/en/User_resources.html
Mac
from your phpinfo look for mysql.allow_persistent under the mysql section.
Can't believe your host couldn't tell you this.
Suppose you could change it within a script though!?
Check here to read more about persistent connections http://uk2.php.net/manual/en/features.p ... ctions.php
Mark
Can't believe your host couldn't tell you this.
Suppose you could change it within a script though!?
Check here to read more about persistent connections http://uk2.php.net/manual/en/features.p ... ctions.php
Mark