Bug #91710 | after upgrading from 5.6.32 to 5.7.22(jemalloc-5.1), memory usage keeps growing | ||
---|---|---|---|
Submitted: | 19 Jul 2018 6:21 | Modified: | 8 Oct 2018 14:09 |
Reporter: | Suantai Rousi | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 5.7.22,5.7.23 | OS: | Red Hat (6.5) |
Assigned to: | MySQL Verification Team | CPU Architecture: | x86 (64bit) |
Tags: | jemalloc-5.1.0, M-M replication, Memory Growing, MTS, swap |
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:
- On *nix platforms use the split command e.g.
split -b 50MB <my_large_archive> <my_split_archive_prefix>
- On windows use WinZip or a similar utility to split the large file
[19 Jul 2018 6:23]
Suantai Rousi
[19 Jul 2018 6:23]
Suantai Rousi
os memory
Attachment: OS_memory.txt (text/plain), 3.33 KiB.
[19 Jul 2018 6:23]
Suantai Rousi
sys memory results
Attachment: mysql_sys_memory.txt (text/plain), 39.09 KiB.
[19 Jul 2018 6:24]
Suantai Rousi
global variables
Attachment: global_variables.txt (text/plain), 14.83 KiB.
[19 Jul 2018 6:24]
Suantai Rousi
global status
Attachment: global_status.txt (text/plain), 36.19 KiB.
[4 Sep 2018 2:10]
Suantai Rousi
master cnf
Attachment: master.cnf (application/octet-stream, text), 4.85 KiB.
[4 Sep 2018 2:10]
Suantai Rousi
slave cnf
Attachment: slave.cnf (application/octet-stream, text), 4.89 KiB.
[4 Sep 2018 2:10]
Suantai Rousi
slave mysql overview
Attachment: overview.png (image/png, text), 77.54 KiB.
[4 Sep 2018 2:11]
Suantai Rousi
slave memory
Attachment: memory-slave.png (image/png, text), 30.29 KiB.
[4 Sep 2018 2:12]
Suantai Rousi
slave memory detail
Attachment: memorydetail-slave.png (image/png, text), 122.00 KiB.
[4 Sep 2018 2:22]
Suantai Rousi
master global status
Attachment: status-master.txt (text/plain), 35.41 KiB.
[4 Sep 2018 2:22]
Suantai Rousi
slave global status
Attachment: status-slave.txt (text/plain), 35.41 KiB.
[4 Sep 2018 7:29]
Suantai Rousi
performance schema memory summary by events
Attachment: P_S-summary.txt (text/plain), 7.63 KiB.