Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

To list active connections we do:

show processlist; 

What to do to list old closed connections?

share|improve this question
up vote 3 down vote accepted

if your logging is enabled you can check them - you'll see at what time who/from where connected and later - when give connection was closed. eg:

100822 10:07:43   53514 Connect     ocs@localhost on
                  53514 Init DB     ocsweb
                  53514 Query       SELECT ... FROM ...
                  53514 Quit
share|improve this answer
Thanks for your answer. How much can this affect the performance of mysqld? My version is 5.0.18 – mmonem Aug 22 '10 at 15:28
@mmonem - it's a performance hit for sure and besides cpu load - it puts additional pressure on io subsystem. i guess you should try and see... – pQd Aug 22 '10 at 21:23

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.