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
