MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

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!

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Insert to InnoDB table stops after about 40,000 rows
2632
Kourosh Ashkon
July 16, 2019 10:43AM
Re: Insert to InnoDB table stops after about 40,000 rows
552
Peter Brawley
July 16, 2019 10:57AM
Re: Insert to InnoDB table stops after about 40,000 rows
463
Kourosh Ashkon
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.