MySQL Forums
Forum List  »  Newbie

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

From the manual

The innodb_buffer_pool_size variable is dynamic, which permits resizing the buffer
pool while the server is online. However, the buffer pool size must be equal to or a multiple of
innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances, and changing either
of those variable settings requires restarting the server.

read the manual about optimization chapter 8 and all the variables that you've listed to get a further understanding. Using this forum as practice since its real world problems so take what i say with a grain of salt.

an example configuration

innodb_buffer_pool_size = 2gb
innodb_buffer_pool_chunk_size = 1gb
innodb_buffer_pool_instances= 2

You'll need to restart the server sorry about that jumped the gun lol.

Zach Ellis

Options: ReplyQuote

Written By
September 13, 2023 07:05AM
September 15, 2023 04:43PM
Re: How to optimize MySQL settings?
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.