Re: Statistics bottleneck on large table
Posted by:
Rick James
Date: August 23, 2010 09:20PM
key_buffer_size of 1GB is more than enough to handle this table's entire index, which is only 53MB. So don't increase that.
The _data_ for MyISAM is cached in the left over space -- so the fact that you are using only 2GB out of 4GB is a good stopping point.
What was the "other issue"?
You are probably stuck with 11ms - 16ms for "statistics". You can't get any better than
| 1 | SIMPLE | test | const | PRIMARY | PRIMARY | 16 | const,const,const | 1 | |
Subject
Views
Written By
Posted
11799
August 21, 2010 01:15PM
3961
August 22, 2010 04:45PM
2945
August 23, 2010 06:31AM
2531
August 23, 2010 07:20AM
Re: Statistics bottleneck on large table
2386
August 23, 2010 09:20PM
2200
August 24, 2010 02:14AM
2209
August 25, 2010 12:12AM
2252
August 25, 2010 02:36AM
2398
August 25, 2010 08:54PM
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.