Bug #80645 Server RSS increases during trigger execution and does not decrease after
Submitted: 7 Mar 2016 20:59 Modified: 5 Dec 2016 23:24
Reporter: Geoff Montee Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S3 (Non-critical)
Version:5.6.29 OS:Red Hat (RHEL 5, RHEL 6)
Assigned to: 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:

[7 Mar 2016 20:59] Geoff Montee
Server's configuration file.

Attachment: my.cnf (application/octet-stream, text), 1.04 KiB.

[7 Mar 2016 21:00] Geoff Montee
The script that is used during the tests described below to reproduce this issue.

Attachment: trigger-create (application/octet-stream, text), 6.68 KiB.

[7 Mar 2016 21:00] Geoff Montee
The server's global variables from SHOW GLOBAL VARIABLES.

Attachment: variables.out (application/octet-stream, text), 12.04 KiB.

[7 Mar 2016 21:01] Geoff Montee
The results of pidstat during the pidstat run.

Attachment: pidstat.out (application/octet-stream, text), 1.55 KiB.

[7 Mar 2016 21:01] Geoff Montee
The results of the valgrind run.

Attachment: massif_graph.out (application/octet-stream, text), 210.81 KiB.

[10 Mar 2016 11:28] Umesh Shastry
massif graph

Attachment: massif_graph.out (application/octet-stream, text), 194.42 KiB.

[10 Mar 2016 11:29] Umesh Shastry
test results

Attachment: 80645.txt (text/plain), 7.74 KiB.