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

[Mike Bibbings]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20170207/d7f7396a/attachment.html>