[mythtv-users] anyone using percona instead of mysql (stock)?
tom at redpepperracing.com
Thu Dec 15 15:22:03 UTC 2011
On Thu, Dec 15, 2011 at 9:33 AM, Gavin Hurlbut <gjhurlbu at gmail.com> wrote:
> On Thu, Dec 15, 2011 at 6:26 AM, Brian J. Murrell <brian at interlinx.bc.ca> wrote:
>> I wonder if anyone is using Percona instead of the vanilla mysql for the
>> performance boost it's ExtraDB (InnoDB with performance enhancements)
> Have you even tried using InnoDB in mysql with MythTV yet? If not,
> I'd suggest that might be worth your time first. Using InnoDB
> requires some config tweaking that is not generally done by the distro
> (and definitely not by Ubuntu in my experience) that will make the
> difference between unusably slow and blazingly fast. Switching to
> percona will likely also require nearly identical config tweaking if
> you intend to use something InnoDB-based.
> I don't see any performance issues whatsoever with MySQL (stock) with
> appropriate configuration tweaks. And I'm using ext4 with barriers
> turned ON for the underlying filesystem. And my total database size
> is around 1GB. Part of it I have changed to InnoDB (all the big
> tables), and the remainder is MyISAM.
> Of course, most people are not capable of being a DBA in their spare time. :)
I haven't really investigated it too much myself, can you perhaps
speak to what you have tuned with InnoDB, or point me to the Wiki page
that I have obviously missed? :)
More information about the mythtv-users