我已经把table_open_cache加到了800但还是不如人意,还应该往上加吗?
version:mysql-5.1.40
windows server 2003
max_connections=1000
engine=innodb
mysql> show global status like 'open%tables%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Open_tables | 60 |
| Opened_tables | 4560 |
+---------------+-------+
2 rows in set (0.00 sec)mysql> show variables like 'table_open_cache';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| table_open_cache | 800 |
+------------------+-------+
1 row in set (0.00 sec)
另外弱弱的问一下,Open_tables指的是当前打开表的数量,还是别的什么?
version:mysql-5.1.40
windows server 2003
max_connections=1000
engine=innodb
mysql> show global status like 'open%tables%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Open_tables | 60 |
| Opened_tables | 4560 |
+---------------+-------+
2 rows in set (0.00 sec)mysql> show variables like 'table_open_cache';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| table_open_cache | 800 |
+------------------+-------+
1 row in set (0.00 sec)
另外弱弱的问一下,Open_tables指的是当前打开表的数量,还是别的什么?
Open_tables / Opened_tables * 100% >= 85%
可惜我这达不到。table_open_cache设置的不理想。
--------------+--------
Open_tables | 496
Opened_tables | 2479798不过我一个month-end有超过1000万的记录更新