The table open cache
When a thread needs to access a table's physical file, a file descriptor is needed. To speed up the file access, MariaDB caches the file descriptors that are cached into the table open cache. This is even more useful if many MyISAM tables are contained in the same database. However, keep in mind that searching a file descriptor in this cache has a cost. If the cache cannot be big enough to contain all the needed descriptors, it could be better to disable it. A DBA may want to perform some tests to check whether table open cache is useful for a specific workload.
The table_open_cache server variable determines how many file descriptors are cached. This value should not exceed the maximum number of file descriptors allowed by ...
Get Mastering MariaDB now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
