Too many connections Is the message you get when all are used up. The limit is about 1000 (Linux) but can be set higher. With MySQL you can set a limit for each user. So I would set this to say 100 for each user and 1000 in total. What courses this is pconnects or threads that will not drop. If you use pconnects and don't re use them client side these can had around till they are dropped (8 hours standard). The other thing that can happen is when a table is locked by backups or a log question other connections can get backed up. Hope this helps Simon
-----Original Message----- From: Tom Norwood [mailto:[EMAIL PROTECTED]] Sent: 21 August 2002 10:55 To: mysql-list Subject: Another 'Too many connections' question... A couple of weeks ago I came across this error which effectively closed down our site. Two things: (1) I am using Perl DBI to interface mySQL is there any way to effectively capture such errors and provide an alternate web page? I guess there has to be, but I experimented with the 'PrintError' and 'RaiseError' with little joy. (2) At present our MySQL needs are provided by our ISP by means of a shared server (dedicated to MySQL I think!). The 'max_connections' variable (SHOW VARIABLES) is currently set to 300, which seems a bit on low side for a server with 770 databases (SHOW DATABASES) with I don't know how many tables. What causes this error, 'any' connection, admin type connections, etc.? And does this error require a server/mysqld restart on the part of our ISP? They were typically unhelpful when I spoke to them (hope that's not due to ignorance.) Have been looking at dedicated hosting for a while now, but finding the cash and moreover the time to move is proving a slow process. Any help gratefully Rx'd, Tom. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
