Hello,
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.
nginx.conf
worker_processes auto;
worker_connections 4096;
worker_rlimit_nofile 100000;
sendfile on;
keepalive_timeout 75;
CS CART version 4.9.2
@ini_set('memory_limit', '3072M');
@set_time_limit(3600);
php
memory_limit 3G
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.
[mysqld]
innodb_buffer_pool_size = 2G
tmp_table_size= 128M
max_heap_table_size= 512M
innodb_log_file_size = 512M
[mysqldump]
max_allowed_packet=1024M
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.
Thanks