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

[Gavin Hurlbut]

On Thu, Dec 15, 2011 at 10:57 AM, Tom Lichti <tom at redpepperracing.com> wrote:
> I was asking about MythTV specific tuning, but if there is nothing
> specific to MythTV in what you did, then consider it moot.

For this conversation MythTV is just a database application.  When
tuning the database, you always need to take into account the behavior
of the application using it.  As in:  how big is the database (you
want it to primarily sit in RAM, and rarely need to touch disk)...
what the read/write ratio is...  things like that.  There is a nice
tool that can help with much of that that has been mentioned on this
list several times in the past, but what the heck....

wget mysqltuner.pl
chmod 755 mysqltuner.pl
./mysqltuner.pl

Enjoy.