table_definition_cache is one of the many sizing hints used by PFS.
======= /* Add sizing hints from the server sizing parameters. */ pfs_param.m_hints.m_table_definition_cache= table_def_size; pfs_param.m_hints.m_table_open_cache= table_cache_size; pfs_param.m_hints.m_max_connections= max_connections; pfs_param.m_hints.m_open_files_limit= requested_open_files; ===========
With a large value for any of these, the server chooses a profile for PFS among small, medium or large:
https://github.com/mysql/mysql-server/blob/5.6/storage/perfschema/pfs_autosize.cc#L121 https://github.com/mysql/mysql-server/blob/5.6/storage/perfschema/pfs_autosize.cc#L175
table_definitio n_cache is one of the many sizing hints used by PFS.
=======
pfs_param. m_hints. m_table_ definition_ cache= table_def_size;
pfs_param. m_hints. m_table_ open_cache= table_cache_size;
pfs_param. m_hints. m_max_connectio ns= max_connections; m_hints. m_open_ files_limit= requested_ open_files;
/* Add sizing hints from the server sizing parameters. */
pfs_param.
===========
With a large value for any of these, the server chooses a profile for PFS among small, medium or large:
https:/ /github. com/mysql/ mysql-server/ blob/5. 6/storage/ perfschema/ pfs_autosize. cc#L121 /github. com/mysql/ mysql-server/ blob/5. 6/storage/ perfschema/ pfs_autosize. cc#L175
https:/