Java High-Performance Architecture

Jul 9, 2015 · Databases

How to Diagnose and Optimize MySQL Table Cache Using Open Tables Metrics

This guide explains the meaning of MySQL's Open_tables and Opened_tables status variables, shows how to check them, and provides recommended ratios and steps to adjust the table_cache setting for better database performance.