Bug #99575 | insert into t (c1,...) values(%s,...) as v on duplicate key update c1=v.c1 slow | ||
---|---|---|---|
Submitted: | 14 May 2020 15:26 | Modified: | 9 Feb 2023 20:02 |
Reporter: | Julian Briggs | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | Connector / Python | Severity: | S3 (Non-critical) |
Version: | 8.0.20, 8.0.25 | OS: | Ubuntu (20.04) |
Assigned to: | CPU Architecture: | ARM |
[14 May 2020 15:26]
Julian Briggs
[14 May 2020 15:32]
Julian Briggs
Python script to demonstrate the bug.
Attachment: mysql_on_dup_bug.py (text/x-python), 4.86 KiB.
[15 May 2020 10:20]
MySQL Verification Team
Hello Julian Briggs, Thank you for the report and test case. regards, Umesh
[9 Feb 2023 20:02]
Philip Olson
Posted by developer: Fixed as of the upcoming MySQL Connector/Python 8.0.33 release, and here's the proposed changelog entry from the documentation team: Executing executemany() with insert statements that used 'on duplicate key update' demonstrated poor performance; improved speed by fixing the associated regular expressions that match insert statements. Thank you for the bug report.