UNLOCK TABLES
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Releases all table locks on all databases in the cluster.
After the locks are released, any previously blocked transactions resume.
Syntax
UNLOCK TABLES [ON db_name];
Arguments
-
db_
: name of the databasename
Remarks
-
This command causes implicit commits.
Refer to COMMIT for more information. -
Example
UNLOCK TABLES;
Related Topics
Last modified: January 9, 2023