Slow recovery of paip. mysql backup

Paip. mysql backup slow solution version 5.0.45-community-nt master database 50 W data, backup sql34M .. 5.8 m after compression original backup 178 S .. adjust MY. increase INI by 10 times... and 88S... if the data is not compressed, replace it with a 5.6 value in 45 s, and it will take more time to avoid going through Guangdong's slow blue .. 43s without compression... adjust MY. INI is increased by 10 times. 40S ..... the gap is not obvious .. final Solution: copy backup ---------------------------.. block. It takes 7 seconds .. it is a hot backup. don't shut down .. for more information, see .. ============================== the data file size is about 200 GB. After the backup (mysqldump) is compressed, the size is about 20 GB, the normal backup time is within 2 hours. Multiple mysql instances are installed on one server. One mysql database is divided into logical backup and physical backup by backup and recovery methods. Logical backup is a backup SQL statement, when restoring, execute the backup SQL statement to reproduce the database data. Physical backup is used to back up the data file. The comparison image is the data file under cp, however, the physical Backup recovery speed is faster, the occupied space is relatively large, and the logical backup speed is relatively slow, A relatively small footprint mysqldump tool backs up mysqldump because it is a built-in mysql backup tool, it is also the most commonly used mysql database backup tool. InnoDB-based hot backup is supported. However, because it is a logical backup, it is not very fast and suitable for scenarios where the backup data volume is small. Mysqldump full backup + binary log-> implement time point recovery. cfg default show VARIABLES like '% size %' When binlog_cache_size exceeds 1000host_cache_size when too many bytes exceed 3innodb_log_buffer_size when too many bytes too many bytes have been written into memory before 1024large_page_size too many bytes have been written into memory 100preload_buffer_size limit 15query_alloc_block_size limit 4096read_buffer_size limit 201716777216sort_buffer_size 262144thread_cache_size 9tmp_table_size 16777216transaction_alloc_block_size 8192transaction_prealloc_size 4096 increase 10 back ---------- log-error = d: /MySQL56/export thread_cache = 128 query_cache_type = 1 query_cache_size = 128 M bytes = 80 M sort_buffer_size = 20 M read_buffer_size = 20 M bytes = 20 M bytes = 128 M tmp_table_size = 128 M bytes = 12 M max_binlog_size = 512 M expire_logs_days = 3 # innodb_buffer_pool_size = 2G innodb_use_sys_malloc = 1 SQL _mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES