免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 6108 | 回复: 2
打印 上一主题 下一主题

Got timeout reading communication packets 错误还没解决! [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2008-06-22 20:19 |只看该作者 |倒序浏览
这几天我的服务器 还是出现这个错误。
平均 5分钟一个下面的错误。。。请各位帮忙。
080622 19:35:53 [Warning] Aborted connection 1088152 to db: 'dzbbs' user: 'dzmysql' host: '192.168.10.23' (Got timeout reading communication packets)

根据以前大家的方法,和官方的一个解释。已调整过下面:
interactive_timeout=400
wait_timeout=400
max_allowed_packet = 64M
tmp_table_size = 384M
sort_buffer_size = 16M
join_buffer_size = 32M
可仍人出现 这个错误。
080622 19:35:53 [Warning] Aborted connection 1088152 to db: 'dzbbs' user: 'dzmysql' host: '192.168.10.23' (Got timeout reading communication packets)
-----------------my.cnf--------------------------------------------
[client]
port            = 3306
socket          = /usr/local/mysql/mysql.sock

[mysqld]
port            = 3306
socket          = /usr/local/mysql/mysql.sock
datadir         = /usr/local/mysql
open_files_limit = 40960
interactive_timeout=400
wait_timeout=400
lower_case_table_names = 1

back_log = 500
skip-name-resolve

max_connections = 1024
max_connect_errors = 50
table_cache = 1280
max_allowed_packet = 64M
binlog_cache_size = 8M
max_heap_table_size = 128M
tmp_table_size = 384M
sort_buffer_size = 16M
join_buffer_size = 32M
thread_cache_size = 128
thread_concurrency = 8
query_cache_type = 1
query_cache_size = 512M
query_cache_limit = 128M
ft_min_word_len = 4
thread_stack = 192K
transaction_isolation = REPEATABLE-READ

log_long_format

log-bin        
server-id       = 23
binlog-do-db = dzbbs

binlog-ignore-db = mysql
relay-log
log-warnings
skip-slave-start

key_buffer_size = 24M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
bulk_insert_buffer_size = 64M
myisam_sort_buffer_size = 64M
myisam_max_sort_file_size = 10G
myisam_max_extra_sort_file_size = 10G
myisam_repair_threads = 1
myisam_recover

skip-bdb

innodb_additional_mem_pool_size = 100M
innodb_buffer_pool_size = 1G
innodb_data_file_path = ibdata1:1000M;ibdata2:1000M:autoextend
innodb_data_home_dir = /usr/local/mysql/
innodb_file_io_threads = 4
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 8M
innodb_log_file_size = 200M
innodb_log_files_in_group = 2
innodb_log_group_home_dir = /usr/local/mysql/
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 8M
write_buffer = 8M

[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 8M
write_buffer = 8M

[mysqlhotcopy]
interactive-timeout

论坛徽章:
1
双子座
日期:2013-08-19 14:56:16
2 [报告]
发表于 2008-06-22 21:20 |只看该作者
1158:网络错误,出现读错误,请检查网络连接状况

论坛徽章:
0
3 [报告]
发表于 2008-06-23 14:13 |只看该作者
原帖由 猪知猪之道 于 2008-6-22 21:20 发表
1158:网络错误,出现读错误,请检查网络连接状况



Yeah,this is because of poor network.
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP