MySQL Forums
Forum List  »  MyISAM

Re: myisamchk --sort-index
Posted by: Rick James
Date: January 16, 2014 11:15PM

> 10 indices

Rarely advisable to have so many. Do they each have one column? Or are some of them 'compound'?

It sounds like ID is an AUTO_INCREMENT?

> 400 columns

Consider using a JSON blob of all the fields that you don't need indexes or in WHERE clauses.


Are X and Y in a 1:1 relationship? Is this because you need more than 400 columns?

How many rows in one theYear?

Not much more I can say without: Please provide SHOW CREATE TABLE, some clues about how the data is loaded and updated, plus a sampling of the different SELECTs.

Options: ReplyQuote

Written By
January 14, 2014 09:00AM
January 15, 2014 11:41AM
January 16, 2014 02:58AM
Re: myisamchk --sort-index
January 16, 2014 11:15PM

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.