At 13:50 -0500 3/10/04, Rochester, Dean wrote:
Does max used connections value ever go down? Or is this a high water mark
on the server... stating that since the server has been up, at one time you
had this many users connected at a given time.
It's a high water mark. It'll be reset to zero when you restart the
server, or when you issue a FLUSH STATUS statement or execute
mysqladmin flush-status.
-----Original Message-----
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 10, 2004 1:45 PM
To: Rochester, Dean; Rhino; MySQL (E-mail) (E-mail)
Subject: RE: what does show status 'questions' refer to?
At 13:35 -0500 3/10/04, Rochester, Dean wrote:
Thanks guys... I think questions does it. I just want to know how many
queries hit the database. I am getting ready to unleash our company
phonebook, with 10,000 plus listings and just want to make sure that it can
handle it. I have a jndi connection pool established and have the max used
connections set to 200. We are in testing mode and we set around 24 max
used connections all the time. Is the the current number of users on the
database when I did a show status or is that the top number of users on the
database at any given time? Like a max indicator since the database was
up.
I admit that I don't actually understand what you're asking here, because
you're referring to the SHOW STATUS statement, but referring to variables
with descriptive terms rather than the actual variable names. I will
guess that you mean Max_used_connections, which is the maximum number
of clients that have been simultaneously connected since the server started.
If you want the number that are connected *now*, then you want to look
at Threads_connected.
http://www.mysql.com/doc/en/SHOW_STATUS.html
What value should I change the default 28800 wait timeout to for
connections?
Why do you think you should change it?
Do these two values relate? Max Used Connections and Wait Timeout?
If I understand you correctly, no.
>Dean-O
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]