Speed up mysql import on MacOS
If you have MySQL running from a brew install, here are some precious tips if you want to speed up imports. On this test, I managed to decrease ~30 minutes of import process. From 45 minutes to 13 minutes.
I got to those numbers running http://mysqltuner.com. It’s basically a perl script that reads your mysql config and shows an output with some metrics to change.
First, some commands to check your current
SHOW VARIABLES LIKE 'innodb_buffer_pool_size';
vim /usr/local/Cellar/[email protected]/5.6.36_1/my.cnf
# Speed up Imports: innodb_flush_log_at_trx_commit = 2 innodb_log_file_size = 500M innodb_buffer_pool_size = 3G
cd /usr/local/Cellar/[email protected]/5.6.36_1/bin/ ./mysql.server restart