Insert to InnoDB table stops after about 40,000 rows
Hi,
I have MySQL Enterprise version 8.11. I tried many times to insert data to a table but each time it stops inserting any rows after about 40,000 rows have been inserted. There are about 15,872,844 rows to insert.
I even tried disable keys, and set FOREIGN_KEY_CHECKS, UNIQUE_CHECKS, and AUTOCOMMIT = 0 before inserting data, but it still stops inserting any records after about 40,000 rows have been inserted.
Any help would be appreciated.
Thanks!
Subject
Views
Written By
Posted
Insert to InnoDB table stops after about 40,000 rows
2626
July 16, 2019 10:43AM
551
July 16, 2019 10:57AM
462
July 16, 2019 03:01PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.