backup has not been created for more than a day, it freezes at the stage of copying the database. Through phpmyadmin and mysqldump, the databases are perfectly preserved, what could be the problem?
My database config, could this be the reason? I didn’t set up anything else, the panel and all its other functions work fine
[mysqld]
sql-mode=“NO_ENGINE_SUBSTITUTION”
tmpdir = /dev/shm
skip-external-locking
skip_name_resolve
skip-host-cache
skip-log-bin
skip-networking
skip-innodb_doublewrite
bind-address=localhost
max_connections = 60
symbolic-links=0
sync_binlog = 0
wait_timeout = 60
interactive_timeout = 5
performance_schema = ON
low-priority-updates = 1
table_open_cache = 32000
tmp_table_size = 200M
max_heap_table_size = 200M
max_allowed_packet = 64M
thread_cache_size = 60
innodb_file_format=Barracuda
innodb_flush_log_at_trx_commit = 0
innodb_flush_method = O_DIRECT_NO_FSYNC
innodb_buffer_pool_instances = 1
innodb_buffer_pool_size = 512M
innodb_log_file_size = 256M
innodb_file_per_table = 1
innodb_log_buffer_size = 256M
innodb_log_file_size = 192M
innodb_log_files_in_group=2
innodb_stats_on_metadata = 0
innodb_open_files = 65536
innodb_doublewrite = 0
#innodb_support_xa = 0
innodb_read_io_threads = 8
innodb_write_io_threads = 8
#innodb_io_capacity=6000
#innodb_io_capacity_max=10000
innodb_thread_concurrency = 4
innodb_checksum_algorithm=crc32
#innodb_log_checksum_algorithm=crc32
table_open_cache_instances = 4
log_error = /var/log/mysql_error.log
[mysqldump]
quick
quote-names
max_allowed_packet = 64M
default-character-set = utf8mb4
[mysql]
no-auto-rehash
default-character-set = utf8mb4