Operations that Take Database Level Locks
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.
The following operations take database level locks:
-
ALTER DATABASE
-
ALTER PIPELINE
-
ALTER TABLE
-
ALTER VIEW
-
BACKUP DATABASE
-
CREATE DATABASE
-
CREATE INDEX
-
CREATE PIPELINE
-
CREATE TABLE
-
CREATE VIEW
-
DROP DATABASE
-
DROP INDEX
-
DROP PIPELINE
-
DROP TABLE
-
DROP VIEW
-
REBALANCE PARTITIONS
-
RESTORE DATABASE
-
RESTORE REDUNDANCY
-
OPTIMIZE TABLE
(for rowstore tables only) -
TRUNCATE
Last modified: September 16, 2022