Timeline for MySQL LOAD DATA INFILE slows by 80% after a few gigs of input with InnoDB engine
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 23, 2017 at 12:40 | history | edited | CommunityBot |
replaced http://stackoverflow.com/ with https://stackoverflow.com/
|
|
| May 10, 2017 at 21:26 | vote | accept | David Parks | ||
| Apr 13, 2017 at 12:42 | history | edited | CommunityBot |
replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
|
|
| Jan 12, 2013 at 1:38 | comment | added | David Parks | The first 2 observations were things I tried to add on to fix the problem after I first noticed it, my first attempt was naturally to leave innodb alone (just turn off bin logging). On the 3rd observation, my data size is highly variable in length, I assume this will be a problem? I'm feeling like I just need to keep this table myisam. | |
| Jan 11, 2013 at 18:17 | history | answered | RolandoMySQLDBA | CC BY-SA 3.0 |