Re: How to enable index fast in MyISAM table
Posted by:
Gejun Shen
Date: March 25, 2014 08:39PM
Rick James Wrote:
-------------------------------------------------------
> timestamp/date/pruning: You are correct. My
> oversight.
> So, PARTITION BY RANGE(`timestamp`) may be the
> thing to do. But first, make sure that works in
> the version you have. The original PARTITION
> implementation was very limited in what you could
> partition on.
> Also, check for PARTITION BY
> RANGE(TO_DAY(`timestamp`)) -- I think this works
> for DATETIME, but might not work for TIMESTAMP.
I need a upgrade to have this capability.
> Sharding... It is tricky to do 'right'.
>
> Clustrix is a 3rd party setup that does it
> automatically.
> Spider might do it.
> I don't have an ETA for MySQL adding sharding.
Really thanks for your information. I agree sharding is a tricky thing to do.
I will try to have a look at this and see whether it's a good choice in my case.
Subject
Views
Written By
Posted
4603
March 04, 2014 07:26PM
2452
March 08, 2014 12:42PM
2673
March 13, 2014 10:49PM
2117
March 14, 2014 06:32PM
2104
March 17, 2014 01:38AM
2025
March 20, 2014 06:33PM
2268
March 22, 2014 07:23PM
1990
March 23, 2014 02:36PM
2041
March 24, 2014 12:16AM
2087
March 24, 2014 10:49PM
Re: How to enable index fast in MyISAM table
2143
March 25, 2014 08:39PM
2399
March 26, 2014 11:55AM
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.