Mysqltuner: Difference between revisions

From DWIKI
Line 21: Line 21:
Find the secret mysqltuner config or use
Find the secret mysqltuner config or use
  mysqltuner --user root
  mysqltuner --user root
or
mysqltuner --defaults-file ~/.my.cnf

Revision as of 14:20, 12 November 2022

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

Attempted to use login credentials from Debian maintenance account, but they failed.

Find the secret mysqltuner config or use

mysqltuner --user root

or

mysqltuner --defaults-file ~/.my.cnf