Re: KEY vs RANGE partitioning
Posted by:
Rick James
Date: February 09, 2012 04:22AM
SHOW CREATE TABLE
Sorted by popularity? Is that a column? Is it indexed? Does the value change?
How big is the table (SHOW TABLE STATUS)? If it is not at least 50MB, don't bother with PARTITIONing.
MyISAM or InnoDB?
> MySQL reads the various partitions in parallel
It does NOT!
> will help me scan 90% of the times only one partition of the table
That depends on the partition key you choose together with the WHERE clause in the SELECTs.
> I use RAID 10
That is good -- but totally independent of the PARTITION question.
Will you be having multiple connections at the same time? That is the only parallelism you can get (in general). RAID striping, PARTITIONs, multiple cores or cpus -- these are (mostly) useless for a single thread.
I see virtually no use for PARTITION types other than RANGE.
Subject
Views
Written By
Posted
3851
February 08, 2012 07:38AM
2164
February 09, 2012 07:35AM
1915
February 09, 2012 01:45AM
2242
February 09, 2012 10:50AM
Re: KEY vs RANGE partitioning
2056
February 09, 2012 04:22AM
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.