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!
REPAIR
? Indexes are usually built on the fly. Repairing is only needed after a crash. – Rick James Oct 14 '19 at 23:47show processlist
) it will show you the query progress in these two phases that i have mentioned above – mghh Oct 15 '19 at 4:50