MySQL recommends

С версии 3.13.09 добавлена команда mysql_rec которая постарается подобрать оптимальные значения для некоторых параметров MySQL
Пример результата выполнения команды:

#current: max_heap_table_size = 128M
max_heap_table_size = 1024M

#current: tmp_table_size = 16777216
tmp_table_size = 1024M

#current: innodb_doublewrite = ON
innodb_doublewrite = OFF

#current: innodb_flush_method = unbuffered
innodb_flush_method = O_DIRECT

#current: innodb_flush_neighbors = 1
innodb_flush_neighbors = 0

#current: innodb_flush_log_at_trx_commit = 1
innodb_flush_log_at_trx_commit = 2

#current: innodb_flush_log_at_timeout = 1
innodb_flush_log_at_timeout = 3

#current: innodb_read_io_threads = 4
innodb_read_io_threads = 16

#current: innodb_write_io_threads = 4
innodb_write_io_threads = 8

#current: innodb_io_capacity = 200
innodb_io_capacity = 5000

#current: innodb_io_capacity_max = 2000
innodb_io_capacity_max = 6000