[mythtv-users] Slow MySQL query after delete

Chris Pinkham cpinkham at bc2va.org
Mon Dec 10 00:31:47 UTC 2007


* On Thu Dec 06, 2007 at 11:04:53PM +0200, Axel Thimm wrote:
> On Mon, Dec 03, 2007 at 07:17:41PM -0800, Yeechang Lee wrote:
> > It is important to note that I have long run my own patched versions
> > of the ATrpms 0.20.x distribution. (I really ought to release my
> > patched src.rpm, with lots more patches--many backported from
> > 0.21--one of these days.) Patches relevant to the discussion are:
> 
> Does it make sense to use these patches in the ATrpms packages
> directly? And would you be willing to maintain them there? ;)

One thing that would probably not be approved of is the following
change in ThreadedFileWriter:

- const uint ThreadedFileWriter::TFW_DEF_BUF_SIZE   = 2*1024*1024;                                               
+ const uint ThreadedFileWriter::TFW_DEF_BUF_SIZE   = 128*1024*1024;                                             

So, for every tuner in a backend, your memory requirements just went up
by 126 Meg.  I'm not sure how this would affect the multi-rec version,
whether this buffer is allocated for every possible recording from a
tuner, I would think it would have to be since this is the code that
does the actual file writing.

> This is also a question to the devs, if they are reading this deep in
> the thread - would it be OK for ATrpms to get more backports from the
> trunk? I generally avoid it to keep as vanilla as possible, but maybe
> some good picks like Yeechang does are OK?

Not sure what others think, but I think this would have to be another
branch, like the different kernel branches that some people maintain.

You could have 0.20-fixes stock, 0.20-fixes-backports (or whatever it is
called), and trunk versions.  I've often considered creating my own
version of -fixes with some backports applied, but I barely have time to
keep working on my TODO list for trunk.  I understand that some people
want to see certain features in -fixes, but someone has to step up to
the plate to maintain such a backports version and it would probably not
be an official Myth blessed version unless it were one of the core
developers supporting it.  I can't comment for everyone, but since no one
else spoke up, I figured I'd put my $0.02 in.  That way I can finally
mark these two messages as old so I don't have to keep remembering to
reply to them. :)

--
Chris


More information about the mythtv-users mailing list