MyDumper restoration performance regression with MariaDB 10.6

MyDumper has a performance regression when using the myloader restoration tool in MariaDB 10.6. This is because setting UNIQUE_CHECKS=0 in MariaDB 10.6 puts InnoDB into a special mode to increase performance for single threaded bulk inserts. Unfortunately this implements a table level lock which actually significantly reduces the performance of myloader.