… * FROM table INTO OUTFILE ‘/tmp/tbl.txt’; DELETE FROM tbl; LOAD DATA INFILE ‘tmp/tbl.txt’ INTO TABLE tbl; UNLOCK TABLES; This will… reason and you proceed with deletion you may kiss your data goodbye. Alternative would be not to drop the table but rather….01 sec) mysql> create table rep_new like rep_maint; Query OK, 0 rows affected (0.00 sec) mysql> load data infile ‘/tmp/rep.txt…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… it write out a CSV file and import that with LOAD DATA INFILE. Keep those big fat log files out of the… MySQL 5.0 and earlier, doing the work on a slave, then piping the results back up to the master with LOAD DATA INFILE… of life.” Table scans can be better than the alternative, if the alternatives are limited, but they’re still not what you…
Comment: An argument for not using mysqldump
November 8, 2010 By 26 Comments
… two alternatives, one using mysqldump and one not. Option 1 (using …hosting company with 650+ databases (450+ GB) in one mysql instance. mysqldump databases one by one : 7 hours …Parallel Dump and Parallel Restore sugin SELECT INTO and LOAD DATA INFILE under the hood. http://www.maatkit.org/doc/mk…
