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 杨涛涛 <[email protected]> > 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: [email protected] > > > > 2010/11/24 Machiel Richards <[email protected]> > > > 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 > > >
