During back up the process visually stops on cscart_orders. The back up itself is done correct but i takes 40 minimum (you can observe bytes changing on back up page). The db table is 2G.
Currently using VPS: 4core + 8G Ram+ 160SSD (Maria DB 10.3), running PHP 7.2.32, FPM served by nginx.
CS CART version 4.9.2
The site runs very fast, some 2.3 s/page load, But the only issue is Backup speed. When the database was 600M the process took some 3-4 minutes,
I tuned my.cnf a bit but did not notice big improvement.
innodb_buffer_pool_size = 2G
innodb_log_file_size = 512M
I also checked CPU load during backup process and it is not more than 18%
Any idea what is the problem and how to increase the backup speed? Need to reach 3-5 min max backup process time.