Dean

It is the number of concurrent connections

They disappear either when they are closed by the application which has
opened them, or when wait_timeout expires for inactive connections

The wait_timeout is by default at 28800 seconds, so it will take quite a
long time before they disappear (didn't calculate the number of hours
though)

Freddie 

-----Ursprüngliche Nachricht-----
Von: Rochester, Dean [mailto:[EMAIL PROTECTED] 
Gesendet: Montag, 8. März 2004 15:14
An: '[EMAIL PROTECTED]'
Betreff: max used connections question

Does this number indicate the current number of connections or the max
number of connections during the current uptime?

We have this number max set to 200 from the default 100

how does this number go down during uptime?

It hovers around 30 - 40  but sometimes goes to 90

But it does not seem to go back down without restarting the mysql service

Dean-O



EMAIL CONFIDENTIALITY NOTICE
This Email message, and any attachments, may contain confidential patient
health information that is legally protected.  This information is intended
only for the use of the individual or entity named above.  
The authorized recipient of this information is prohibited from disclosing
this information to any other party unless required to do so by law or
regulation and is required to destroy the information after its stated need
has been fulfilled.  If you are not the intended recipient, you are hereby
notified that any disclosure, copying, distribution, or action taken in
reliance on the contents of this message is strictly prohibited. 
If you have received this information in error, please notify the sender
immediately by replying to this message and delete the message from your
system.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to