The last packet successfully received from the server was 10,011 milliseconds ago. The last packet s

最新推荐文章于 2025-10-30 19:40:01 发布

原创最新推荐文章于 2025-10-30 19:40:01 发布 · 2k 阅读

10 ·

CC 4.0 BY-SA版权

文章标签：

#adb

文章讨论了在生产环境中遇到的数据库问题，涉及MySQL报错和通信中断，原因在于一个未加索引的千万级数据表导致的慢SQL。通过添加索引并清理不必要的数据，解决了超时问题。

生产报错
The last packet successfully received from the server was 10,011 milliseconds ago. The last packet sent successfully to the server was 10,011 milliseconds ago.; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

SELECT * FROM t_gps_pos_trace WHERE last_update_time >= ‘2023-12-25T18:30:25’ AND last_update_time <= ‘2024-01-02T09:15’ LIMIT 0,1000;

last_update_time没有加索引

是由于慢sql引起的超时，经排查发现是有个千万数据的表没有加索引，最后加上索引即可（顺便把一下不必要的数据清除）