Mysqltuner

From DWIKI
Revision as of 10:44, 20 April 2021 by Tony (talk | contribs)

Links

FAQ

name resolution is active : a reverse name resolution is made for each new connection and can reduce performance

Option skip-name-resolve

 

Table cache hit rate: 0%

hmm

innodb_log_file_size should be (=16M) if possible, so InnoDB total log files size equals to 25% of buffer pool size

That's current situation, so change log_file_size together with innodb_buffer_pool_size