[mythtv-users] High mysql cpu usage

Gary Buhrmaster gary.buhrmaster at gmail.com
Wed Jan 9 03:52:10 UTC 2013


On Tue, Jan 8, 2013 at 12:35 PM, Michael T. Dean
<mtdean at thirdcontact.com> wrote:
....
>  Other approaches may result in
> corrupt or broken database schema and/or data.

If you want to use unsupported (and unsupportable) alternatives,
look at the MythTV wiki regarding mysql innodb tuning:
  http://www.mythtv.org/wiki/Tune_MySQL
or for each table, issue the command:
  alter table <table_name> engine=myisam;

In all cases, backup, backup, and backup before
making any changes, and you are 100% on your
own with things go sideways.

Gary


More information about the mythtv-users mailing list