[MDEV-24835] Database Performance tanks after mysqldump Created: 2021-02-10  Updated: 2021-04-25  Resolved: 2021-04-25

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.5.5
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Justin Reeves Davis Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback, performance
Environment:

Windows Server 2019


 Description   

Hi all

We have this problem on 2 separate installs.
MariaDB 5.x installed. Once the daily backup is done, the database is almost unusable.

We have TS environments and a DB server - mysql 5.1 running on the TS machines but we have two older sites doing the same and working perfectly.
MyISAM database.

Our batch file runs from one of the TS servers with the following command:
mysqldump -u root -p --databases DB1 DB2 > dumpname_date.sql

Please help friends, this has become extremely oppressive.

Thank you in advance

 Comments   
Comment by Elena Stepanova [ 2021-03-28 ]

JustinDavis,

"Almost unusable" and "performance tanks" doesn't provide any information for any analysis.

Please describe what exactly you observe, what stops working, what loss of performance happens, provide your config files, output from the processlist, dump from the running process if obtainable – all the basic typical admin stuff.

Generated at Thu Feb 08 09:33:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.