开发者社区> 问答> 正文

MySQL终止连接


请教下这个日志有影响吗?
mysql 连接日志里面很多:
[Note] Aborted connection 226 to db: 'xxxxx' user: 'xxxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-11T14:58:45.682945Z 199 [Note] Aborted connection 199 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-11T14:58:45.683025Z 190 [Note] Aborted connection 190 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-11T14:58:45.685866Z 183 [Note] Aborted connection 183 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-11T14:58:45.693553Z 189 [Note] Aborted connection 189 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-11T14:58:45.694018Z 170 [Note] Aborted connection 170 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-11T14:58:45.694851Z 168 [Note] Aborted connection 168 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-11T14:58:45.694930Z 178 [Note] Aborted connection 178 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-11T14:58:45.695852Z 151 [Note] Aborted connection 151 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-11T14:58:45.724592Z 206 [Note] Aborted connection 206 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-11T14:58:45.724797Z 203 [Note] Aborted connection 203 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-11T14:58:45.724916Z 147 [Note] Aborted connection 147 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-11T14:58:45.726923Z 221 [Note] Aborted connection 221 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-11T14:58:45.813398Z 192 [Note] Aborted connection 192 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-11T14:58:45.894382Z 155 [Note] Aborted connection 155 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-11T20:12:02.469568Z 197 [Note] Aborted connection 197 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-11T20:12:02.650985Z 198 [Note] Aborted connection 198 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-11T20:12:02.848295Z 201 [Note] Aborted connection 201 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-11T20:12:02.929269Z 210 [Note] Aborted connection 210 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-11T20:12:03.460361Z 215 [Note] Aborted connection 215 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-11T20:12:11.922351Z 218 [Note] Aborted connection 218 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-11T20:12:12.143029Z 157 [Note] Aborted connection 157 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-11T20:12:12.254188Z 174 [Note] Aborted connection 174 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-12T15:51:40.927853Z 227 [Note] Aborted connection 227 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-12T15:51:41.036990Z 228 [Note] Aborted connection 228 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-12T15:51:42.719076Z 204 [Note] Aborted connection 204 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-12T15:51:42.850387Z 175 [Note] Aborted connection 175 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-12T15:51:43.138844Z 223 [Note] Aborted connection 223 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-12T15:51:43.172218Z 224 [Note] Aborted connection 224 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)
2016-03-13T23:17:54.290115Z 226 [Note] Aborted connection 226 to db: 'xxxxxxx' user: 'xxxxxxx' host: 'localhost' (Got timeout reading communication packets)









展开
收起
aston008 2016-03-20 18:06:52 10230 0
3 条回答
写回答
取消 提交回答
  • ReMySQL终止连接
    2017-02-04 11:38:16    2017-01-27 19:02:51 55509 [ERROR] /u01/mysql_20160720/bin/mysqld: Got an error reading communication packets
    2017-02-04 11:38:16    2017-01-27 19:02:51 55509 [ERROR] /u01/mysql_20160720/bin/mysqld: Got an error reading communication packets
    2017-02-04 11:38:16    2017-01-27 19:02:51 55509 [ERROR] /u01/mysql_20160720/bin/mysqld: Got an error reading communication packets
    2017-02-04 11:38:16    2017-01-27 19:02:51 55509 [ERROR] /u01/mysql_20160720/bin/mysqld: Got an error reading communication packets

    我们使用的RDS 5.6版的,这个错误每10分钟报一次,一次的数量好几百条,已经持续很长时间。经过参考相关信息修改后的参数如下:

    connect_timeout                       | 1000
    net_read_timeout                      | 30000    
    net_write_timeout                     | 30000
    wait_timeout                          | 86400
    max_allowed_packet | 1073741824
    观察报错依然存在,参数是一个一个修改观察的,以上参数是目前的最新参数,报错依然没有改变或停止。烦请各位给些处理意见。先谢谢了。
    2017-02-04 11:51:01
    赞同 展开评论 打赏
  • 旺旺:nectar2。
    楼主您好,

    好象是提示某个本地数据库用户连接哪个数据库出现了超时。

    请问,如果您的网站是使用了该数据库,这段时间站点运行正常吗?如是否会出现打不开网页的现象或报错?
    2016-03-20 18:28:27
    赞同 展开评论 打赏
  • 2016-03-20 18:10:46
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
搭建电商项目架构连接MySQL 立即下载
搭建4层电商项目架构,实战连接MySQL 立即下载
PolarDB MySQL引擎重磅功能及产品能力盛大发布 立即下载

相关镜像