RDS数据库存储空间不足 [英] RDS Database storage runs out of space
本文介绍了RDS数据库存储空间不足的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我刚刚将我的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屋!
查看全文