MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: Online Partition addition use "add partition" clause or "reorganize" clause?
Posted by: Rick James
Date: October 23, 2014 04:36PM

> --Can confirm that p_MAX partition no record

Yeah, sure. What will you do if there are records in that partition? It _will_ happen -- perhaps some day when the cron job fails to run because the machine was down briefly.

For that reason, I much prefer the REORGANIZE approach. And, when p_MAX is empty, the action will be essentially instantaneous, whether online or offline. So, don't worry about performance. (Frankly, I don't know whether it is online/offline; but I have used it before "online" was an option.) This was developed before "online" was an option:
http://mysql.rjweb.org/doc.php/partitionmaint

You have a lot of VARCHARs, and they are moderately big. Consider shrinking the table by normalizing suitable VARCHARs. Shrinking the disk footprint will significantly improve speed in some SELECTs.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Online Partition addition use "add partition" clause or "reorganize" clause?
3215
Tom Song
October 21, 2014 03:53AM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?
1566
Tom Song
October 22, 2014 11:58PM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?
1602
Rick James
October 23, 2014 04:36PM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?
1550
Tom Song
October 24, 2014 02:05AM
Re: Online Partition addition use "add partition" clause or "reorganize" clause?
1532
Mikael Ronström
November 13, 2014 06:54AM


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.