[mythtv-users] MySQL database optimisation settings

[Stephen Worthington]

On Wed, 15 Apr 2020 19:22:35 +1000, you wrote:

>>
>> 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

Since I found this in my /etc/my.cnf file, I believe you are right
that it should be key_buffer_size:

# Obsolete key_buffer option renamed to key_buffer_size by maintainer
script
key_buffer_size          = 16M

>> 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.

Correct.  The table_cache option was still allowed for a long time
after it was changed to table_open_cache, but table_cache was
eventually removed.  And it was quite a while ago now.

>> 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?