Re: How to enable index fast in MyISAM table

[Gejun Shen]

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.