RDS数据库存储空间不足 [英] RDS Database storage runs out of space

问题描述

我刚刚将我的RDS存储从10GB升级到20GB，几天后RDS说存储再次充满.

I just upgraded my RDS Storage from 10GB to 20GB and after a couple of days RDS says Storage full again.

在MySQL工作台中针对同一数据库运行此查询时，数据库大小为43MB

Running this query in MySQL workbench against the same DB says the DB size is 43MB

SELECT table_schema "database_name", 
sum( data_length + index_length ) / 1024 / 
1024 "Data Base Size in MB", 
sum( data_free )/ 1024 / 1024 "Free Space in MB" 
FROM information_schema.TABLES 
GROUP BY table_schema ;  

MySQL创建的日志或备份等是否有事发生，可能会填满我在生产服务器上的存储空间.

So is there something going on with the logs that MySQL creates or the backups etc that might fill up my storage space on the production servers.

请帮助.

推荐答案

它可能是占用大量空间的mysql.slow_log表.
您可以通过执行以下sql来删除慢速日志:

Its probably mysql.slow_log table which takes so much space.
You can remove slow logs by executing following sql:

CALL mysql.rds_rotate_slow_log

这篇关于RDS数据库存储空间不足的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！