Saturday, June 11, 2016

linux - All memory consumed by MySQL











TOP shows that almost all the memory is consued on a dedicated MySQL box.
I stopped mysql and checked the top and there is no difference. There is no other process running that would consume that kind of memory.
How do I release the locked memory?



# /etc/init.d/mysqld status
mysqld dead but subsys locked

# free -m

total used free shared buffers cached
Mem: 35007 34913 94 0 186 33045
-/+ buffers/cache: 1681 33326
Swap: 0 0 0


Do I need to restart the server?


Answer



Look at the third line (-/+ buffers/cache) which shows you memory used by the operating system for filesystem buffers and caches, but that can immediately be made available for use by any process which needs it. You do not have a memory shortage.


No comments:

Post a Comment

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...