Bug #89559 P_S recording wrong digest/digest_text for select statements using views
Submitted: 6 Feb 2018 20:45 Modified: 2 Jul 2021 17:49
Reporter: dob bod Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Performance Schema Severity:S3 (Non-critical)
Version:5.7.21 OS:Any
Assigned to: Marc ALFF CPU Architecture:Any
Tags: digest, DIGEST_TEXT, events_statements_summary_by_digest, performance_schema

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:

[8 Feb 2018 19:32] dob bod
script output with view merge

Attachment: MERGE.txt (text/plain), 38.57 KiB.

[8 Feb 2018 19:33] dob bod
script output with view temptable

Attachment: TEMPTABLE.txt (text/plain), 37.66 KiB.

[9 Feb 2018 16:59] dob bod
performance_schema setup

Attachment: SHOW_SETUP.txt (text/plain), 127.86 KiB.

[12 Feb 2018 17:15] SINISA MILIVOJEVIC
The output from the test case.

Attachment: output.txt (text/plain), 43.04 KiB.