| View previous topic :: View next topic |
| Author |
Message |
Arwin
Joined: 12 Jul 2005
Posts: 426
|
 Posted: Tue Oct 04, 2005 10:31 pm Post subject: Performance issues |
 |
|
The last few days I'm getting the occasionaly too many connections message (as below).
Is there anything we can do to help with that?
Warning: mysql_connect(): Too many connections in /usr/local/www/psdev/forums/db/mysql4.php on line 48
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /usr/local/www/psdev/forums/db/mysql4.php on line 330
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /usr/local/www/psdev/forums/db/mysql4.php on line 331
phpBB : Critical Error
Could not connect to the database |
|
| Back to top |
|
 |
rinco
Joined: 21 Jan 2005
Posts: 255
Location: Canberra, Australia
|
| Posted: Wed Oct 05, 2005 3:25 pm Post subject: |
|
|
| Quote: | | The number of connections allowed is controlled by the max_connections system variable. Its default value is 100. If you need to support more connections, you should restart mysqld with a larger value for this variable. |
http://dev.mysql.com/doc/mysql/en/too-many-connections.html
Perhaps Oobles can change this value...? |
|
| Back to top |
|
|
Arwin
Joined: 12 Jul 2005
Posts: 426
|
| Posted: Tue Oct 11, 2005 8:57 pm Post subject: |
|
|
*bump*
Again today between 12:00 - 12:30 (GMT +01)
Maybe a backup scheduled at that time? |
|
| Back to top |
|
|
Oobles
Site Admin
Joined: 17 Jan 2004
Posts: 362
Location: Melbourne, Australia
|
| Posted: Wed Oct 12, 2005 12:01 am Post subject: |
|
|
I'm not sure if there is much I can do about this. It seems to happen at times some people are attempting to index the site. This creates something like a denial of service attack. The other symptom which I see nearly every second day is all mbufs exhausted. I don't know what can be done about these issues. I check the server periodically and the database connection count is not usually very high.
Hope that explains it.
David.
PS If you have any suggestions for improving this or limiting this type of denial of service attack please let me know. |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
