Bug #99736 Unique index lock after INSERT, DELETE, INSERT with same values
Submitted: 29 May 2020 7:34 Modified: 29 May 2020 14:23
Reporter: Niklas Deutschmann Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:8.0.20 OS:Windows (Windows 10 (1909))
Assigned to: CPU Architecture:x86

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[29 May 2020 7:36] Niklas Deutschmann
SQL (session 1)

Attachment: session1.sql (application/octet-stream, text), 314 bytes.

[29 May 2020 7:36] Niklas Deutschmann
SQL (session 2)

Attachment: session2.sql (application/octet-stream, text), 137 bytes.

[29 May 2020 7:37] Niklas Deutschmann
Output from "performance_schema" tables (MySQL 8.0.19)

Attachment: performance_schema.log (application/octet-stream, text), 2.29 KiB.