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!

Ask a Question

Get help from others!

© 2024 All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP