This repository has been archived by the owner on Apr 17, 2024. It is now read-only.

MySQL Additional Settings

Jump to bottom

darkalchemy edited this page Jan 9, 2019 · 3 revisions

These are some of the settings that I add to my mysql.cnf file:

innodb_lru_scan_depth = 256
innodb_buffer_pool_instances = 4
innodb_buffer_pool_size = 4G
innodb_read_io_threads = 64
innodb_write_io_threads = 64
innodb_flush_method = O_DIRECT
innodb_tmpdir = /dev/shm
tmpdir = /dev/shm/