mysql - AWS - RDS - MySQL - 内存不足

Question

我正在运行具有以下设置的 MySQL 实例:
db.t2.micro
虚拟CPU 1
1 GB
20G
自由空间 19404.5546875
14 table
最大的表有大约 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 '''

AWS Metrics

Answer 1

您需要确定内存利用率的源和故障排除低freeable内存，查看以下链接:
here