Thanks in advance. I've been having problems with the mysql server shutting down. It shows no, or few, processes with 'mysqladmin -p processlist'. Once it has shut down, I can't restart it. Sometimes it does this at the slowest time of the night. I'm using it for the backend of a website. The website uses perl with DBI. It is version 3.22.32 running on freebsd. Here is part of my httpd-error.log: [Wed Mar 28 14:49:57 2001] [error] (54)Connection reset by peer: getsockname [Wed Mar 28 14:49:57 2001] [error] (54)Connection reset by peer: getsockname DBI->connect failed: Lost connection to MySQL server during query at /usr/local/www/data/board.cgi line 9 DBI->connect failed: Lost connection to MySQL server during query at /usr/local/www/data/board.cgi line 9 [Wed Mar 28 14:52:04 2001] [error] [client 213.1.140.11] Premature end of script headers: /usr/local/www/data/board.cgi [Wed Mar 28 14:52:04 2001] [error] [client 24.142.208.94] Premature end of script headers: /usr/local/www/data/board.cgi DBD::mysql::st execute failed: Server shutdown in progress at /usr/local/www/data/board.cgi line 112. Database handle destroyed without explicit disconnect. DBD::mysql::st execute failed: Server shutdown in progress at /usr/local/www/data/board.cgi line 112. Database handle destroyed without explicit disconnect. DBD::mysql::st execute failed: Server shutdown in progress at /usr/local/www/data/board.cgi line 112. Database handle destroyed without explicit disconnect. DBD::mysql::st execute failed: Server shutdown in progress at /usr/local/www/data/board.cgi line 139. DBD::mysql::st execute failed: Server shutdown in progress at /usr/local/www/data/board.cgi line 112. Database handle destroyed without explicit disconnect. DBD::mysql::st execute failed: Lost connection to MySQL server during query at /usr/local/www/data/board.cgi line 139. Database handle destroyed without explicit disconnect. DBD::mysql::st execute failed: Server shutdown in progress at /usr/local/www/data/board.cgi line 132. Database handle destroyed without explicit disconnect. Database handle destroyed without explicit disconnect. DBI->connect failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/www/data/PlayByWeb.cgi line 79 [Wed Mar 28 15:00:00 2001] [notice] SIGUSR1 received. Doing graceful restart [Wed Mar 28 15:00:02 2001] [notice] Apache/1.3.12 (Unix) PHP/4.0.1pl2 configured -- resuming normal operations DBI->connect failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/www/data/edit2.cgi line 201 [Wed Mar 28 15:00:02 2001] [error] [client 66.38.1.6] Premature end of script headers: /usr/local/www/data/edit2.cgi DBI->connect failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/www/data/board.cgi line 9 Here is my variable list. I modified wait_time and set it up according to the manual for a server that has 64meg of ram. +----------------------------+---------------------------------+ | Variable_name | Value | +----------------------------+---------------------------------+ | back_log | 5 | | connect_timeout | 5 | | basedir | /usr/local/ | | datadir | /var/db/mysql/ | | delayed_insert_limit | 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000 | | join_buffer | 131072 | | flush_time | 0 | | key_buffer | 520192 | | language | /usr/local/share/mysql/english/ | | log | OFF | | log_update | OFF | | long_query_time | 10 | | low_priority_updates | OFF | | max_allowed_packet | 1048576 | | max_connections | 210 | | max_connect_errors | 10 | | max_delayed_insert_threads | 20 | | max_join_size | 4294967295 | | max_sort_length | 1024 | | max_write_lock_count | 4294967295 | | net_buffer_length | 16384 | | pid_file | /var/db/mysql/playbyweb.pid | | port | 3306 | | protocol_version | 10 | | record_buffer | 98304 | | skip_locking | OFF | | skip_networking | OFF | | socket | /tmp/mysql.sock | | sort_buffer | 102392 | | table_cache | 422 | | thread_stack | 65536 | | tmp_table_size | 1048576 | | tmpdir | /var/tmp/ | | version | 3.22.32 | | wait_timeout | 600 | +----------------------------+---------------------------------+ --------------------------------------------------------------------- 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
