Re: finding exact query being run

[Michael Dykman]

SHOW FULL RPOCESSLIST

will show you the full text of the running queries.

 - md

On Mon, Jul 12, 2010 at 11:39 AM, Machiel Richards <machielr@stripped>wrote:

>  Hi All
>
>
>
>                 I am trying to find out how to see the exact query being
> run.
>
>
>
>                 When running show processlit, I get a lot of processes that
> have been running for a VERY long time.
>
>
>
>                 I a trying to find out exactly what query it is that is
> being run , any ideas?
>
>
>
>                 I tried the slow query log but it is not showing up in
> there.
>
>
>
>                 All the queries are showing “sleep”
>
>
>
>                 Not sure if this means anything....
>
>
>
> Machiel Richards
>
> MySQL DBA
>
> Relational Database Consulting
>
>
>
> [image: RDC_Logo]
>
>
>



-- 
 - michael dykman
 - mdykman@stripped

 May the Source be with you.