MyTop doesn't display executed queries

Posted by recluze on Server Fault See other posts from Server Fault or by recluze
Published on 2011-02-06T02:17:34Z Indexed on 2011/02/06 7:27 UTC
Read the original article Hit count: 536

Filed under:
|
|

Hi,

I'm trying to use mytop for figuring out what queries are being executed and how long they take. I can connect properly to the db but

MySQL on localhost (5.1.41-3ubuntu12.8)                 up 0+01:50:47 [09:30:43]
Queries: 3.0     qps:    0 Slow:     0.0         Se/In/Up/De(%):    68767/00/00/00

Key Efficiency: 99.1%  Bps in/out:   0.0/  1.2

        Id      User         Host/IP         DB      Time    Cmd Query or State
        --      ----         -------         --      ----    --- --------------
       225      root       localhost                    0  Query show full processlist
       186      joom       localhost   culinary      5684  Sleep

The number of queries increases over time but the queries themselves do not appear in the list. Is there some type of configuration that I need to do to enable it?

© Server Fault or respective owner

Related posts about mysql

Related posts about monitoring