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 https://www.artfulsoftware.com/infotree/mysqltips.php and adjust accordingly

Options: ReplyQuote


Subject
Views
Written By
Posted
175
June 24, 2021 02:17PM
Re: Performance - Newbie
69
June 24, 2021 02:52PM


Sorry, only registered users may post in this forum.

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.