MySQL Forums
Forum List  »  Backup

--single-transaction with --flush-logs cleans query cache
Posted by: Alberto José Díaz Caballero
Date: August 01, 2013 03:04AM


I recently enabled binary logs, so my dumps are now:

mysqldump --single-transaction --flush-logs mydb

The query cache becomes empty and I don't know why, since these options don't interfere query cache when not used at the same time.

Edited 1 time(s). Last edit at 08/01/2013 03:06AM by Alberto José Díaz Caballero.

Options: ReplyQuote

Written By
--single-transaction with --flush-logs cleans query cache
August 01, 2013 03:04AM

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.