Mysqltuner: Difference between revisions
From DWIKI
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
=Links= | =Links= | ||
| Line 13: | Line 14: | ||
hmm | 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
