processlist
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. regards tsa -- E-Mail: [EMAIL PROTECTED] Date: 04-Jun-2002 Time: 12:04:29 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
Re: processlist
thanks David, i have allready seen that but what is exactlly them command line to do so? EX: the select queries or the update ones in all databases or in just in one. regards tsa On 04-Jun-2002 David BORDAS wrote: Hi, Just connect to mysql and use this query : show processlit; http://www.mysql.com/doc/S/H/SHOW_PROCESSLIST.html You can also use slow query logs. http://www.mysql.com/doc/S/l/Slow_query_log.html David - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 1:07 PM Subject: processlist 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. regards tsa -- E-Mail: [EMAIL PROTECTED] Date: 04-Jun-2002 Time: 12:04:29 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 -- E-Mail: [EMAIL PROTECTED] Date: 04-Jun-2002 Time: 12:20:56 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
Re: processlist
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