I am loading a csv file into a mysql database table that uses MyISAM as storage engine. From the process list I can see that this is accomplished in two phases: 1) reading the csv file and 2) repairing the indexes by sorting. FYI, I have kept the indexing to enabled as it was by defult.
Although I am setting myisam_repair_threads to 2 I think mysql is not taking this into count as
show processlist shows only one entry in the process list. Also, it takes a little bit of time interval before starting repairing, why?
Please correct my understanding if I am wrong! Why mysql is repairing the tables with only one thread although I have set it to 2? Is there anything I am getting wrong about repairing strategy? TIA!