MySQL Forums
Forum List  »  Newbie

Re: How to optimize MySQL settings?
Posted by: Zach Ellis
Date: September 15, 2023 04:43PM

Hello Jason Long

I'm new to mysql so if someone more experienced comes go with them.

info from 8.12.3 Optimizing Memory Use

Typically, a
recommended innodb_buffer_pool_size value is 50 to 75 percent of system memory.

A buffer pool that is too small may cause excessive churning as pages are flushed from the buffer
pool only to be required again a short time later.

The manual says you can change it dynamically so you don't have to reset the server.

I would increase the buffer pool size to what is says in the manual so like 2 to 3 gigs that is if this server is a dedicated server for mysql.

Do you have other apps running on the server thats competing for memory with mysql server?

ill be reading into the other variables that you have listed but the innodb_buffer_pool_size is the one that sticks out to me.

Zach Ellis

Options: ReplyQuote

Written By
September 13, 2023 07:05AM
Re: How to optimize MySQL settings?
September 15, 2023 04:43PM
September 15, 2023 05:38PM

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.