Bug #51179 Application hangs while sending 1GB data using mysql_stmt_send_long_data()
Submitted: 15 Feb 2010 7:26 Modified: 17 Apr 2010 18:42
Reporter: Sandeep Shelke Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.1.31-enterprise-gpl-pro MySQL Ent. OS:Any
Assigned to: CPU Architecture:Any
Tags: mysql_stmt_send_long_data

[15 Feb 2010 7:26] Sandeep Shelke
Description:
My application inserts BLOB data into the table using mysql_stmt_send_long_data() function. The data size is 1GB. The application is in C using MySQL APIs.
For smaller BLOB data of 50MB, 100MB, 200MB it works. But as the size of data increases the time needed to complete the operation takes more than expected time.
I've the delay log generated which increases with the chunk number. Please find it in attachment

How to repeat:
Try to insert the BLOB data of 1GB using mysql_stmt_send_long_data() function.

Suggested fix:
Maybe the periodic dump into a file is needed on the server side.
[15 Feb 2010 7:30] Sandeep Shelke
The file contains (C)chunk number and (T)time taken to finish sending that chunk)

Attachment: delay_log.txt (text/plain), 181.31 KiB.

[17 Mar 2010 18:42] Sveta Smirnova
Thank you for the report.

Please provide example of code demonstrating how you use mysql_stmt_send_long_data
[17 Apr 2010 23:00] Bugs System
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".