Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Hello is there a way to see concurrent connections on my server.

Server info: ubuntu server 11.10 apache2

99% of the site connects to mysql and it tells me the concurrent connections of MySQL can I go by that?

The reason I'm asking I'm thinking about switching from dedicated hosting back to cloud hosting with a load balancer. They charge per 100 concurrent connections.

Thank you.

I tried the mod status and got

   Server uptime: 3 minutes 11 seconds
   Total accesses: 41097 - Total Traffic: 24.0 MB
   CPU Usage: u331.39 s16.82 cu0 cs0 - 182% CPU load
   215 requests/sec - 128.5 kB/second - 611 B/request
   334 requests currently being processed, 248 idle workers
share|improve this question
add comment

1 Answer

Apache's mod_status can give you this information.

And no, don't go by the connections to MySQL; most applications utilize some kind of connection pooling which abstracts the connection from the request.

share|improve this answer
    
I got ` Server uptime: 3 minutes 11 seconds Total accesses: 41097 - Total Traffic: 24.0 MB CPU Usage: u331.39 s16.82 cu0 cs0 - 182% CPU load 215 requests/sec - 128.5 kB/second - 611 B/request 334 requests currently being processed, 248 idle workers` –  chiller Dec 14 '11 at 3:38
    
334 requests currently being processed is your answer. You'll probably want to keep an eye on peak hours to get a good idea of the number that you'll need to provision for. –  Shane Madden Dec 14 '11 at 3:40
    
That means that at the moment you have 334 open connections. –  devicenull Dec 14 '11 at 3:40
    
Thank you didn't know I had that many at once ehh will be costly. –  chiller Dec 14 '11 at 3:42
add comment

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.