I have a dump with:
SET unique_checks=0;
SET foreign_key_checks=0;
SET autocommit=0;
I import it with mysql < file.sql
command and it takes a lot of time - I can't wait until it's finished.
It takes ~90 seconds to restore this dump on Hetzner machine with similar specs.
Ubuntu 16.04, default 5.7 mysql server, default performance settings.
How can it be solved or debugged?