# PS 5.5.28 mysql server swapping even when 4-5G memory is available

**URL:** <https://forums.percona.com/t/ps-5-5-28-mysql-server-swapping-even-when-4-5g-memory-is-available/2978>\
**Category:** Other MySQL® Questions\
**Created:** [September 30, 2013, 1:02pm UTC](https://forums.percona.com/t/ps-5-5-28-mysql-server-swapping-even-when-4-5g-memory-is-available/2978 "2013-09-30T13:02:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![sprwl\_0827](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@sprwl\_0827](https://forums.percona.com/u/sprwl_0827)\
**Post date:** [September 30, 2013, 1:02pm UTC](https://forums.percona.com/t/ps-5-5-28-mysql-server-swapping-even-when-4-5g-memory-is-available/2978/1 "2013-09-30T13:02:11Z")

</div>

Hello,

I 'm seeing couple of mysql db master swapping and using 3-4G of swap memory , but strangely db server has 4-5G free RAM available.

Any idea why mysql is using swap when server has enough ram .

Swappiness is set to 0 on these server .

[db1 ~]$ free -g  
total used free shared buffers cached  
Mem: 125 122 3 0 0 10  
-/+ buffers/cache: 111 14  
Swap: 15 4 11

---

<div class="post-metadata">

**Author:** ![yogesh777](https://avatars.discourse-cdn.com/v4/letter/y/87869e/32.png) [@yogesh777](https://forums.percona.com/u/yogesh777)\
**Post date:** [September 30, 2013, 10:59pm UTC](https://forums.percona.com/t/ps-5-5-28-mysql-server-swapping-even-when-4-5g-memory-is-available/2978/2 "2013-09-30T22:59:48Z")

</div>

how all memory/buffer parameter configured in my.cnf file? if possible paste your mysql config here.  
check what other application/process running on this server except mysql and get top 10 memory utilized process.

---

<div class="post-metadata">

**Author:** ![eroomydna](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/eroomydna/32/941_2.png) [@eroomydna](https://forums.percona.com/u/eroomydna)\
**Post date:** [October 1, 2013, 5:32pm UTC](https://forums.percona.com/t/ps-5-5-28-mysql-server-swapping-even-when-4-5g-memory-is-available/2978/3 "2013-10-01T17:32:28Z")

</div>

[B]You’re assuming that MySQL is causing swapping. Check your system’s swappiness setting.

Some further reading on this; [/B]  
[url][http://www.mysqlplus.net/tag/swappiness/[/url]](http://www.mysqlplus.net/tag/swappiness/%5B/url%5D)

---

<div class="post-metadata">

**Author:** ![sprwl\_0827](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@sprwl\_0827](https://forums.percona.com/u/sprwl_0827)\
**Post date:** [October 2, 2013, 4:35pm UTC](https://forums.percona.com/t/ps-5-5-28-mysql-server-swapping-even-when-4-5g-memory-is-available/2978/4 "2013-10-02T16:35:14Z")

</div>

my.cnf is using standard config as all other db servers in our environment (for same system config) .Swappiness is set to 0 .

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [October 9, 2013, 6:08am UTC](https://forums.percona.com/t/ps-5-5-28-mysql-server-swapping-even-when-4-5g-memory-is-available/2978/5 "2013-10-09T06:08:55Z")

</div>

Please paste here the result of:  
numactl --hardware  
ps aux --sort=rss |tail