Hello all,
I'm getting the error message "2013 : Lost connection to MySQL server during query" during inserts on a lightly-loaded mysql server. I also noticed the following error in the error log...
Version: '4.0.20-standard-log' socket: '/tmp/mysql.sock' port: 3306
040603 16:25:48 Aborted connection 1 to db: 'milterdb' user: 'milteruser' host: `localhost' (Got an error reading communication packets)
I am going nuts trying to fix this error! I've done some googling and the only fixes I've heard of are fixing name resolution errors. I'm thinking that has nothing to do with this setup since 1000s of other inserts/queries are fine. One second it is working, the next second it stops with this error.
The application interfaces with a Sendmail mail server and archives all incoming/outgoing email traffic to the MySQL database. The source is available if anybody thinks my poor coding is the problem.
Any help or ideas will be greatly appreciated.
Thanks in advance! Daniel Whitener
basic config info is below. I can provide more details if needed...
I'm using suse 9.1
uranus:~ # uname -a
Linux uranus 2.6.4-52-default #1 Wed Apr 7 02:08:30 UTC 2004 i686 i686 i386 GNU/Linux
uranus:~ #
mysql> status; -------------- mysql Ver 12.22 Distrib 4.0.20, for pc-linux (i686)
Connection id: 15 Current database: Current user: [EMAIL PROTECTED] SSL: Not in use Current pager: less Using outfile: '' Server version: 4.0.20-standard-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset: latin1 Server characterset: latin1 UNIX socket: /tmp/mysql.sock Uptime: 55 min 51 sec
Threads: 2 Questions: 313 Slow queries: 1 Opens: 11 Flush tables: 1 Open tables: 5 Queries per second avg: 0.093
mysqld section of the my.cnf file... # The MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock wait_timeout = 7200 interactive_timeout = 28800 skip-locking key_buffer = 64M max_allowed_packet = 10M table_cache = 128 sort_buffer_size = 1M read_buffer_size = 1M net_buffer_length = 8K myisam_sort_buffer_size = 16M user = mysql thread_stack = 1M thread_cache = 8 query_cache_size = 16M thread_concurrency = 4
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
