Shulou(Shulou.com)06/01 Report--

Recently, a swap alarm was found.

[root@hs-72 mysql] # free-h

Total used free shared buff/cache available

Mem: 62G 39G 20G 1.5G 2.9G 20G

Swap: 63G 19G 44G

As above, swap uses 19g.

At the moment, if I want to know which swap is mainly occupied by.

Because this is a mysql server. If it wasn't occupied by mysql, I wouldn't have to deal with this swap in theory.

Use the command

For i in $(cd / proc;ls | grep "^ [0-9]" | awk'$0 > 100'); do awk'/ Swap:/ {a=a+$2} END {print'"$I", a proc/$i/smaps 1024 "M"}'/ proc/$i/smaps 2 > / dev/null; done | sort-k2nr | head-10

The output is as follows. The first column is pid.

Head-10

18906 12385.2M

3755 431.055M

38125 400.004M

37271 63.0781M

37852 60.9492M

37661 38.0156M

37088 28.1953M

1997 18.4219M

73344 11.8711M

73331 10.2852M

You can see that pid=18906 often takes up the most swap.

Then we find out which process the pid is.

Use the command

Ps-ef | grep 18906

The output is as follows

Mysql 18906 18682 4 2017? 28-07:00:18 usr/local/mysql-5.1.73/libexec/mysqld-- basedir=/usr-- datadir=/var/lib/mysql-- user=mysql-- log-error=/var/log/mysql/mysql_error.log-- open-files-limit=30000-- pid-file=/var/run/mysqld/mysqld.pid-- socket=/var/run/mysqld/mysqld.sock-- port=3306

Root 165972 82503 0 14:51 pts/0 00:00:00 grep-color=auto 18906

It is found that 18906 this process happens to be a mysql process.

Okay, so far, we've found out which process is using swap.

After that, how to take and deal with this swap is not discussed here.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.