Re: ERROR 2013 (HY000): Lost connection to MySQL server at 'sending authentication information', system error: 32
Posted by:
Magic Mok
Date: June 08, 2009 01:31AM
Some more input:
- the warnings on the log are "Got timeout reading communication packets"
- I am using skip-networking (using unix sockets)
- load average is low, memory is free
- mysqld version is 5.0.45 (centos default), though I doubt it's a mysqld problem.
What can cause a communication timeout on skip-networking?
#
# mysqld log file
#
$tail -n200 /var/log/mysqld.log | grep "Warning"
090608 3:12:39 [Warning] Aborted connection 1160 to db: '***' user: '**' host: 'localhost' (Got timeout reading communication packets)
090608 3:12:39 [Warning] Aborted connection 1162 to db: '***' user: '**' host: 'localhost' (Got timeout reading communication packets)
#
# skip networking is ON
#
mysql> show variables like "%net%";
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| skip_networking | ON |
| slave_net_timeout | 3600 |
+-------------------+-------+
#
# load
#
$ top
top - 03:23:50 up 17 days, 22:56, 2 users, load average: 0.83, 0.77, 0.73
Tasks: 103 total, 1 running, 102 sleeping, 0 stopped, 0 zombie
Cpu(s): 37.3%us, 2.7%sy, 0.0%ni, 59.2%id, 0.8%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 2058280k total, 1716200k used, 342080k free, 119172k buffers
Swap: 2097136k total, 88k used, 2097048k free, 1088204k cached
...
Edited 1 time(s). Last edit at 06/08/2009 02:07AM by Magic Mok.