AW: max used connections question

2004-03-08 Thread Freddie Sorensen
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]



max used connections question

2004-03-08 Thread Rochester, Dean
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]