MySQL Forums
Forum List  »  MyISAM

Re: MyISAM key buffer cache emptying
Posted by: Sebastien Cantos
Date: July 29, 2014 03:43AM

Hi Rick,

thank you for your answer. I understand now why the cache is empying. We are processing backups around that times so it's definitively linked to FLUSH TABLES and/or mysql dump.
I'm not sure if this creates performances issues. This happens at night and the application is running bug batches jobs at the time to integrate lots of new data in the DB (lots of INSERT/UPDATE but also lots of SELECT as the integration process is dependend on already integrated data).
I'll try to run the batch job on a test server with a full filled cached and with an empty cache just to compare perfs.



Options: ReplyQuote

Written By
Re: MyISAM key buffer cache emptying
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.