I have application generating 7-8 GB of data in to database(innodb), we delete old records from tables thinking it will reduce disk size but that is not true. even after continuous deletion tables size grow up to 300 GB and now we have disk size concern.
One option i found is to dump and restore table to compact table data, the big concern here is dump/restore took 10-15 hrs for a big table.
My questions are:
Is there any way to compact table size without downtime?
if there is no way to compact online tables then how I can manage such tables generating data exponentially?
What is reasonable size of a single table ( we already have a table crossing 400 GB mark )?