RDS Database storage runs out of space

Question

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

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 ;  

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.

Please help.

Answer 1

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