[mythtv] mysql 5 bug affecting mythtv

[Daniel Kristjansson]

On Wed, 2008-01-30 at 14:57 -0600, kpyle at austin.rr.com wrote:
> On Jan 30, 2008 9:59 AM, David Backeberg <dbackeberg[at]gmail.com> wrote:
> > That's really incredible that you're having such trouble.
> >
> > I'm suspicious of your particular binary or version now. You didn't
> > mention your distro, but have you tried either a from-source build or
> > a binary package from somebody else? 
> 
> I should have noted that we're running a reasonably current Gentoo.  All of the builds have been from stable Gentoo package source, built by us.  The system stability was nearly flawless until going to mysql 5.0.44 (from 4.1).

Gentoo has some 'quirks' with respect to building mysql. In particular,
if you have the 'debug' USE flag set it will generate a completely
unusable mysql build; and the last time I checked it was configured
by default to fill your /var partition with multi-terabyte mysql db
replication logs. I recommend you build both mysql and mythtv without
ebuilds. Both these packages have ebuilds which encourage you to
shoot yourself in the foot.

-- Daniel