[mythtv-users] mysql wont startup - just ran backup & optimize from MCC

[Stephen Worthington]

On Tue, 7 Feb 2017 20:11:27 +0000, you wrote:

>On 07/02/17 19:55, Phill Edwards wrote:
>>
>>
>> On 8 Feb 2017 02:55, "Mike Bibbings" <mike.bibbings at gmail.com 
>> <mailto:mike.bibbings at gmail.com>> wrote:
>>
>>     On 07/02/17 15:35, Douglas Sargent wrote:
>>
>>
>>     Have a look in /var/log/mysql/error.log, If it has something like
>>      [ERROR] unknown variable 'table_cache=128'
>>     This is preventing mysql  from starting.
>>
>>     I suspect you have a file named mythtv-tweaks.cnf in
>>     /etc/mysql/conf.d/
>>
>>     Edit this file and comment out (just put # at start of line) the line
>>     table_cache = 128
>>
>>
>> For future readers, why did that solve the problem? What's wrong with 
>> that line?
>table_cache=128 was deprecated a long time ago around mysql version 5.5, 
>mythbuntu  16.04 (and  orher *buntu variants)  now has mysql version 
>5.7. It was replaced with table_open_cache - I have never tested with 
>this, hence just commented out.
>
>Mike

Yes, table_open_cache should now be used instead of table_cache.  It
works in older versions of MySQL as well, ever since the original
change was made, so anyone reading this who has not changed it should
do it now, to avoid problems when they do get an upgraded version of
MySQL installed.