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.

> USING(ID)

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


Subject
Views
Written By
Posted
3221
January 14, 2014 09:00AM
2118
January 15, 2014 11:41AM
1961
January 16, 2014 02:58AM
Re: myisamchk --sort-index
1827
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.