On Mon, Nov 18, 2002 at 03:59:15PM -0600, Robert Citek wrote:
> Is there a way to get information about current connection to a MySQL
> server? Specifically, I would like to know how many users are currently
> connected, who they are, from where, what databases are being used, etc.
> I've browsed and searched the mysql manual and found the SHOW STATUS
> command (http://www.mysql.com/doc/en/SHOW_STATUS.html). This is a good
> start, but does not have all the information I am looking for.
> Any URLs or other pointers would be greatly appreciated.
mytop -- http://jeremy.zawodny.com/mysql/mytop/
That's what I wrote it for.
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped> | http://jeremy.zawodny.com/
MySQL 3.23.51: up 104 days, processed 2,263,553,703 queries (250/sec. avg)