xtrabackup: open files limit requested 20000, set to 10240 ... 220413 13:58:50 >> log scanned up to (6550086912) InnoDB: Operating system error number 24 in a file operation. InnoDB: Error number 24 means 'Too many open files' InnoDB: Some operating system error numbers are described at...
220705 23:37:54 >> log scanned up to (2778356) 220705 23:37:55 >> log scanned up to (2778356) 220705 23:37:56 >> log scanned up to (2778356) 220705 23:37:57 >> log scanned up to (2778356) 220705 23:37:58 >> log scanned up to (...
220512 16:48:05 >> log scanned up to (251672429294) 220512 16:48:06 >> log scanned up to (251675700622) 220512 16:48:07 >> log scanned up to (251678520383) 220512 16:48:08 >> log scanned up to (251681195105) 220512 16:48:09 [02] ...done 220512 16:48:09 >> log scanned up...
xtrabackup: innodb_log_files_in_group=3xtrabackup: innodb_log_file_size=67108864>> log scanned up to (1650488) [01] Copying /data/mysql/ibdata1 to /data/backup/2018-01-10_18-34-00/ibdata1 [01] ...done>> log scanned up to (1650488)18011018:34:08innobackupex: Continuing after ibbac...
>> log scanned up to (423918562)>> log scanned up to (423918562)[02] ...done[02] Copying ./mysql/slave_master_info.ibdto /data/backups/mysql/20150318/mysql/slave_master_info.ibd[02] ...done[02] Copying./mysql/slave_relay_log_info.ibd to/data/backups/mysql/20150318/mysql/slave_...
220419 09:55:02 Connecting to MySQL server host: 10.6.8.238, user: user0001, password: set, port: 3306, socket: not set xtrabackup: Redo Log Archiving is not set up. 220419 09:55:02 >> log scanned up to (18611669) xtrabackup: Generating a list of tablespaces ...
xtrabackup: open files limit requested 20000, set to 10240 ... 220413 13:58:50 >> log scanned up to (6550086912) InnoDB: Operating system error number 24 in a file operation. InnoDB: Error number 24 means 'Too many open files'
一堆log scanned up to 150825 06:55:44innobackupex: All tables locked and flushed to disk 150825 06:55:44 innobackupex: Starting to backup non-InnoDB tables and files 。。。 150825 06:55:57innobackupex: All tables unlocked 很明显,xtrabackup在执行"FLUSH TABLES WITH READ LOCK"的时候被阻塞了,...
lock_tables_ftwrl->先设置waitlocktimeout 时间为最大时间SETSESSIONlock_wait_timeout=31536000->如果没有设置ftwrl-wait-timeout和kill-long-queries-timeout->打印日志ExecutingFLUSHNO_WRITE_TO_BINLOGTABLES...->直接发起FTWRL,也就是不管当前是否有长查询执行->如果设置ftwrl-wait-timeout->wait_for_no_upda...
innobakupex命令的–apply-log选项可用于实现上述功能。如下面的命令: # innobackupex --apply-log /path/to/BACKUP-DIR 如果执行正确,其最后输出的几行信息通常如下: xtrabackup:starting shutdownwithinnodb_fast_shutdown=11204079:01:36InnoDB:Starting shutdown...1204079:01:40InnoDB:Shutdown completed;log seq...