MySQL Forums
Forum List  »  MyISAM

Re: how to make room in key buffer
Posted by: Aftab Khan
Date: December 08, 2009 09:05AM

Mysql server will take of this, as it uses LRU (Least Recently Used) strategy for choosing key cache blocks to be evicted but it also supports a more sophisticated method called the "midpoint insertion strategy." Before you consider playing around with 'midpoint insertion startegy', provide us output of the following command:

show global status like 'key%';

Options: ReplyQuote


Subject
Views
Written By
Posted
3886
December 01, 2009 04:05PM
Re: how to make room in key buffer
2136
December 08, 2009 09:05AM


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.