Not the answer you need?
Register and ask your own question!

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

sprwl_0827sprwl_0827 ContributorCurrent User Role Beginner
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

Comments

  • yogesh777yogesh777 Contributor Current User Role Beginner
    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.
  • eroomydnaeroomydna MySQL Addict Current User Role Beginner
    You're assuming that MySQL is causing swapping. Check your system's swappiness setting.

    Some further reading on this;

    http://www.mysqlplus.net/tag/swappiness/
  • sprwl_0827sprwl_0827 Contributor Current User Role Beginner
    my.cnf is using standard config as all other db servers in our environment (for same system config) .Swappiness is set to 0 .
  • przemekprzemek Percona Support Engineer Percona Staff Role
    Please paste here the result of:
    numactl --hardware
    ps aux --sort=rss |tail
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.