Accelerating the backup process for Mysql and MariaDB
When performing a backup, UpBack! can copy multiple files concurrently. This value sets the number of threads xtrabackup/mariabackup creates to copy data files.
To utilize this option, you must enable either the multiple tablespaces option (innodb_file_per_table) or store the shared tablespace in multiple ibdata files using the innodb_data_file_path option. Having multiple files for the database, or splitting one into many, does not significantly impact performance.
Since this feature operates at the file level, concurrent file transfer can sometimes enhance I/O throughput during backups of highly fragmented data files by overlapping a larger number of random read requests. Additionally, consider tuning the filesystem for optimal performance, such as by checking for fragmentation.