Re: Size of partition table space

[Rick James]

> Because this table is use only to insert rows, the data_free will always be free, and lost.
True for partitioned InnoDB tables. The "free" will be 4-7MB per partition.

Which rows do you need to DELETE? If you can arrange the PARTITIONs to be so that you can ALTER TABLE ... DROP PARTITION to do the DELETE, then all the space is returned to the OS. If the data is a "time series", and you need to delete data older than 30 days, then build 31 partitions, and have a daily script to DROP the oldest partition and create a new partition for tomorrow.

Some particular reason for using a "sequence" instead of AUTO_INCREMENT?

Also, you need innodb_file_per_table = 1 .