赞
踩
生产报错
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引起的超时,经排查发现是有个千万数据的表没有加索引,最后加上索引即可(顺便把一下不必要的数据清除)
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。