Afficher un message
Vieux 04/10/2007, 01h59   #1
rob_mazur
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Status and meaning of opens: parameter

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.

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.

Does this mean I have 549 live open connections via my connector/j
driver from my app? I haven't changed my app at all.....and I suppose
I need to find out what "opens:xxx" means, but am not finding it. All
docs that I Google or Dubois' MySQL book refer to all the other
"Open_xxxx" parameters.

Thanks for any ,
Rob

  Réponse avec citation
 
Page generated in 0,05606 seconds with 9 queries