June 19, 2013

Post: Predicting how long data load would take

…dramatically. Table Size This is the worst trouble maker. Typically load starts fast but as it progresses it…and copy it back in a binary form. MySQL Configuration Different storage engines have different settings … For Innodb SET UNIQUE_CHECKS=0 may be used to speed up load to tables with unique keys…