Mailing List Archive: MySQL database optimisation settings

MySQL database optimisation settings

Apr 10, 2020, 5:30 PM

Post #1 of 3 (339 views)

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

Re: MySQL database optimisation settings [ In reply to ]

philledwards at gmail

Apr 15, 2020, 2:22 AM

Post #2 of 3 (318 views)

Permalink

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

Re: MySQL database optimisation settings [ In reply to ]

stephen_agent at jsw

Apr 15, 2020, 4:24 AM

Post #3 of 3 (315 views)

Permalink

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?
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org