… with the export files SET GLOBAL innodb_import_table_from_xtrabackup = 1; ALTER TABLE data IMPORT TABLESPACE; After those being done i… 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84… 93 94 95 96 97 98 99 100 done. 120323 4:38:52 InnoDB: Error: page 0 log sequence number 6094071743825…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… | Query | 74 | Waiting for global read lock | insert into C values (“a”,1) | 0 | 0 | 1 | | 10304 … 0 | 4 | | 10305 | root | localhost | dumptest | Query | 0 | NULL | show processlist | 0 | 0 | 1 | …–no-lock option with Percona Xtrabackup. Many other tools have similar…
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
…xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 92684288 xtrabackup: Starting InnoDB instance for recovery. xtrabackup…datetime default NULL, `ol_quantity` tinyint(4) default NULL, `ol_amount` decimal(… 70 71 72 73 74 75 76 77 78 …
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
…_expand_import extension and with innodb_expand_import=1 setting) 4) run alter table IMPORTEDTABLE discard tablespace; 5) copy… 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 … to shutdown instance with innodb_fast_shutdown=1 (done in xtrabackup –prepare –export call). The more complex problem …
