Mustafa, > How i list connected users(active) to mysql server?
mysql> SHOW PROCESSLIST; +----+-----------+-----------+------+---------+-------+ | Id | User | Host | db | Command | Time | +----+-----------+-----------+------+---------+-------+ | 2 | superuser | localhost | test | Sleep | 20216 | | 3 | superuser | localhost | test | Query | 0 | +----+-----------+-----------+------+---------+-------+ > it is important to know connected users for me? Depends. If you're getting into trouble with something (too many connections error, running short of memory etc.) knowing how many users are connected can become important. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Mustafa Yelmer" <[EMAIL PROTECTED]> To: "mysql group" <[EMAIL PROTECTED]> Sent: Friday, January 31, 2003 12:49 PM Subject: # of connected user > How i list connected users(active) to mysql server? > > it is important to know connected users for me? > Mysql runs in server-client system, and each host of clients are different > (i assume) > > > Mustafa Yelmer > Software Engineer > +90 212 2128200-1228 > [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
