thanks Sergey, but that command line only shows the total processlist, it doesn't show exactlly witch queries are happening on my tables besids my one that says 'show full processlist'.The others are sleep , but if they are really, why is my mysql server running severls processes with 11.5 Mgs or so? Do i need some kind of compilation option to show me more info on the processlist?
best regards, tsa On 04-Jun-2002 Sergey S. Kostyliov wrote: > On Tuesday 04 June 2002 15:07, [EMAIL PROTECTED] wrote: >> Hello all, >> >> Please can any one tell me how do i see all the queries in my mysql >> server in real-time? >> this is for checking witch ones are longer. > > `mysqladmin -v proc` > > Or (in mysql client) > mysql> SHOW PROCESSLIST; > >> regards >> tsa > -- > > Best regards, > Sergey S. Kostyliov <[EMAIL PROTECTED]> > Public PGP key: http://sysadminday.org.ru/rathamahata.asc > > --------------------------------------------------------------------- > 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 ---------------------------------- E-Mail: [EMAIL PROTECTED] Date: 04-Jun-2002 Time: 12:26:38 PGP Fingerprint = 5519 0CE9 2553 6877 A929 8270 91C0 D92D 4063 559E This message was sent by ME! ---------------------------------- --------------------------------------------------------------------- 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