[mythtv-users] MySQL database optimisation settings

Phill Edwards philledwards at gmail.com
Wed Apr 15 09:22:35 UTC 2020


>
> I'm running MySQL vsn 5.7.29. This morning I applied the MySQL database
> optimisation settings from
> https://www.mythtv.org/wiki/Optimizing_Performance#MySQL_Database_Tweaks and
> I think there my be a couple of errors in the wiki.
>
> 1) I think it should be key_buffer_size not key_buffer. MySQL won't start
> if you specify key_buffer.
>
> 2) It says the table_cache setting is deprecated in mysql 5.6.23. However,
> from what I've read it's possible to replace it with table_open_cache.
>
> Am I correct o these 2 points? If so I will try to update the wiki.
>
> Also, does anyone know if these recommended optimisations are still
> correct? They stem from a thread last updated in 2004.
>


Anyone care to comment on this?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20200415/e36bf89e/attachment.htm>


More information about the mythtv-users mailing list