1.8% memory usage Still swap memory utilized

MySQL & MariaDB Other MySQL® Questions
1

I have mysql installed on a SUSe box it is working as slave.
It has 8GB of physical RAM and mostly is being used only for reporting (Rare execution of complex queries).

the result of top command shows that mysql is utilizing only 1.8% of memory. And other process are using 0% memory each.

but it is showing 204K of swap usage

top - 16:35:38 up 43 days, 12:04, 1 user, load average: 0.00, 0.00, 0.00
Tasks: 98 total, 1 running, 97 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 8125980k total, 8104884k used, 21096k free, 472224k buffers
Swap: 8393952k total, 204k used, 8393748k free, 898100k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
18782 mysql 16 0 604m 146m 4412 S 0 1.8 0:22.30 mysqld
3046 root 16 0 31412 5912 2920 S 0 0.1 0:00.07 snmpd

I was wondering, which process may be using so much of memory.
Please help
Thanks
Ankur
vaish.ankur@gmail.com

2

Linux will always swap, unless you set /proc/sys/vm/swappiness to 0.

Swapping is good. Linux will remove things from memory that are rarely accessed, freeing up that memory for more file cache, etc., which is used more frequently.