My MySQL import of 1.2GB files was taking 1hr 30min, after 1st tunring it took 50min and finally after 30hr searching, got the import to run in 10min....phew
innodb_buffer_pool_size=1024M
# Changed from 5M to 256M 1/4 of pool size
innodb_log_file_size=256M
# Kept the default 8M
innodb_log_buffer_size=8M
No comments:
Post a Comment