Re: Table cache not being updated

2010-12-23 Thread 杨涛涛
Yeah, Just entering the mysql command line client, typing the keyword 'status' , you'll get the absolute value. David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http://yueliangdao0608.blog.51cto.com My Msn: yueliangdao0...@gmail.com 2010/12/22 Wagn

Re: Table cache not being updated

2010-12-22 Thread Wagner Bianchi
The response of table_cahe's new values is not imedite. MySQL cache engine will putting new objects in cache on demand intead of to replace them. Configure new table_cahe value at my.cnf or your configuration file, restart mysqld e going on monitoring. Let time pass and see what happen. Best regard

Re: Table cache not being updated

2010-12-22 Thread 杨涛涛
How did you adjust this variable? Stay it in my.cnf or just set it? David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http://yueliangdao0608.blog.51cto.com My Msn: yueliangdao0...@gmail.com 2010/11/24 Machiel Richards > Hi All > > Maybe someone

Table cache not being updated

2010-11-23 Thread Machiel Richards
Hi All Maybe someone can help me with this one. We have set the table_cache to 1024, however the open tables value stays 64 of 64. Everything I checked stated that the open tables is related to the table_cache variable. Can someone please assist on why the value i