Re: Mysql use up all my swap space WHY?
UPDATE
=======
--Master did CRASH last night due to running out of SWAP
--error.log
InnoDB: detected cycle in LRU for buffer pool 0, skipping to next buffer pool.
InnoDB: detected cycle in LRU for buffer pool 1, skipping to next buffer pool.
180605 21:15:09 mysqld_safe Number of processes running now: 0
180605 21:15:09 mysqld_safe mysqld restarted
180605 21:16:53 [Note] Recovering after a crash..
180605 21:16:58 [Note] Starting crash recovery...
180605 21:16:58 [Note] Crash recovery finished.
--swap looks good today due to mysqld restart which released all used swap.
free -m
total used free shared buffers cached
Mem: 48250 47346 904 0 223 12495
-/+ buffers/cache: 34627 13623
Swap: 26239 183 26056
--Increased innodb_buffer_pool_size to use 80% of available RAM
#innodb_buffer_pool_size=28G # only used 58% of avaliable 48GB RAM - ran out of SWAP and DB crashed 6.6.2018
innodb_buffer_pool_size=38G # changed by YE 6/6/2018 has 48gb RAM now set to 80% of RAM. will go into effect next restart.
Subject
Views
Written By
Posted
407
June 04, 2018 03:46PM
180
June 04, 2018 10:07PM
167
June 05, 2018 11:40AM
187
June 05, 2018 11:45AM
154
June 05, 2018 01:40PM
152
June 05, 2018 04:39PM
Re: Mysql use up all my swap space WHY?
164
June 06, 2018 11:45AM
172
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.