v.20.4Experimental Feature
Added Experimental Atomic Database Engine with Non-blocking Queries
Added experimental database engine Atomic. It supports non-blockingDROPandRENAME TABLEqueries and atomicEXCHANGE TABLES t1 AND t2query #7512 (tavplubix)
Why it matters
The Atomic engine addresses the issue of operation blocking during table schema changes by enabling non-blockingDROP and RENAME TABLE queries. Additionally, it allows atomic swapping of tables with the EXCHANGE TABLES command. This improves concurrency, reduces downtime, and enhances table management workflows.How to use it
To use the Atomic engine, specify it as the engine type when creating a database or table. The engine supports the non-blocking operations natively, so users can executeDROP, RENAME TABLE, and EXCHANGE TABLES t1 AND t2 commands without blocking other queries.