Table cache not being updated

--=-HN7Fz9L07klFs9XdQO9P
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

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

--=-HN7Fz9L07klFs9XdQO9P--

Re: Table cache not being updated

--001636eef0654c18140497fc1fc5
Content-Type: text/plain; charset=UTF-8

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: yueliangdao0608@gmail.com



2010/11/24 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 isn't being updated?
>
> The MySQL version is 5.051a
>
> regards
> Machiel
>

--001636eef0654c18140497fc1fc5--

Re: Table cache not being updated

--001636c5b44727263b0497fef167
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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 杨涛æ¶=9B

> 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: yueliangdao0608@gmail.com
>
>
>
> 2010/11/24 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 isn't being updated?
> >
> > The MySQL version is 5.051a
> >
> > regards
> > Machiel
> >
>

--001636c5b44727263b0497fef167--

Re: Table cache not being updated

--20cf3054a7cfeaa7300498232866
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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: yueliangdao0608@gmail.com



2010/12/22 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 regards.
> --
> Wagner Bianchi
>
> 2010/12/22 杨涛æ¶=9B
>
> > 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: yueliangdao0608@gmail.com
> >
> >
> >
> > 2010/11/24 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 isn't being updated=
?
> > >
> > > The MySQL version is 5.051a
> > >
> > > regards
> > > Machiel
> > >
> >
>

--20cf3054a7cfeaa7300498232866--