MySQL Forums
Forum List  »  MyISAM

Re: How to enable index fast in MyISAM table
Posted by: Rick James
Date: March 24, 2014 10:49PM

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.

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.

Options: ReplyQuote

Written By
Re: How to enable index fast in MyISAM table
March 24, 2014 10:49PM

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.