Read lock all tables across all databases and make all other MemSQL connections block when they try to modify these tables.

Syntax

FLUSH TABLES WITH READ LOCK

Remarks

• FLUSH TABLES will lock and then flush all remaining write transactions in the current database to disk.
• You need to UNLOCK TABLES before you can modify or write to tables locked by this command in the current MemSQL database.
• This command must be run on the master aggregator node or a child aggregator node (see Node Requirements for MemSQL Commands ).

Example

memsql> FLUSH TABLES WITH READ LOCK;
Query OK, 0 rows affected (0.00 sec)

Related Topics

• UNLOCK TABLES

Was this Article Helpful?

Thanks For Your Feedback!