MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

open tables
Posted by: Jacky Shu
Date: March 30, 2006 09:09AM

How does mysql calcualte open_tables?
when I use "show status like 'open_tables'", I got 540.
But when I use "show open tables", it returned me 203?

Why are they different? or it is a bug that mysql calculate open_tables?

Thanks.

Jacky Shu

OCPDBA, MCDBA

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
open tables
1273
Jacky Shu
March 30, 2006 09:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.