MySQL Forums
Forum List  »  Performance

Mysql use up all my swap space WHY?
Posted by: yvonne kire
Date: June 04, 2018 03:46PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql use up all my swap space WHY?
86
June 04, 2018 03:46PM


Sorry, only registered users may post in this forum.

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.