MYSQL官方是这么说的:
You can check if your table cache is too small by checking the mysqld variable Opened_tables. If this
value is high you should increase your table cache!我想知道怎样算Opened_tables算是高,有没有什么判断依据?
还有如果table cache设置的过大有没有什么坏处?
最好给出详细说明或参考的资料,谢谢
You can check if your table cache is too small by checking the mysqld variable Opened_tables. If this
value is high you should increase your table cache!我想知道怎样算Opened_tables算是高,有没有什么判断依据?
还有如果table cache设置的过大有没有什么坏处?
最好给出详细说明或参考的资料,谢谢
# increases the number of file descriptors that mysqld requires.
# Therefore you have to make sure to set the amount of open files
# allowed to at least 4096 in the variable "open-files-limit" in
# section [mysqld_safe]
table_cache=1024