major/MySQLTuner-perl

Recommendation on table_open_cache_instances

Open

#480 opened on Feb 4, 2020

View on GitHub
 (1 comment) (2 reactions) (1 assignee)Perl (9,452 stars) (1,293 forks)batch import
Help Wantedenhancement

Description

table_open_cache could be a source of contention as default value is 1 in mysql version prior to 7.

The recommended value is 0.5 per CPU to split work load across CPU and reduce locking issue on the table cache partition. Using a big value doesn't reduce performance. Mysql 7 have a default value at 16.

Contributor guide