MySQL Forums
Forum List  »  Performance

Re: Performance - Newbie
Posted by: Peter Brawley
Date: June 24, 2021 02:52PM

For starters ...

1 Assuming tables are InnoDB, set innodb_buffer_pool_size to about 75% of RAM available to MySQL

2 Optimise queries by running Explain on them and fine-tuning them such that they use indexes efficiently enough to avoid the need for full table scans

3 As data grows, run the Optimisation cheatsheet from and adjust accordingly

Options: ReplyQuote

Written By
June 24, 2021 02:17PM
Re: Performance - Newbie
June 24, 2021 02:52PM

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.