I dumped all my databases in order to import them into a slave.
mysqldump --all-databases > dump.sql
The import seems to be very very slow. Checking the processlist, I saw a simple insert on a 20 rows table that took 400+seconds.
I had to ignore some big and not critical tables from the dump in order to import in a reasonable time.
I don't understand if I'm doing something wrong, the whole dump was about 800MB and the "big" table I ignored was no more than 170K records, which I don't think it's big at all...
Also I often dump a single database to load it on a testing environment, usually without problem. It seems the --all-databases dump is very slow.
Any suggestion welcome.