MYSQL [Warning] Aborted connection 42355 to db

最新推荐文章于 2025-06-04 23:57:48 发布

原创

最新推荐文章于 2025-06-04 23:57:48 发布 · 1.7w 阅读

4 ·

CC 4.0 BY-SA版权

这篇博客主要讨论了MySQL出现Aborted connection错误的问题，表现为日志中频繁出现Got timeout reading communication packets警告。博主提供了解决方案，包括在my.cnf中设置interactive_timeout和wait_timeout为120秒，并解释了这两个参数的作用。此外，还提到了Java连接池配置，特别是使用C3P0连接池来避免此类问题，以确保数据库连接的有效管理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1，问题现象：在/db/mysql/log/mysql.err日志中出现大量的如下信息(web用的是tomcat7.0，设置连接超时时间为100秒)：
[root@lovebuy114 ~]# tail -f /db/mysql/log/mysql.err
2015-04-17 09:35:47 24074 [Warning] Aborted connection 42355 to db: 'memberunion2' user: 'zhanghui' host: '172.16.151.112' (Got timeout reading communication packets)
2015-04-17 09:35:47 24074 [Warning] Aborted connection 42365 to db: 'memberunion2' user: 'zhanghui' host: '172.16.151.112' (Got timeout reading communication packets)
2015-04-17 09:35:47 24074 [Warning] Aborted connection 42366 to db: 'memberunion2' user: 'zhanghui' host: '172.16.151.112' (Got timeout reading communication packets)
2015-04-17 09:35:47 24074 [Warning] Aborted connection 42376 to db: 'memberunion2' user: 'zhanghui' host: '172.16.151.112' (Got timeout reading communication packets)
2015-04-17 09:35:47 24074 [Warning] Aborted connection 42367 to db: 'memberunion2' user: 'zhanghui' host: '172.16.151.112' (Got timeout reading communication packets)