MySQL Forums
Forum List  »  Performance

Re: Mysql use up all my swap space WHY?
Posted by: yvonne kire
Date: June 06, 2018 11:45AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Mysql use up all my swap space WHY?
77
June 06, 2018 11:45AM


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.