I run PHP 4.0.3 and MySQL 3.23.32. I get a fair amount of traffic and host about 1000 very small sites on a fairly fast server with plenty of RAM and space. However, it keeps shutting down frequently and every time it shuts down, the binary log files rotate, and someone will probably try to access the database while it's down and they'll get an error.
Here's a clip from my error log that seems to be repeated over and over and over again, just at different times: ---- BEGIN SNIPPET ---- 011109 7:27:33 Aborted connection 13073 to db: 'site_info' user: 'root' host: `localhost' (Got an error reading communication packets) 011109 7:59:00 Aborted connection 13081 to db: 'site_mails' user: 'root' host: `localhost' (Got an error reading communicat ion packets) 011109 7:59:00 Aborted connection 13080 to db: 'site_mails' user: 'root' host: `localhost' (Got an error reading communicat ion packets) mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 011109 08:20:45 mysqld restarted /usr/local/mysql/libexec/mysqld: ready for connections 011109 8:57:31 Aborted connection 1622 to db: 'site_mails' user: 'root' host: `localhost' (Got an error reading communicati on packets) 011109 8:57:31 Aborted connection 1654 to db: 'site_mails' user: 'root' host: `localhost' (Got an error reading communicati on packets) 011109 8:57:31 Aborted connection 1806 to db: 'site_users' user: 'root' host: `localhost' (Got an error reading communi cation packets) 011109 8:59:00 Aborted connection 1817 to db: 'site_mails' user: 'root' host: `localhost' (Got an error reading communicati on packets) mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 011109 09:01:37 mysqld restarted /usr/local/mysql/libexec/mysqld: ready for connections ---- END SNIPPET ---- Any ideas, anyone? I don't use persistent connections, by the way. There's only one page that does use them, and it is accessed about once every couple months. It is not part of the main sites that everyone surfs. - Jonathan --------------------------------------------------------------------- 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
