Mysql use up all my swap space WHY?
I am running a mysql 5.5 master
on a dedicated mysql master host.
it has 26Gb swap space and now alert on it's 93% used
it was 24GB a week ago and I added a tmp file a 2gb
and now it's eaten up as well.
Swapoff/on doesn't work cause it isn't enough free mem avaliable.
What can I do ?
( besides reboot the master and wait until it all chewed up again )
What causes this ? bug in 5.5 ? memory leak ?
I did a 'flush tables' and that released some 1-2gb back but not a fix...
thx
swapoff -a; sleep 2; swapon -a
swapoff: /dev/sda3: swapoff failed: Cannot allocate memory
| innodb_buffer_pool_size | 30064771072
cat /proc/sys/vm/swappiness
1
cat /proc/sys/vm/dirty_ratio
20
RAM_ Size HD_Size HD_Used HD_Free Used% Speed Cache HT MySQL OSbits Linux_Version Model
49408748 689G 307G 348G 47% 2.40GHz 12288 16 5.5.32 x86_64 CentOS6.9(Final) R610f
DB_Type SwapSize SwapUsed SwapFree Usage% Cpu_1m Cpu_5m Cpu15m
master 26869752 25055192 1814560 93.247 2.23 2.30 2.30
free -m
total used free shared buffers cached
Mem: 48250 47649 600 0 8 101
-/+ buffers/cache: 47539 710
Swap: 26239 24699 1540
cat /proc/swaps
Filename Type Size Used Priority
/dev/sda3 partition 24772604 24634188 -1
/var/tmp/swapfile file 2097148 511024 -2
./find-out-what-is-using-your-swap.sh
..............................................
Overall swap used: 25019700 kB
========================================
kB pid name
========================================
24816896 7087 mysqld
145968 4636 messaging_local
28228 4311 puppet
7016 3226 snmpd
2444 30865 rsyslogd
Subject
Views
Written By
Posted
Mysql use up all my swap space WHY?
1709
June 04, 2018 03:46PM
823
June 04, 2018 10:07PM
775
June 05, 2018 11:40AM
734
June 05, 2018 11:45AM
1000
June 05, 2018 01:40PM
2190
June 05, 2018 04:39PM
1083
June 06, 2018 11:45AM
855
June 06, 2018 01:09PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.