MySQL Forums
Forum List  »  Partitioning

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

In your example, about 10% of the disk space is "wasted" by the "free" space. This is not that big a deal. And it is a small price to pay for what is probably a performance gain (by having the the free space already available).

Space is not the big deal in PARTITIONing; picking the right partition method for your application is.

I cannot imagine why having a particular number of rows in a partition would matter.

As for space taken before DELETEing, there is no much you can do.

Space recovery after a DELETE -- the best way is via DROP PARTITION, as I already mentioned. But that requires you to design the PARTITION method to match the DELETEs.

Options: ReplyQuote


Subject
Views
Written By
Posted
4834
June 29, 2012 02:46PM
1861
July 01, 2012 12:32PM
1643
July 02, 2012 07:46AM
Re: Size of partition table space
1709
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.