[mythtv-users] Slow MySQL query after delete
gull at gull.us
Fri Sep 7 16:20:13 UTC 2007
On Sep 6, 2007, at 7:33 PM, 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 realize there are a lot of variables here, but I also have a 256
megabyte FE/BE system, and it performs just fine. Deletes usually
only take a few seconds. You're right that it's *very* tight on RAM,
though. I've also got more CPU speed than the original poster -- I'm
running a 1 GHz Nehemiah CPU.
I know I should upgrade it, but SDRAM DIMMs have gotten expensive,
and besides, I'm too lazy to disassemble the whole thing to get to
the DIMM slot. It's *very* tight inside that case. ;)
More information about the mythtv-users