What is the best practise for MariaDB mysqldump configurations of large databases?
-1
votes
2
answers
968
views
## Problem ##
We have a large database (MariaDB 10.3) and
mysqldump
takes 2-3 hours to complete a full database dump, and it's also causing downgrade in application performance during the dump process.
## Attempt so far ##
After some research, we found out that the [mysqldump]
section can be added in the my.cnf
file. Also options like quick
, max_allowed_packet = 512M
can be added.
If we can add single-transaction
also along with the above settings, then the database will not be locked during the dump and it should speed up the application.
So are these entries appropriate for my.cnf
?
[mysqldump]
single-transaction
quick
max_allowed_packet = 512M
Asked by EternalSunShine
(99 rep)
Mar 30, 2021, 01:29 PM
Last activity: May 15, 2023, 11:56 AM
Last activity: May 15, 2023, 11:56 AM