From: Michael Dykman
Date: July 12 2010 3:43pm
Subject: Re: finding exact query being run
List-Archive: http://lists.mysql.com/mysql/222161
Message-Id: <AANLkTikDTJmE1A1DRz30Im1RwMQlLPdkrJ72fUG3FlNt@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=0016361e8094d206e2048b329c4f

--0016361e8094d206e2048b329c4f
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

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>wrot=
e:

>  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 th=
at
> 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 =93sleep=94
>
>
>
>                 Not sure if this means anything....
>
>
>
> Machiel Richards
>
> MySQL DBA
>
> Relational Database Consulting
>
>
>
> [image: RDC_Logo]
>
>
>



--=20
 - michael dykman
 - mdykman@stripped

 May the Source be with you.

--0016361e8094d206e2048b329c4f--