concurrent users on mysql

Lou Kamenov lou.kamenov at
Thu Oct 3 12:16:39 BST 2002

On Thu, 03 Oct 2002 11:30:03 +0100
Paul Civati <paul at> tests=IN_REP_TO,AWL version=2.31 wrote:

> "Robin Garbutt" <rob at> wrote:
> > is there a way to check the number of users currently on mysql
> > and apache?
> Web servers and databases really have connections rather than users?

connection-> apache -> apache`s stuff -> queries to the database :)
		^apache status			^mysqladmin status
> Certainly for web servers anyway.  I suppose you could say current
> users on a database in terms of client connections.

Um .. thats not hard.
apachectl status
apachectl fullstatus
in httpd.conf 
ExtendedStatus On
<Location /server-status>
SetHandler server-status
Order Allow, Deny
Allow from all			 # (you could change it if you want)

its not showing much;) however.

> For determining that I'm sure one of the MySQL command line utilities
> will give an overview of current client connections.  I stumbled upon

$ mysqladmin status (or extended-status)

> this tool yesterday which might be useful, a "top" for MySQL:
> -Paul-
> ------ FreeBSD UK Users' Group  -  Mailing List ------


Lou Kamenov	lou at		lou.kamenov at
GPG Key ID - 	0xA297084A
Key Fingerprint - 936F F64A AD50 2D27 07E7  6629 F493 95AE A297 084A
It`s a free ride when you`ve already paid.

More information about the Ukfreebsd mailing list