>>>>> "Michael" == Michael Drozdov <[EMAIL PROTECTED]> writes:

Michael> Where can I get description of parameters that mysql> show status  reports ?
Michael> (or mysqladmin ver).
Michael> I am particularly puzzled with 2 of them:
Michael> Opened_tables, which in my case is 4600 and goes up, and
Michael> Open_tables, which in my case is 63 and doesn't change.
Michael> (I have only 20 small tables tables.)

Hi!

Sorry, I haven't had time to document this yet.

Opened_tables tells how many times MySQL has to close and reopen
tables.   If this is increasing you should restart mysqld with a
bigger --table_cache parameter.

If two users uses the same table at the same time it's opened twice.

Regards,
Monty

-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.

Reply via email to