Hi, I'm relatively new to MySQL, but it's been working well for me with dozens of Perl scripts. We use it as our database with our ISP. Our database size is currently about 30MB, and the majority of that is in two tables which each contain about 20,000 records. The database has not changed much in size, nor have the number of accesses (at a rare peak, 3 or 4 times per minute but an average of 500 accesses per day), but over the last few months we see the following scenario: 1) One or the other my large tables becomes inaccessible - I can get schema but I can't do any queries. 2) All my scripts hang and then are killed by the ISP. 3) After a few hours with the table locked and scripts hanging, the entire database becomes inaccessible because there are 'too many connections.' When it first started 3 months ago, this happened once a month, then after two weeks, then weekly. It happened yesteday and then again today. The only recovery is to reload the MySQL Daemon. Does anyone have any ideas about what might cause the tables to become inaccessible? Steve -------------------------------------------------------- Techie Hedgehogbooks.com, Inc. 806 Modesto Avenue Santa Cruz, Ca 95060 phone: 408-813-6294 www.hedgehogbooks.com --------------------------------------------------------------------- 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
