rob_mazur <mazurr@gmail.com> wrote:

> I am having trouble finding the meaning of "opens: xxx" when I issue a
> "status" command at MySQL command line. It does not seem to be the
> same thing as Variable_Names "Open_files", or "Open_tables", etc, as I
> am not getting the same values.

This variable corresponds to the global (!) Opened_tables counter.
This number usually increases after a server restart until it reaches
a value around table_cache, then grows only slowly. If this number
increases fast, it could mean your table_cache is too small:

http://dev.mysql.com/doc/refman/5.0/...ld_table_cache

> I have a J2EE app that is slowing down after a day or so, after I
> moved it from MySQL 3.23.5x to 5.0.45. I noticed when the problem
> happens I see a parameter of [or as high as] opens:549 from my status
> command. If I shutdown/start MySQL, the problem goes away, and opens:
> parameter starts off again in the single digits....but starts
> gradually growing again.

I doubt there's correlation between this number and a general slowness
of MySQL. Of course restarting MySQL will reset this counter. But OTOH
549 is a rather low number (after a few days uptime). Problem could be
anything; not enough information to go on.


XL
--
Axel Schwenke, Support Engineer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/