MySQL Forums
Forum List  »  MyISAM

Re: MyISAM key cache and open tables
Posted by: Ingo Strüwing
Date: April 28, 2005 02:00AM

Please repeat your questions concerning performance in the "Performance" forum.

Concerning the open index file, I do not right understand, what you mean. As long as key blocks of an index are in the cache, the file must be open for quick reload of key blocks and for flushes on write. A key block is flushed whenever it is changed.

Concerning the usage of the key buffer, I would like to know, how you evaluated your numbers. If by showing system variables, please paste them. But you may be better off to do this in the "Performance" forum as well.

Options: ReplyQuote


Subject
Views
Written By
Posted
5378
April 27, 2005 01:14PM
Re: MyISAM key cache and open tables
2678
April 28, 2005 02:00AM


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.