Bug #87884 MySQL 5.7.15 hangs when executing truncate table
Submitted: 27 Sep 2017 10:18 Modified: 4 Nov 2017 9:56
Reporter: lou shuai (OCA) Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S1 (Critical)
Version:5.7.18 OS:Linux
Assigned to: MySQL Verification Team CPU Architecture:Any

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:

[27 Sep 2017 10:19] lou shuai
pstack

Attachment: pstack.log (application/octet-stream, text), 342.66 KiB.

[27 Sep 2017 10:19] lou shuai
all processlist log

Attachment: allps.log (application/octet-stream, text), 40.30 KiB.