Re: Partitioning dilemma
> If i understand you correctly, MySQL is smart enough to cache only the most frequently used regions of the index. not whole index, correct?
True. Indexes are blocked -- 1KB? for MyISAM; 16KB for InnoDB. They are BTree structured. The necessary blocks are cached on roughly a LRU scheme.
Subject
Views
Written By
Posted
2978
July 20, 2010 08:51AM
1746
July 21, 2010 11:58AM
1597
July 21, 2010 01:47PM
1697
July 26, 2010 11:15PM
1542
July 27, 2010 09:02AM
Re: Partitioning dilemma
1590
July 27, 2010 08:06PM
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.