opened_table status

--0-62377724-1281635686=:69192
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,
=A0
I have opened_table status is too high but i don't want increase the value =
of table_cache and also dont want to flush table because it will reset the =
query cache.=20
=A0
Now my question is how can i decrease the opened_table status ?
=A0
Thanks in advance
=A0
Jeetendra Ranjan
MySQL DBA
--0-62377724-1281635686=:69192--

RE: opened_table status

You don't need to flush tables, just increase the table_cache.

-----Original Message-----
From: jitendra ranjan [mailto:jitendra_ranjan@yahoo.com]
Sent: Thursday, August 12, 2010 10:55 AM
To: mysql@lists.mysql.com
Subject: opened_table status

Hi,

I have opened_table status is too high but i don't want increase the value =
of table_cache and also dont want to flush table because it will reset the =
query cache.

Now my question is how can i decrease the opened_table status ?

Thanks in advance

Jeetendra Ranjan
MySQL DBA


This message contains confidential information and is intended only for the=
individual named. If you are not the named addressee, you are notified th=
at reviewing, disseminating, disclosing, copying or distributing this e-mai=
l is strictly prohibited. Please notify the sender immediately by e-mail i=
f you have received this e-mail by mistake and delete this e-mail from your=
system. E-mail transmission cannot be guaranteed to be secure or error-fre=
e as information could be intercepted, corrupted, lost, destroyed, arrive l=
ate or incomplete, or contain viruses. The sender therefore does not accept=
liability for any loss or damage caused by viruses or errors or omissions =
in the contents of this message, which arise as a result of e-mail transmis=
sion. [FriendFinder Networks, Inc., 220 Humbolt court, Sunnyvale, CA 94089,=
USA, FriendFinder.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

RE: opened_table status

--0-1455436681-1281638553=:16052
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

As our file descriptor does not allow to increase the table_cache is there =
any other way to decrease the occurence of opened_table ?

--- On Fri, 13/8/10, Gavin Towey wrote:


From: Gavin Towey
Subject: RE: opened_table status
To: "jitendra ranjan" , "mysql@lists.mysql.com" =

Date: Friday, 13 August, 2010, 12:06 AM


You don't need to flush tables, just increase the table_cache.

-----Original Message-----
From: jitendra ranjan [mailto:jitendra_ranjan@yahoo.com]
Sent: Thursday, August 12, 2010 10:55 AM
To: mysql@lists.mysql.com
Subject: opened_table status

Hi,

I have opened_table status is too high but i don't want increase the value =
of table_cache and also dont want to flush table because it will reset the =
query cache.

Now my question is how can i decrease the opened_table status ?

Thanks in advance

Jeetendra Ranjan
MySQL DBA


This message contains confidential information and is intended only for the=
individual named.=A0 If you are not the named addressee, you are notified =
that reviewing, disseminating, disclosing, copying or distributing this e-m=
ail is strictly prohibited.=A0 Please notify the sender immediately by e-ma=
il if you have received this e-mail by mistake and delete this e-mail from =
your system. E-mail transmission cannot be guaranteed to be secure or error=
-free as information could be intercepted, corrupted, lost, destroyed, arri=
ve late or incomplete, or contain viruses. The sender therefore does not ac=
cept liability for any loss or damage caused by viruses or errors or omissi=
ons in the contents of this message, which arise as a result of e-mail tran=
smission. [FriendFinder Networks, Inc., 220 Humbolt court, Sunnyvale, CA 94=
089, USA, FriendFinder.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:=A0 =A0 http://lists.mysql.com/mysql?unsub=3Djitendra_ranjan=
@yahoo.com


--0-1455436681-1281638553=:16052--