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