MySqlBackup.Net icon indicating copy to clipboard operation
MySqlBackup.Net copied to clipboard

Published 20 hours ago • verified publisher icon MySqlBackupNET

Is there a way to improve performance?

Open mubaid opened this issue 3 years ago • 3 comments

I have to schedule a nightly backup of the database, from a remote server. The internet bandwidth on the server is very good. But the total database size is 3.5 GB - the code is running for more than 2 hours to make the .sql file dump. The same with mysqldump.exe takes less than 15 mins. Is there any way to improve the performance? I am using the standard code taken from the wiki to backup the full database.,

mubaid avatar Mar 13 '21 17:03 mubaid

I will definitely look into this

adriancs2 avatar Mar 22 '21 03:03 adriancs2

Hi @mubaid , I have decided to run a benchmark test, here is the test result that I have produced: https://github.com/MySqlBackupNET/MySqlBackup.Net/wiki/Performance-Benchmark-(MySqlDump-vs-MySqlBackup)

About the environment that you're working on... are both MySqlDump.exe and MySqlBackup.NET runs on the same machine?

adriancs2 avatar Sep 24 '21 14:09 adriancs2

@adriancs2 Thanks for looking into this! Yes, I was running both mysqldump and mysqlbackup.net on the same machine. I haven't checked this in a while, I can spend some time and try to figure out if it's still the same?

mubaid avatar Sep 24 '21 15:09 mubaid