Re: How to get fast Performance during Insert Large Volume of records into table

[Rick James]

There are several techniques. But first, please provide SHOW CREATE TABLE for the large table. Do the inserted rows have all the columns (except perhaps for an AUTO_INCREMENT?

If you have multiple indexes on the big table, please justify each index. The extra indexes may be the sole cause of the problem. In that case, we can look for ways to avoid the them, but still achieve the goals.

Some solutions might be in
http://mysql.rjweb.org/doc.php/datawarehouse
However, with the specifics, I can tailor my answer to what you have.

(For the non-Indian readers, that's 150M rows.)