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]