MySQL Forums
Forum List  »  InnoDB

Re: innodb_buffer_pool_size MySQL Windows question
Posted by: John Miluzzo
Date: October 31, 2019 06:48PM

thanks - good reading

looked through and it was a little dated and not sure if the suggestions make sense.. I'm running mysql v8

here is my current config - from mysql worknech

looking to increase pool size to 1g

innodb_buffer_pool_chunk_size........... 8388608
innodb_buffer_pool_dump_at_shutdown..... ON
innodb_buffer_pool_dump_now............. OFF
innodb_buffer_pool_dump_pct............. 25
innodb_buffer_pool_filename............. ib_buffer_pool
innodb_buffer_pool_in_core_file......... ON
innodb_buffer_pool_instances............ 1
innodb_buffer_pool_load_abort........... OFF
innodb_buffer_pool_load_at_startup...... ON
innodb_buffer_pool_load_now............. OFF
innodb_buffer_pool_size................. 8388608

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: innodb_buffer_pool_size MySQL Windows question
20
October 31, 2019 06:48PM


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.