AnswerBun.com

MySQL Shell dump utility - maximum possible chunk size?

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?

One Answer

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

Add your own answers!

Related Questions

SQL Server :: how to move country code column to another table?

1  Asked on January 9, 2021 by francesco-mantovani

       

MySQL nested groupby with count other field

0  Asked on January 8, 2021 by jayakusumah

     

GRANT ROLE TO USER in MySQL

1  Asked on January 3, 2021 by rj_n

       

Why BCP creates such big files?

1  Asked on January 1, 2021 by racer-sql

     

Table size and row count

1  Asked on December 31, 2020

 

Ask a Question

Get help from others!

© 2022 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP, SolveDir