[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.
Cheers,
-- 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