MySQL Forums
Forum List  »  Backup

Re: --single-transaction with --flush-logs cleans query cache
Posted by: Alberto José Díaz Caballero
Date: August 02, 2013 12:51AM

Scott Nemes Wrote:
-------------------------------------------------------
> I believe the --single-transaction option causes a
> "flush tables with read lock" command to be run to
> get the consistent dump, which does also flush the
> query cache.


Query cache is not flushed with --single-transaction alone,
but it is purged when --flush-logs is also included in the command.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: --single-transaction with --flush-logs cleans query cache
1148
August 02, 2013 12:51AM


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.