List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:May 24 2003 5:56am
Subject:Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blog
View as plain text  
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
Thread
Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blogLS24 May
  • Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blogDan Nelson24 May
    • Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blogLS24 May
      • Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blogDan Nelson24 May
        • Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blogcolbey24 May
        • Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blogLS24 May
          • Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blogDan Nelson24 May
  • Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blogEgor Egorov24 May
    • Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blogDan Nelson24 May
      • Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blogJeremy Zawodny25 May
        • Re: Slow queries on 4.0.13, FreeBSD 4.8 STABLE, linuxthreads, zawodny blogLS25 May