[mythtv-users] Upgrade?

Stephen Worthington stephen_agent at jsw.gen.nz
Tue Dec 12 00:30:12 UTC 2017

On Mon, 11 Dec 2017 16:01:23 -0800, you wrote:

>On 12/11/2017 3:49 PM, Stephen Worthington wrote:
>> On Mon, 11 Dec 2017 15:23:43 -0600, you wrote:
>>> The upgrade process to 16.04 breaks mysql. You'll need to do a MySQL 5.5
>>> to 5.6 update first.
>>> Gerald
>> No, it does not break MySQL.  MySQL works just fine as do upgrades
>> from 5.5 to 5.6.  There is one setting in the /etc/mysql config files
>> which long ago had its name changed and needs to be renamed right now
>> by anyone who has not already done it.  It is likely to be present if
>> you used Mythbuntu Control Center to set up the database optimisation
>> settings.
>> So, right now, anyone who is reading this should check all the files
>> under /etc/mysql for all lines like this:
>> table_cache = 128
>> and rename that option to:
>> table_open_cache = 128
>> The table_cache name for that option was deprecated many versions of
>> MySQL ago, but Mythbuntu Control Center was never fixed.  In MySQL
>> 5.6, the old deprecated name has finally been removed and MySQL will
>> fail to start up until the name is fixed.  This problem has been
>> mentioned previously many times here on this mailing list and
>> elsewhere.
>> Mythbuntu Control Center itself is now no longer supported, so this
>> problem will never be fixed at that end.
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://lists.mythtv.org/mailman/listinfo/mythtv-users
>> http://wiki.mythtv.org/Mailing_List_etiquette
>> MythTV Forums: https://forum.mythtv.org
>My "/etc/mysql/my.cnf" file has "#table_cache = 64" in it.  Since it is 
>commented out, I am guessing it makes no difference if it is or is not 

Correct, but for safety I would change that commented out setting as
well, just in case you ever wanted to use it at some time and
uncommented it.

More information about the mythtv-users mailing list