OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: query not visible by sh processlist

From: Egor Egorov (egor.egorovensita.net)
Date: Fri Nov 14 2003 - 04:36:47 CST

Sohail Hasan <mysqletilizepak.com> wrote:
>
> Is there a possibility that a certain query that is executing in mysql
> by application is not visible by a "show processlist" command. As
> happened in my database a query was taking number of CPU cycles but when
> seen through the show processlist command nothing was displayed.
>

If the user dosn't have SUPER privilege he can see only his own threads.

--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __ ___ ___ ____ __
  / |/ /_ __/ __/ __ \/ / Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__ Egor.Egorovensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
       <___/ www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql