Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Is there a way to improve performance? #71

Open
mubaid opened this issue Mar 13, 2021 · 3 comments
Open

Is there a way to improve performance? #71

mubaid opened this issue Mar 13, 2021 · 3 comments

Comments

@mubaid
Copy link

mubaid commented Mar 13, 2021

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.,

@adriancs2
Copy link
Member

I will definitely look into this

@adriancs2
Copy link
Member

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?

@mubaid
Copy link
Author

mubaid commented Sep 24, 2021

@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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants