SingleStore Managed Service

Operations that Take Database Locks

The following operations take database locks:

  • ALTER DATABASE

  • ALTER TABLE

  • ALTER VIEW

  • BACKUP DATABASE

  • CREATE DATABASE

  • CREATE INDEX

  • CREATE TABLE

  • CREATE VIEW

  • DROP DATABASE

  • DROP INDEX

  • DROP TABLE

  • DROP VIEW

  • REBALANCE PARTITIONS

  • RESTORE DATABASE

  • RESTORE REDUNDANCY

  • OPTIMIZE TABLE (for rowstore tables only)

  • TRUNCATE