[mythtvnz] In place upgrade of Mythbuntu 16.04.1

[Stephen Worthington]

On Mon, 1 Aug 2016 17:24:36 +1200, you wrote:

>On 01/08/16 15:08, Stephen Worthington wrote:
>> Best to enable the tweaks then.  They are needed if your database
>> grows.  Just edit the /etc/conf.d/mythtv-tweaks.cnf file and change
>> the table_cache line to table_open_cache.
>> 
>> And anyone reading this who is not yet on 16.04 should check their
>> tweaks file and make the same change NOW.  The syntax change happened
>> several years ago and the change should have been done then, but it
>> was not noticed and now the old syntax no longer works in MySQL 5.7.
>> Upgrading does not work well if mysql will not start after the
>> upgrade.
>
>Thank you.  But that file does not exist
>(/etc/conf.d/mythtv-tweaks.cnf).  Should I create it?
>
>Worik

No, you use Mythbuntu Control Centre to create it.  On its MySQL tab,
set the "Enable MySQL performance tweaks" option.  Then, as soon as
you have done that and before you restart MySQL, do the edit on the
table_cache option.

And while you are there, you really also should have the "Enable daily
MySQL Optimize/Repair cron job" option ticked.  Doing a daily check
and (if necessary) repair of the database is important to prevent
database corruption.  In all the cases of database corruption I have
seen posts about, there have been none that happened on machines doing
the daily check, except where there has been an obvious cause such as
a power failure while the database was being updated.  Without the
daily check and repair, it seems that corruption creeps into the
database unnoticed, until it gets bad enough to crash the database.
With the daily check and repair, errors in the database are fixed
before they can get to the point of causing a crash.