Database issues
-
Do you have any advise on how to improve the simple query speed and bulk data import speed. Currently using MySQL 8.0 I follewed the suggestion you made but still getting low speeds.
Viewing 6 replies - 1 through 6 (of 6 total)
-
Here is a solution (posting here, so others can benefit from it).
If you are running MySQL8 on slow disks (e.g. SATA) and benchmarks are failing, most likely you need to add these configuration options to your MySQL config (/etc/my.cnf)
# default 100M innodb_redo_log_capacity=512M # default 16M innodb_log_buffer_size=512M # default 8kb innodb_log_write_ahead_size=128K # binlog is enabled by default disable_log_binThe biggest impact you will feel after adding “disable_log_bin”. Other options help a lot.
Important: the “innodb_redo_log_capacity” setting is only available from MySQL 8.0.30
As always for performance – suggest setting :
innodb_flush_log_at_trx_commit = 2
Viewing 6 replies - 1 through 6 (of 6 total)
The topic ‘Database issues’ is closed to new replies.
