MySQL Shell dump utility - maximum possible chunk size?

Database Administrators Asked by Mihir Rane on December 10, 2020

The documentation 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:

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



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 All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP, SolveDir