MySQL Forums
Forum List  »  Partitioning

Re: Is there a SWITCH equivalent in MySQL?
Posted by: Rick James
Date: December 24, 2010 10:48AM

First, let's make sure PARTITION will do anything useful for you. (Too many people jump into PARTITION, only to find that it does not really help in performance.) Please provide more information:
* SHOW CREATE TABLE (without partitions) -- The indexes are vital to performance of rapid inserts;
* State what kind of PARTITION ON you are thinking of;
* You say lots of inserts -- how _fast_ will the inserts come (rows per second);
* Can you "batch" the INSERTs? (multi-row INSERT or LOAD DATA)
* What are the SELECTs like?
* Is this a 'time series'? That is, will you be purging 'old' data?

DATE is a datatype that takes 3 bytes. INT takes 4.

Q1: Each partition has the same INDEXes.
Q2: Check the latest MySQL 5.5 version. (I don't know the answer.)

Options: ReplyQuote


Subject
Views
Written By
Posted
3859
December 22, 2010 02:27PM
Re: Is there a SWITCH equivalent in MySQL?
1412
December 24, 2010 10:48AM


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.