Answer the question
In order to leave comments, you need to log in
How to increment an InnoDB entry?
mysqltuner gives this:
[!!] InnoDB Write Log efficiency: 7.82% (33020 hits/ 422487 total)
What options depend on this and how can I increase the write?
The server is powerful, however, I think that this indicator depends on the fact that a permanent entry is made to the table - is it true?
my.ini
innodb_read_io_threads = 64
innodb_write_io_threads = 64
innodb_buffer_pool_size = 8G
innodb_buffer_pool_instances = 8
innodb_lock_wait_timeout = 60
innodb_log_file_size = 256M
innodb_log_files_in_group = 8
innodb_log_buffer_size = 16M
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question