MySQL Bugs: #61742: MysqlBulkLoader Timeout for large txt files

Bug #61742	MysqlBulkLoader Timeout for large txt files
Submitted:	4 Jul 2011 18:58	Modified:	13 May 2017 9:55
Reporter:	Nogueira Jesus	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	Connector / NET	Severity:	S4 (Feature request)
Version:	Any	OS:	Windows
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	MysqlBulkLoader timeout large files

Description:
I have had some problems with the MysqlBulkloader when used in large files (over 50 MB in general), I usually separate the file into smaller pieces to make the bulkload. I've used the same feature of MSSQL, and there is one component in a resource that it is possible to reduce the size of the batch in X rows at a time. I think this is a feature that should exist in the connector, since reducing the batch, possibly eliminate the problem of timeout.

Well, I can keep reducing the file into smaller pieces, but it sucks, therefore I am contributing to this idea / bug report.

How to repeat:
Just try to use the mysqlbulkloader with any text file.

Suggested fix:
Insert the ability to adjust the size of the batch.

Hello Nogueira Jesus,

Thank you for the bug report.
I could not repeat the issue at our end using with Visual Studio 2017, Connector/NET 6.9.9 with more than 100MB text file.

Sample code for MySqlBulkLoader Class:
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-bulk-loader.html

Thanks,
Chiranjeevi.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".