Monday 16 March 2020

Tuning MySQL on windows


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