concurrent users on mysql
lou.kamenov at aeye.net
Thu Oct 3 12:16:39 BST 2002
On Thu, 03 Oct 2002 11:30:03 +0100
Paul Civati <paul at xciv.org> tests=IN_REP_TO,AWL version=2.31 wrote:
> "Robin Garbutt" <rob at portfoliodesign.net> 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.
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:
> ------ FreeBSD UK Users' Group - Mailing List ------
Lou Kamenov lou at freebsd-bg.org lou.kamenov at aeye.net
FreeBSD BGUG http://www.freebsd-bg.org http://www.aeye.net
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