Hi Gurus, I'm relatively new to MySQL - been studying it for the past 2 months. So far, so good (or Great).
I recently moved from MySQL 3.23.22 to 4.0.2-alpha-debug-log on our 4.6.1-RELEASE-p10 FreeBSD server. Using the mysql client, I noticed an annoying message immediately after every query: ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id: 13 I checked in the error log file and find this repeated, for every occurance of this error on my screen: /usr/local/libexec/mysqld: read looped with error 35, aborting thread I've checked the variables and settings. All of the timeouts are default. +--------------------------+-------+ | Variable_name | Value | +--------------------------+-------+ | connect_timeout | 30 | | delayed_insert_timeout | 300 | | flush_time | 0 | | innodb_lock_wait_timeout | 50 | | interactive_timeout | 28800 | | long_query_time | 10 | | net_read_timeout | 120 | | net_write_timeout | 180 | | slave_net_timeout | 3600 | | slow_launch_time | 2 | | timezone | EDT | | wait_timeout | 28800 | +--------------------------+-------+ If I type queries real fast, immediately after eachother, I don't get this error. The error gets logged in the log file exactly 5 seconds after a query if I dont' type anything. 5 seconds!!! I've checked the /etc/my.cnf file and its default. No .my.cnf files to worry about. Any thoughts? Is this info useful at all: mysql> status; -------------- mysql Ver 12.10 Distrib 4.0.2-alpha, for unknown-freebsdelf4.6 (i386) Connection id: 10 Current database: samp_db Current user: blairwag@localhost SSL: Not in use Current pager: stdout Using outfile: '' Server version: 4.0.2-alpha-debug-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset: latin1 Server characterset: latin1 UNIX socket: /tmp/mysql.sock Uptime: 20 min 22 sec Threads: 1 Questions: 90 Slow queries: 0 Opens: 14 Flush tables: 1 Open tables: 8 Queries per second avg: 0.074 Memory in use: 46839K Max memory used: 46902K -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ William Blair Wagner : Education is not always knowing the answer, [EMAIL PROTECTED] : ...but rather knowing where to look for it! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --------------------------------------------------------------------- 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
