我正在使用以下设置运行MySQL实例:
db.t2.micro vCPU 1 1 GB 20G可用空间19404.5546875 14个表最大的表具有大约2000条记录,其余所有-3至10条记录
因此,这是最小的(用于测试),但直到昨天(2021-02-13)为止,它的运行状况都很好。
我确实在下面使用了一些内部连接,这是最多的一个。我以前能够运行它,但现在它只是超时,并使用了几个G来完成它。有什么建议?
'''Select U.sen_id,
U.dev_id,
U.sen_comment,
t1.tl_value as lat,
t2.tl_value as lon,
t3.tl_value as alt,
t4.tl_value as speed,
t5.tl_value as batv,
t5.tl_value as deg,
t1.time as times
From user_device U
INNER JOIN tracker_lat_lon t1 ON t1.sen_id = U.sen_id AND t1.tl_id = 1
INNER JOIN tracker_lat_lon t2 ON t2.sen_id = U.sen_id AND t2.tl_id = 2
INNER JOIN tracker_lat_lon t3 ON t3.sen_id = U.sen_id AND t3.tl_id = 3
INNER JOIN tracker_lat_lon t4 ON t4.sen_id = U.sen_id AND t4.tl_id = 4
INNER JOIN tracker_lat_lon t5 ON t5.sen_id = U.sen_id AND t5.tl_id = 5
INNER JOIN tracker_lat_lon t6 ON t6.sen_id = U.sen_id AND t6.tl_id = 6
Where t1.sen_id = (SELECT UD.sen_id
FROM user_device UD
WHERE UD.dev_id = 'xxxxxxxx')
ORDER BY t1.time DESC LIMIT 1 '''
您需要确定内存利用率的来源,并解决可用内存不足的问题,请检查以下链接:此处
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句