I'm using AWS RDS MySQL. All the tables are in
InnoDB and enable
One of my logging tables is growing too fast. I'd like to remove older than 1-week data. Even 1 week of data is 120GB. Every weekend this job will run and remove the old data.
I want to reclaim the disk space and update the statistics.
OPTIMIZE table is really painful for us.
What are the optimizations I should perform after deleting a huge number of records?