D
D
DragoN DragoN2017-07-04 05:23:58
linux
DragoN DragoN, 2017-07-04 05:23:58

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 question

Ask a Question

731 491 924 answers to any question