Re: Suggestion About MySQL (5.7) Optimization
Posted by: Peter Brawley
Date: February 22, 2020 10:56AM

> 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

Options: ReplyQuote

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