[mythtv-users] MySQL database optimisation settings

[Phill Edwards]

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.

Regards,
Phill
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20200411/fe7dc624/attachment.htm>