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]
