如何解决Got an error writing communication packets
mysql> show global status like '%open%';+--------------------------+---------+
| Variable_name | Value |
+--------------------------+---------+
| Com_ha_open | 0 |
| Com_show_open_tables | 1 |
| Open_files | 156 |
| Open_streams | 0 |
| Open_table_definitions | 92 |
| Open_tables | 144 |
| Opened_files | 3238018 |
| Opened_table_definitions | 69010 |
| Opened_tables | 128226|
| Slave_open_temp_tables | 0 |
+--------------------------+---------+
10 rows in set (0.00 sec)
mysql> flush tables;
ERROR 1160 (08S01): Got an error writing communication packets
mysql> show global status like '%open%';
+--------------------------+---------+
| Variable_name | Value |
+--------------------------+---------+
| Com_ha_open | 0 |
| Com_show_open_tables | 1 |
| Open_files | 19 |
| Open_streams | 0 |
| Open_table_definitions | 11 |
| Open_tables | 11 |
| Opened_files | 3238040 |
| Opened_table_definitions | 69021 |
| Opened_tables | 128237|
| Slave_open_temp_tables | 0 |
+--------------------------+---------+
10 rows in set (0.00 sec)
这个怎么解决,哪位大神给点建议 http://dev.mysql.com/doc/refman/5.1/en/communication-errors.html
我之前遇到过查了一通发现是由于 wait_timeoutinteractive_timeout 这两个参数设置短了,调长以后偶尔还是有这个错误,但是明显少了很多...... see error.log
页:
[1]