Bug #116886 Allow the Shell Dump/Import utils be gentle regarding load and replication lag
Submitted: 5 Dec 2024 20:06 Modified: 6 Dec 2024 5:49
Reporter: Przemyslaw Malkowski Email Updates:
Status: Verified Impact on me:
None 
Category:Shell Dump & Load Severity:S4 (Feature request)
Version:8.0, 8.4 OS:Any
Assigned to: CPU Architecture:Any
Tags: dump, import, shell

[5 Dec 2024 20:06] Przemyslaw Malkowski 
Description:
Hi,
I think it would be a great improvement of these tools if you add an ability to automatically adjust the work depending on the server load and replication lag.

The simplest example way could be to monitor the Threads_running and pause dump/load task when above a given threshold. 
Similarly, monitor replication lag (or applier queue size in Group Replication) or cluster peers and pause data importing if needed. 
This extension would make the export and import operations much safer in production environments.

How to repeat:
Large data exports and imports can cause significant overhead and impact the production workloads.

Suggested fix:
Add options to pause operations when there is too much load and/or lag.
[6 Dec 2024 5:49] MySQL Verification Team 
Hello Przemyslaw,

Thank you for the reasonable feature request!

Thanks,
Umesh