We recommend that you use Opened_tables to configure the Open_Table parameters for MySQL Performance Optimization. Opened_tables indicates the number of opened tables. The following describes the rational configuration of MySQL Open_Table.
MySQL Opened_tables indicates the number of opened tables. The following describes how to reasonably configure the value of MySQL Open_Table. it is helpful for you to learn about MySQL databases.
MySQL Open_Table:
The code is as follows:
Mysql> show global status like 'open % tables % ';
+ --------------- + ------- +
| Variable_name | Value |
+ --------------- + ------- +
| Open_tables | 919 |
| Opened_table | 1951 |
+ --------------- + ------- +
MySQL Open_tables indicates the number of opened tables. if the number of MySQL Opened_tables is too large, the value of table_cache in the configuration may be too small (table_open_cache after 5.1.3). let's query the value of table_cache on the server:
The code is as follows:
Mysql> show variables like 'Table _ cache ';
+ --------------- + ------- +
| Variable_name | Value |
+ --------------- + ------- +
| Table_cache | 2048 |
+ --------------- + ------- +
MySQL Open_Table has the following values:
The code is as follows:
Open_tables/Opened_tables * 100%> = 85%
Open_tables/table_cache * 100%