My Oracle Support Banner

How to Limit MySQL Enterprise Backup's Impact on Active DB (Doc ID 2494959.1)

Last updated on MARCH 02, 2020

Applies to:

MySQL Enterprise Backup - Version 3.11 and later
Information in this document applies to any platform.

Goal

On any suitably large or active database , it can be the case where an MEB backup could impact the performance of the users.

There are many reasons for this, eg an application uses an especially "hot" table , or the DB is used 24.7 with no designated "quiet time" to take a backup.

 

Limiting the impact of an MEB backup may be desirable.

 

Example problem scenario

During a normal backup process, there are lag spikes being reported from the application side.

The current backup script may be:


 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
 Example problem scenario
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.