Page 1 of 1

Performance issues

Posted: Tue Oct 04, 2005 10:31 pm
by Arwin
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

Posted: Wed Oct 05, 2005 3:25 pm
by rinco
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-m ... tions.html

Perhaps Oobles can change this value...?

Posted: Tue Oct 11, 2005 8:57 pm
by Arwin
*bump*

Again today between 12:00 - 12:30 (GMT +01)

Maybe a backup scheduled at that time?

Posted: Wed Oct 12, 2005 12:01 am
by Oobles
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.