Home » Tag: table-open-cache

MySQL file limit, table cache and max_connections

MySQL variables open_files_limit, table_open_cache and max_connections are inter-related, and this is for obvious reasons: all deal with file descriptors one way or another. If one of the value is provided but others are left out, mysqld calculates others using a formula and in some cases, emits a warning if not possible. The whole calculation behind Continue Reading

%d bloggers like this: