[mythtv-users] anyone using percona instead of mysql (stock)?

[Daniel Kristjansson]

On Thu, 2011-12-15 at 19:13 +0000, Gary Buhrmaster wrote:
> Note that I have this vague recollection that one
> of the devs indicated that some of the current
> mythtv sql statements were using features that
> performed somewhat poorly on innodb, and that
> some work in that area was needed at some point
> (and is why the default create table statements
> would specify myisam now that mysql defaulted
> to innodb on some versions).

innodb has simply not been tested as well with MythTV, but
at least one dev volunteered to run with innodb after 0.24
was released and report back on any problems and I haven't
heard of any. AFAIK the only real problem is that innodb
isn't supported by all distros and we don't want two support
two database engines for the base tables.

I was for a time using innodb, and I believe all the problems
I ran into were due to very poor distro defaults. Even the
myisam defaults are pretty poor, which is why we've had DB
tuning documents for MythTV since before I started using
MythTV...

-- Daniel