I am using MySQL 5.6 on ubuntu 14.04.
MySQL server was killed by OS yesterday. (oom kill)
I investigated the memory usage.
$ free -m
total used free shared buffers cached
Mem: 122952 121468 1483 0 285 44494
-/+ buffers/cache: 76689 46263
Swap: 0 0 0
It is a dedicated database server but so much “cached”.
So I have a plan for dropping page cache.
[*]To free pagecache:
$ echo 1 > /proc/sys/vm/drop_caches
[*]To free dentries and inodes:
$ echo 2 > /proc/sys/vm/drop_caches
[*]To free pagecache, dentries and inodes:
$ echo 3 > /proc/sys/vm/drop_caches
Can anyone let me know it is safe to drop page cache ?
Does it can have any side effect ?
I have a ubuntu server that just one MySQL server is running on.