Index before or after bulk load using load infile?
7
votes
2
answers
6203
views
I have a database with over 1B rows and two columns that are indexed (in addition to the PK).
Is it better to have the index pre-defined in the table before the load infile or better to index after the data has been loaded?
A couple of notes regarding data size and system:
- System is Linux w/ 8 cores and 32GB memory (currently maxed out
unless I move to new HW)
- DB is 1B rows that in raw data size is 150GB data.
- Database is MyISAM and is mainly read-only after it's loaded.
Asked by qman777
(71 rep)
Mar 24, 2013, 10:44 PM
Last activity: Nov 25, 2020, 07:19 AM
Last activity: Nov 25, 2020, 07:19 AM