MySQL Forums
Forum List  »  Partitioning

Re: 500 mil. rows table partitioning
Posted by: Misha Krassovski
Date: July 27, 2011 06:27AM

I can play with key_buffer_size and RAM when our new server will be in place.
So far I just reorganized the order of columns in CREATE INDEX according to your advice. Now it looks like: (`siteid`,`variableid`,`time`,`repeat`,`extensionid`,`offsetid`,`value`)
I don't quite understand about 'value'. Since it is not in WHERE does it have to be it in index?

Thank you,

Options: ReplyQuote

Written By
Re: 500 mil. rows table partitioning
July 27, 2011 06:27AM

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.