Re: Suggestion About MySQL (5.7) Optimization
> There is no code block in this editor. :/
Use BBCode code tags.
> We will suggest raising the 'join_buffer_size' until JOINs not using indexes are found.
Turn on the slow query log, for queries that it finds develop covering indexes
> [--] Physical Memory : 2.0G
> [--] Max MySQL memory : 6.0G
Max needs to be <= available RAM
> query_cache_size (> 50M)
Do not do this, it's deprecated in 5.7, removed in 8.0
Subject
Written By
Posted
February 01, 2020 12:50PM
Re: Suggestion About MySQL (5.7) Optimization
February 22, 2020 10:56AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.