truncate table in mysql 8.0 is slower than older version
Alas, DDL statements are slower in 8.0.  This is because they can now be inside transactions and rolled back.
If the goal is to start with a fresh set of empty tables for a new test, I am having trouble coming up with a faster way.  Perhaps something involving a &quot;Logical Volume&quot; (cf &quot;LVM&quot;).  (Note MySQL needs to be stopped throughout the steps below.)
Setup:

Establish a separate disk partition for the main directory tree for MySQL.
Clone it (LVM).  (This will be the master for a later step)

When starting a new test:

Drop the current logical volume
Clone the above clone to get a fresh set of empty tables

(Sorry, I don't have all the details.)