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 Wagner Bianchi <wagnerbianch...@gmail.com> > 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 > > > > > >
