Database Administrators Asked by Mihir Rane on December 10, 2020
The documentation https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-dump-instance-schema.html mentions that the min chunk size is 128kB. What is the maximum possible chunk size?
The max value is innodb_buffer_pool_size / innodb_buffer_pool_instances
or some integral fraction of that.
But why bother changing the setting? It should not make much difference.
Reference, and more discussion: https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_buffer_pool_chunk_size
Correct answer by Rick James on December 10, 2020
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP