Timeline for Fastest way to copy data from MyISAM to InnoDB
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 20, 2012 at 7:51 | comment | added | Shlomi Noach | Cool. I don't think that you would save any time by adding keys at the end of creation on InnoDB. Even with InnoDB Plugin's fast index creation. | |
| Aug 19, 2012 at 22:46 | vote | accept | rlcabral | ||
| Aug 19, 2012 at 18:26 | comment | added | rlcabral | By the way, I think the main problem here is the unique keys. I managed to go around the timeout error and added the keys after loading 500,000 rows (only 3% of the total). It took 20 minutes to finish. | |
| Aug 19, 2012 at 18:19 | comment | added | rlcabral | For now I just want to have a 2nd table with a different schema and test if it runs better/faster than the old one. But I need the data to test it. If it proves to be better, I will have to do the same on at least 6 other databases. Some tables are bigger, others smaller. On this particular table, whether I convert to InnoDB or not, I will have to add a new column, which will be a hell of ALTER table. I'll try the tweaks you suggested. | |
| Aug 19, 2012 at 18:02 | history | answered | Shlomi Noach | CC BY-SA 3.0 |