MySQL Forums
Forum List  »  Docs

FLUSH TABLES - all databases?
Posted by: Caio James
Date: July 08, 2008 11:37AM


When executing a "FLUSH TABLES" query, does the query flush open tables on the entire server? Even if a database is selected?

The reason I am asking is because the documentation indicates that if no tables are specified in the FLUSH TABLES WITH READ LOCK query, then all of the tables on all of the databases are flushed and locked.

I'm curious is the behavior is the same for the FLUSH TABLES without the read lock... if FLUSH TABLES is executed with no tables specified, even if a database is specified previously with USE, does it flush all the open tables on a server?



Options: ReplyQuote

Written By
FLUSH TABLES - all databases?
July 08, 2008 11:37AM

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.