Comment 3 for bug 1560304
Revision history for this message
| XieAn (xiepaup) wrote Re: Every once in a while mysql trigger oom-killer | #3 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
e3ace39
(Get the code!)
Some friends give me some advice,As some servers run only a slave, no external services; so initially suspected to be due to memory leaks caused by slave; I simply find a server is about to OOM, And Execute Command: "stop slave; start slave;" And memory very magical release out.
[root@xxxxx]# sar -r
03:20:01 PM kbmemfree kbmemused %memused kbbuffers kbcached kbcommit %commit
03:30:01 PM 1197188 64658448 98.18 10960 196488 80001604 97.28
03:40:01 PM 1286788 64568848 98.05 8220 90144 80021528 97.30
03:50:01 PM 1268316 64587320 98.07 6236 116312 80042812 97.33
04:00:01 PM 1206636 64649000 98.17 11940 199652 80067460 97.36
04:10:01 PM 1202612 64653024 98.17 17432 192788 80092456 97.39
04:20:01 PM 29531728 36323908 55.16 24476 73620 80117732 97.42
04:30:01 PM 29048444 36807192 55.89 61120 481336 80121668 97.42
04:40:01 PM 28543556 37312080 56.66 77828 938576 80121992 97.43
[root@xxxxxx]# free -g
total used free shared buffers cached
Mem: 62 36 25 0 0 1
-/+ buffers/cache: 34 28
Swap: 15 0 14
[root@DB-