…, final import command: alter table order_line import tablespace; now some magic happens and you can see progress of import in error… 95 96 97 98 99 100 done. When finished quick check mysql> select count(*) from order_line; +———-+ | count(*) | +———-+ | 32093604 | +———-+ 1 row in…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
…million rows each. (InnoDB internally does operations such as ALTER TABLE in 10k row chunks, by the way; …one chunk: time mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load data…activity and rows-per-second to see what the progress was. Here are some graphs. This one is …
Post: Onsite and Remote - getting best of both worlds
July 2, 2009 By 1 Comment
…and asking the question about the progress. The Single Day visits are … (writing queries), hands on setting up MySQL, Replication, Monitoring, High Availability with …(or other) operations to complete – backup, restore, ALTER TABLE, load testing – all of …be the benefit in onsite status-checks and team…
