Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blog

[Dan Nelson]

In the last episode (May 23), LS said:
> Good idea! I set up this little loop in my bash shell to poll every
> second:
> 
> while (true) ; do ps axl | sed -n -e 1p -e /mysqld/p; sleep 1; done
> 
> Then I tried to replicate those slow queries and after a few minutes
> of trying, I got the slow query, but didn't see anything from the
> loop above. I thought maybe I just missed it, so I got the slow query
> to happen again, but still nothing from the ps loop. So perhaps it's
> not an I/O wait problem....

Didn't see anything at all?  That's not right.  Aha.  Try "ps axlc",
which will truncate the commandline to print the basename of argv[0]. 
You should see something like:

  UID   PID  PPID CPU PRI NI   VSZ  RSS MWCHAN STAT  TT       TIME COMMAND
   88   634   587   0  96  0 161428 69204 select S     d0-   1:42.54 mysqld

.. with one line per thread.


-- 
	Dan Nelson
	dnelson@stripped