Mysqltuner: Difference between revisions

From DWIKI
(Created page with "=Links= =FAQ= ==name resolution is active : a reverse name resolution is made for each new connection and can reduce performance== Option '''skip-name-resolve'''")
 
mNo edit summary
(One intermediate revision by the same user not shown)
Line 1: Line 1:
=Links=
=Links=


=FAQ=


==name resolution is active : a reverse name resolution is made for each new connection and can reduce performance==
 
= FAQ =
 
== name resolution is active : a reverse name resolution is made for each new connection and can reduce performance ==
 
Option '''skip-name-resolve'''
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

Revision as of 10:44, 20 April 2021

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