[MDEV-32845] Improve DROP TABLE execution speed in Galera Cluster Created: 2023-11-20  Updated: 2023-12-04

Status: Open
Project: MariaDB Server
Component/s: Galera
Fix Version/s: 11.5

Type: Task Priority: Minor
Reporter: Seppo Jaakola Assignee: Daniele Sciascia
Resolution: Unresolved Votes: 0
Labels: None


 Description   

DROP TABLE is executed, by default, in Galera Cluster by Total Order replication (TOI) method. The TOI replication will hold total order commit monitor during the whole duration of DROP TABLE execution.
This could be improved by ending the TOI state as soon as DROP TABLE execution releases MDL locks, and leaving the later time consuming file delete operations to happen in background.

This approach requires that all operations happening after MDL lock releasing, must be successful. A potentially offending scenario would be if some other replicated (DML or DDL) statement or transaction would interfere with the DROP TABLE later stage file operations.


Generated at Thu Feb 08 10:34:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.