MySQL Forums
Forum List  »  InnoDB

Insert to InnoDB table stops after about 40,000 rows
Posted by: Kourosh Ashkon
Date: July 16, 2019 10:43AM

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!

Options: ReplyQuote


Subject
Views
Written By
Posted
Insert to InnoDB table stops after about 40,000 rows
260
July 16, 2019 10:43AM


Sorry, only registered users may post in this forum.

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.