|
|
|
|
![]() ![]() |
Aug 16 2007, 01:27 AM
Post
#1
|
|
|
Member - Active Contributor Group: Members Posts: 91 Joined: 18-May 07 Member No.: 22,008 |
I uploaded my PHP game yesterday, and most of my friends tried it out. After a while, I tried to play as well but it said that mysql_connect() had too many connections already. Can anyone tell me how to increase the amount of connections or maybe the total amount of connections allowed?
|
|
|
|
Aug 16 2007, 07:21 AM
Post
#2
|
|
|
Super Member Group: [HOSTED] Posts: 802 Joined: 8-April 06 From: Lima - Peru Member No.: 12,579 myCENTs:17.43 |
I uploaded my PHP game yesterday, and most of my friends tried it out. After a while, I tried to play as well but it said that mysql_connect() had too many connections already. Can anyone tell me how to increase the amount of connections or maybe the total amount of connections allowed? You need to change the mysql.max_links directive and set it to -1, you can set this directive in your php.ini configuration file or in your apache's httpd.conf file. Also, check out the MySql max_connections system variable, this variable controls the number of connections allowed that by default is 100. so if you need more connections, you should restart mysqld with a larger value for this variable. If you are using MySql 5 take a look to B.1.2.6. Too many connections. Best regards, |
|
|
|
Aug 16 2007, 12:53 PM
Post
#3
|
|
|
Member - Active Contributor Group: Members Posts: 91 Joined: 18-May 07 Member No.: 22,008 |
I understand. The site is already uploaded to the internet. Can I change my host's max_connections? Or is it something that only they are allowed to set?
|
|
|
|
Aug 17 2007, 01:39 AM
Post
#4
|
|
|
Way Out Of Control - You need a life :) Group: Members Posts: 1,086 Joined: 21-June 05 From: New York Member No.: 6,440 myCENTs:86.41 |
It depends. I've seen some hosts that will allow their users to edit this setting. I would contact the webhost to see what can be done. If anything, they will/can increase it for you.
|
|
|
|
Aug 17 2007, 01:46 AM
Post
#5
|
|
|
Member - Active Contributor Group: Members Posts: 91 Joined: 18-May 07 Member No.: 22,008 |
Thanks.
|
|
|
|
![]() ![]() |
Similar Topics
|
Lo-Fi Version | Time is now: 2nd December 2008 - 11:10 AM |