Server Memory Issue
Posted:
Sun Jul 24, 2016 9:35 am
by hansg
I am having an issue on one of my servers wheer a certain mysql process is taking up 99% of my RAM I have attached a screenshot of my htop command below.
Re: Server Memory Issue
Posted:
Sun Jul 24, 2016 9:44 am
by hansg
I know it's normal for linux to run at high memory usage but I'm not sure about all those processes being there at once.
Also should detail my server is:
Centos 6
Scratch Install ViciDial
Cloud Server - Dual Core - 2GB DDR3 - 80GB SSD
VERSION: 2.12-555a
BUILD: 160508-1948
Re: Server Memory Issue
Posted:
Sun Jul 24, 2016 7:59 pm
by lasthuman
hello,
for centos you can use sync && echo 3 > /proc/sys/vm/drop_caches
maybe try making a Cron job for that
let me know if that works
Re: Server Memory Issue
Posted:
Sun Jul 24, 2016 9:06 pm
by williamconley
mysql always uses ALL memory.
since any previously run query could be re-run, and if the results have not changed the same query in memory is an order of magnitude faster and less processor-intensive to return ... the mysql system uses ALL available memory but marks "technically no longer needed, but could come in handy" query memory as "available to the system".
so while it's all been consumed, much of it is still actually available for use.
if you experience no other symptoms, ignore the usage. if you do experience symptoms, attack those and continue to ignore this. if, however, you actually have very little memory and you have an enterprise level vicidial cluster ... continue to ignore this except that you should add more memory.
if mysql actually runs out of memory, dropping caches won't help anyway.