MySQL Forums
Forum List  »  Partitioning

Re: Size of partition table space
Posted by: Rick James
Date: July 01, 2012 12:32PM

> 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 .

Options: ReplyQuote

Written By
June 29, 2012 02:46PM
Re: Size of partition table space
July 01, 2012 12:32PM
July 02, 2012 07:46AM
July 03, 2012 12:56PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.