number of active connections?

[NearAway]

hello all ye in Mysql land!

I have a simple question which I think I know the answer to, but I'd like some verification, if you would be so kind..

Is there a way in mysql to see how many active connections to the db there is? Not the max connections available, just how many are currently active.

I've looked and didn't find anything so I'm thinking the answer is, unforunately, no. If that's the case, are there any utilities that can provide this number?

onward and upward..

Rick

 

[vanekl]

do a,

show status;

and look for 'threads_connected.'

 

[NearAway]

beautiful!! I'm very happy, thanks a bunch