Bug #78215 why mysql-utilities sepeate filed to normal and blob,and mysqldbcopy very slow

• Submitted: 26 Aug 2015 2:17
• Modified: 13 Oct 2016 10:10
• Reporter: zhan peng
• Status: Can't repeat
• Category: MySQL Utilities
• Severity: S3 (Non-critical)
• Version: Release-1.5.4
• OS: Any
• CPU Architecture: Any
• Tags: BLOB

[26 Aug 2015 2:17] zhan peng

Description:
when I mysqldbcopy a table contain 20w rows and one field's type is text.
mysqldbcopy will insert the data at first,it's very fast, only use 1 minute，
After that, It will spent 40 minutes to Update the 20w again for the text field.
So it's some way to fast the performance?

How to repeat:
a field is a text

[13 Oct 2016 10:10] Chiranjeevi Battula

Hello zhan peng,

Thank you for the bug report.
I could not repeat the issue at our end using with MySQL Utilities 1.6.4 version.

Thanks,
Chiranjeevi.