MySQL Forums
Forum List  »  General

Re: Performing table inserts/selects while a alter-table query is running?
Posted by: Rick James
Date: May 13, 2010 10:20PM

Well, almost. There is a limit of 1023 partitions. But you could do something like
PARTITION BY HASH(sid) PARTITIONS 128
(Note on the current implementation of PARTITION: All partitions are opened even if you need only 1 for the operation in hand.)

And
PRIMARY KEY (`twid`,`sid`),
would probably be an excellent match for that partition. Not knowing what your SELECTs look like, I cannot say more.

But, in my opinion, PARTITION is often not as beneficial as one would hope.

Options: ReplyQuote




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.