Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.
Read lock all tables across all databases and make all other MemSQL connections block when they try to modify these tables.
FLUSH TABLES WITH READ LOCK
FLUSH TABLESwill lock and then flush all remaining write transactions in the current database to disk.
UNLOCK TABLESbefore you can modify or write to tables locked by this command in the current MemSQL database.
memsql> FLUSH TABLES WITH READ LOCK; Query OK, 0 rows affected (0.00 sec)