I tested quick and dirty
--no-autocommit vs. without this option on MacBook (installed with Homebrew latest MariaDB). I restored to an empty MariaDB a 4.6 GB *.sql file. The dump made without
--no-autocommit took 5m42.072s to restore and with
--no-autocommit it took 1 minute longer.
Other options used for dump are
--max_allowed_packet=1G --flush-logs --single-transaction --all-databases
set autocommit=0; INSERT INTO ... UNLOCK TABLES; commit;
When to use
--no-autocommit? In what use case this option makes sense?