Timeline for Time to import an sql dump
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 1, 2012 at 12:01 | comment | added | Benjamin Seiller | @Andrew: hehe, you're welcome - but wait thanking me any more till you recreate the index ;) | |
| Feb 1, 2012 at 10:26 | comment | added | Andrew | @BenjaminSeiller I dropped the indexes. I chose to not set indexes when creating the table and re-started the process of importing. Now it is already at the 3,000,000th row in just a few minutes. Last time it reached the same number of rows in 4-5 hours. So I can conclude that the indexes take a lot. Thank you Benjamin | |
| Jan 31, 2012 at 20:32 | comment | added | Derek Downey | +1 for offhanded comment about dropping indexes prior to insert. | |
| Jan 31, 2012 at 13:53 | vote | accept | Andrew | ||
| Jan 31, 2012 at 13:52 | history | migrated | from stackoverflow.com (revisions) | ||
| Jan 31, 2012 at 10:50 | comment | added | Benjamin Seiller |
concerning the file viewer: i asume you are using Windows? Have a look here superuser.com/questions/34749/… or here stackoverflow.com/questions/159521/…, otherwise (Linux) less will work like a charm.
|
|
| Jan 31, 2012 at 10:46 | comment | added | Benjamin Seiller |
first you need to open a new connection, you also could use MySql Workbench (mysql.com/products/workbench) now: SHOW INDEXES FROM tbl_name; gives you a list of all indexes on a table DROP INDEX index_name ON tbl_name removes an index
|
|
| Jan 31, 2012 at 9:10 | comment | added | Andrew | ok, it reached the point where one insert takes 60 seconds. How am I supposed to drop the index during the import in a 7gb large file? Do you know of any program that could open such a file? | |
| Jan 31, 2012 at 8:38 | history | answered | Benjamin Seiller | CC BY-SA 3.0 |