hello everyone, i'm a newbie so please excuse the probably dumb question.
i'm using monitoring software to record the number of processes at a current time. currently, i'm just sending a show processlist and my monitoring software returns something like this: "0.06 sec, 4 rows, 1629, [user], [ip address], null, Sleep, 4028, , null" - basically, the round trip time, row count, and the first row values. what i would like to do is just return the number of rows from the show processlist. is there a select count(pid) something or other that i could do to make this happen. i realize i could probalby just do a remote command: mysqladmin --user=[] --password=[] processlist | find /c " " but i'd like to see if i can use a sql statement. anyone have any thoughts? thanks very much, in advance. chris --------------------------------------------------------------------- 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
