Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
up vote 0 down vote favorite

To list active connections we do:

show processlist;

What to do to list old closed connections?

share|improve this question

1 Answer

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

 
discard

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.