<%@ Page Title="" Async="true" Language="C#" MasterPageFile="~/masterPage1.Master" AutoEventWireup="true" CodeBehind="Benchmark.aspx.cs" Inherits="System.pages.Benchmark" %>

Benchmark

Performance test and comparison of Backup and Restore using MySqlBackup.NET, MySqlDump, and MySQL (instance).
Notes:
  • Running this test in the Visual Studio IDE debugging environment will slow down the process by 2-4 times.
  • For optimum speed, build this project with the [Release] profile and publish it to a folder. Use Windows IIS to run this ASP.NET app.
  • Executing mysqldump.exe and mysql.exe in ASP.NET:
    • Local Windows 10/11 IIS: Works with default ApplicationPoolIdentity (no privilege changes needed).
    • Shared Web Hosting: Executable restrictions prevent running mysql.exe and mysqldump.exe.
    • Self-owned Windows Server/VPS: May (may not) require granting file system permissions to ApplicationPoolIdentity or changing to a custom account with MySQL access.

Please manually enter the file path of the following instance:
Initial Schema
*This database is expected to have already been populated with rows of data.
MySqlDump
*The executable file path of mysqldump.exe
MySql
*The executable file path of mysql.exe
Output Folder
*Destination folder of exported dump files
Report File
*Full file path location for saving the report
Select mysql.exe Instance Execution Method:

Total round for each stage (min: 1, max: 3)
Get System Info
Run Stage 1: Backup/Export - MySqlBackup.NET - Single Thread
Run Stage 2: Backup/Export - MySqlBackup.NET - Parallel Processing
Run Stage 3: Backup/Export - MySqlDump.exe
Run Stage 4: Restore/Import - MySqlBackup.NET - Single Thread
Run Stage 5: Restore/Import - MySqlBackup.NET - Parallel Processing
Run Stage 6: Restore/Import - mysql.exe
Clean Up Database After Use
Delete dump file immediately after each process. Note: The first dump file must be kept for the import test