Categories
Uncategorized

MySQL my.ini performance

The following configuration in the my.ini for MySQL provided me with very decent performance. Especially on Microsoft Windows 10 with MySQL 8.X

innodb_buffer_pool_size = 256M
innodb_log_file_size = 1G
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_thread_concurrency = 0
flush_time = 300
innodb_read_io_threads = 8
innodb_write_io_threads = 8

Leave a Reply