I had big problems synchronizing MySQL database from the staging and production servers to my laptop. It could take up to 15 minutes for an simple site, but by adding some simple tweaking to the local MySQL and ensure that all database were running InnoDB.
Add the configuration lines below to /etc/mysql/conf.d/innodb.cnf, if the file do not exists simply create it. The O_DIRECT did the trick for my SSD disk and the other options also increased the performance results.
Convert databases to InnoDB
I use http://www.maatkit.org/ to convert the database form for example MyISAM to InnoDB by running the command shown below. Update: it seems that meetkit has become part of https://launchpad.net/percona-toolkit.
mk-find <database_name> --ask-pass --user root --engine MyISAM --exec "ALTER TABLE %D.%N ENGINE=INNODB" --print