Using MySql and innodb with
innodb_file_per_table
flag ON.
- We have a table with a size of ~100GB.
We delete the data and insert fresh data (approx same size) every day (the delete is in chunks by a key, when this key task is fetch fresh data).
- We see that there is no reuse, the table size is increasing with ~100GB every day.
- As far as we know mysql should reuse deleted space (same table).
- We do not want to reclaim the space, just to have the reuse on the same table working...
What could cause this behavior?
We cannot optimize the table every single day.
(similar to https://dba.stackexchange.com/questions/162632/does-mysql-use-deleted-rows-space-in-a-table)
Asked by Amichay Miara
(1 rep)
Jul 11, 2024, 01:03 PM
Last activity: Jul 18, 2024, 01:16 AM
Last activity: Jul 18, 2024, 01:16 AM