A 250x improvement to tablespace truncation in MySQL Server 8.0.23
In MySQL Server 8.0.23 an improvement was made to InnoDB that allows truncation and deletion of all tablespaces to be faster. In fact, making it almost instantaneous as long as AHI is disabled. This is done by allowing pages in the buffer pool to be freed lazily instead of immediately when a tablespace is deleted.…
Source: A 250x improvement to tablespace truncation in MySQL Server 8.0.23
