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.)
Subject
Views
Written By
Posted
4551
December 22, 2010 02:27PM
Re: Is there a SWITCH equivalent in MySQL?
1615
December 24, 2010 10:48AM
1785
January 02, 2011 04:41PM
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.