MyTop doesn't display executed queries
- by recluze
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?