MySQL Forums
Forum List  »  Newbie

Re: innodb_buffer_pool_size=128M
Posted by: Zach Ellis
Date: October 23, 2023 11:58AM

Hello Donald,

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

From the manual under the innodb_buffer_pool_size system variable section and the other ones associated to it.

Buffer pool size must always be equal to or a multiple of innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances. If you alter the buffer pool size to a value that is not equal to or a multiple of innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances, buffer pool size is automatically adjusted to a value that is equal to or a multiple of innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances.

based on your ini files for the given variables its all the defaults so innodb_buffer_pool_chunk_size (i dont see it in the file so ill assume its using the default) and innodb_buffer_pool_size are both 128MB so the defaults are being used.

Default Value (Other) 8 (or 1 if innodb_buffer_pool_size < 1GB)

This option only takes effect when setting innodb_buffer_pool_size to 1GB or more. The total buffer pool size is divided among all the buffer pools. For best efficiency, specify a combination of innodb_buffer_pool_instances and innodb_buffer_pool_size so that each buffer pool instance is at least 1GB.

since the buffer pool size is not greater than 1GB this setting might not be being used so the buffer pool is not being divided so its just one pool.

You generally want your buffer pool using 50 to 80% of your systems memory if its a dedicated server that runs only mysql.

example settings of these three variables the numbers will change based on you servers specs.

what your server is running right now most likely

this setting the buffer pool is equal to innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances

this setting the buffer pool is a multiple to innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances if im getting the math right it would be a multiple of 2

if you have a version of mysql you could look into the innodb-dedicated-server which automatically configures the buffer pool.

what does you error log say about not restarting you might want to paste that so i or some one else can see it.

hopes this helps
Zach Ellis

Options: ReplyQuote

Written By
October 23, 2023 06:21AM
Re: innodb_buffer_pool_size=128M
October 23, 2023 11:58AM

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.