I am setting up a solution that will insert around 100 million rows in a table per month and every row will have a timestamp that will be indexed. The idea is to only store data regarding the last 3 months in this table, so the total row count will be approximately 300 million rows. Therefore every night an event will delete the rows that are older that 3 months.
I understand that the innodb files can never be reduced in size after deletes, but in this case will the innodb file size grow infinitely for every month when new data is inserted? Or will the new data replace the deleted data in the file storage?