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 regards. -- Wagner Bianchi
2010/12/22 杨涛涛 <david.y...@actionsky.com> > 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 <machi...@rdc.co.za> > > > 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 isn't being updated? > > > > The MySQL version is 5.051a > > > > regards > > Machiel > > >