Re: innodb_buffer_pool_size MySQL Windows question
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
Subject
Views
Written By
Posted
1641
October 31, 2019 03:55PM
601
October 31, 2019 04:45PM
Re: innodb_buffer_pool_size MySQL Windows question
652
October 31, 2019 06:48PM
509
October 31, 2019 08:24PM
534
April 01, 2020 08:19AM
489
April 01, 2020 08:36AM
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.