Bug #80556 | inserting large json data takes an inordinate amount of time | ||
---|---|---|---|
Submitted: | 29 Feb 2016 12:05 | Modified: | 13 Jun 2016 16:39 |
Reporter: | Shane Bester (Platinum Quality Contributor) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S2 (Serious) |
Version: | 5.7.12 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[29 Feb 2016 12:05]
Shane Bester
[29 Feb 2016 12:27]
MySQL Verification Team
5.7.12 perf report for the slow testcase
Attachment: bug80556_5.7.12_perf_report.zip (application/x-zip-compressed, text), 197.08 KiB.
[13 Jun 2016 16:39]
Jon Stephens
General optimizer bug, not limited to JSON. Documented in the MySQL 5.7.14 changelog as follows: A flaw in the allocation of memory for appending string values caused some operations to be performed slowly, including creation of tables having generated columns and inserts of large values into JSON columns. Closed.