MySQL Forums
Forum List  »  MyISAM

Re: MyISAM key buffer cache emptying
Posted by: Rick James
Date: July 26, 2014 03:22PM

Maybe FLUSH TABLES.
Maybe mysqldump -- or other dumping script.

MySQL will not flush the key_buffer other than as a result of something happening. (You already gave the example of 'restart'.)

> I fear that this creates performances issues

Well, if it does not really cause a performance issue, then don't worry about it. Do you have any application metrics that show a problem during the time when the key_buffer is refilling?

Do you monitor the slowlog? That would tell you which queries are being hurt the most. (But you would need to correlate it with time of day.) It may turn out that adding an index or reworking a query could provide more performance improvement than you have lost via the key_buffer.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MyISAM key buffer cache emptying
1380
July 26, 2014 03:22PM


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.