MySQL Forums
Forum List  »  Backup

Advanced Search
New Topic

Re: --single-transaction with --flush-logs cleans query cache
Posted by: Scott Nemes
Date: August 01, 2013 09:15AM

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.

--
Scott Nemes
MySQL DBA

http://www.linkedin.com/in/scottnemes
http://www.twitter.com/ScottNemes

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
--single-transaction with --flush-logs cleans query cache
1908
Alberto José Díaz Caballero
August 01, 2013 03:04AM
Re: --single-transaction with --flush-logs cleans query cache
1146
Scott Nemes
August 01, 2013 09:15AM
Re: --single-transaction with --flush-logs cleans query cache
1113
Alberto José Díaz Caballero
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.