Re: MyISAM key buffer cache emptying
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.
Subject
Views
Written By
Posted
2570
July 24, 2014 02:21AM
Re: MyISAM key buffer cache emptying
1462
July 26, 2014 03:22PM
1860
July 29, 2014 03:43AM
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.