[mythtv-users] Slow MySQL query after delete

Jay R. Ashworth jra at baylink.com
Fri Sep 7 03:24:09 UTC 2007

On Thu, Sep 06, 2007 at 08:09:48PM -0700, crs23 wrote:
>    Jay R. Ashworth wrote:
>    Yeah, but it may not be enough to do all that *and* run the BUSQ. That's
>    *really* tight for RAM for MySQL, IMHO. I would have loved to know what
>    another 256 did to the time on that query; I'll bet you were swapping
>    somewhere...
>    I don't think so. See [1]this post which shows no swapping activity during
>    the query. This is prior to removing the duplicate recording entries.

I saw that, but I'm not entirely clear on whether vmstat lumps swapping
and paging.  I expect it probably does, though.

-- jra
Jay R. Ashworth                   Baylink                      jra at baylink.com
Designer                     The Things I Think                       RFC 2100
Ashworth & Associates     http://baylink.pitas.com                     '87 e24
St Petersburg FL USA      http://photo.imageinc.us             +1 727 647 1274

More information about the mythtv-users mailing list