Faster way to import?
Hi everyone,
I have been using MySQL for many many years now and one thing that has always frustrated me is how long it takes to import a database. For example, I just did a dump with MySQL Workbench from Amazon Aurora MySQL (took about 5min to export a 28GB database)...and I am now importing that database on my home lab (Intel 14700, 64GB DDR5, mirrored Samsung 970 Evo Plus nvme) and it's just sitting there going on 5.5 hours now, still isn't half way done.
Is there a faster way to import from a single dump file like this? I am all ears...
Thank you in advance!
--Cerusa
EDIT: I found that adding foreign_key_check=0, unique_checks=0, and autocommit=0... plus adding this to my docker container helped speed it up massively
--innodb_log_file_size=1G --innodb_flush_method=O_DIRECT --innodb_flush_log_at_trx_commit=2 --innodb_doublewrite=0 --innodb_autoinc_lock_mode=2