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