[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