Restart Apache, MySQL When Low on Memory
Heavy traffic, hungry SQL queries, leaky applications will eventually leave your server low on memory. Apache will go on a hunt for swap space and MySQL will start freezing in thoughtful contemplation. Your hard drives will start scratching like a pack of homeless dogs and suddenly everything will become very very s l o w w w.
RAM is cheap these days, so if you can cram a couple more of these magic speed sticks into your system board, that would be thirty bucks well spent. However, if your server is maxed out and funding for an upgrade is months away, what you need is a script. It will be a very small script (after all, you are short on memory) that every once in a while will check the amount of free memory remaining and, if necessary, it will restart both the Apache and MySQL.
Hopefully, this would free up some RAM and your server will be good to go for a few more days. And so here is the script, which you can easily adapt to your specific unixoid OS.
#!/bin/bash
threshold=90 #percent
total=$(free | grep "Mem:" | awk '{print $2}')
remaining=$(free | grep "Mem:" | awk '{print $4}')
current=$(echo "scale=0;100-$remaining * 100 / $total" | bc -l)
if [ $current -gt $threshold ]
then
/etc/init.d/apache2 stop
/etc/init.d/mysql restart
/etc/init.d/apache2 start
echo "Restarted apache and mysql on `date +'%Y-%m-%d %H:%M:%S'`. RAM utilization at ${current}%"
>> /var/log/apache_mysql_restarter.log
fi
Put this script in the cron to run every couple hours (not too often). Use the log to see how severe is the memory problem. You may want to add the log to rotation to make sure it doesn’t grow too big.
17 Comments »
1 Pingbacks »
-
[…] KrazyWorks Etiquetas: apache, bash, grep, httpd, memoria, mysql, ram, reiniciar, script, […]
![wyryr1sn52gntzn65v4fpz5lc6v[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/wyryr1sn52gntzn65v4fpz5lc6v1-80x80.jpg "Plundering Facebook Photo Albums")
![clfud46mxf2t5zph2l04zlpgl1d[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/clfud46mxf2t5zph2l04zlpgl1d1-80x80.jpg "Scraping a Web Page in Bash")
![DSCF5361[1]](https://i1.wp.com/www.krazyworks.com/wp-content/uploads/2020/10/DSCF53611-80x80.jpg "Processing Videos with ffmpeg and Lightroom")
![Cat-Devouring-A-Bird-Pablo-Picasso[1]](https://i0.wp.com/www.krazyworks.com/wp-content/uploads/2020/10/Cat-Devouring-A-Bird-Pablo-Picasso1-80x80.jpg "Searching Twitter")
![91ebozy1e3b138waujy28agrngy[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/91ebozy1e3b138waujy28agrngy1-80x80.jpg "Generating Random Text Files for Testing")
![iwoau71okwxqh4jv3k4ook32qps[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/iwoau71okwxqh4jv3k4ook32qps1-80x80.jpg "Finding Cron Jobs")
![5gtysva4wkc8mzc1k3e66vaycxx[1]](https://i1.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/5gtysva4wkc8mzc1k3e66vaycxx1-80x80.jpg "Understanding Memory Utilization in Linux")
![sy2zeb1vp2h8itlxfbbylw0jrm0[1]](https://i0.wp.com/www.krazyworks.com/wp-content/uploads/2019/12/sy2zeb1vp2h8itlxfbbylw0jrm01-80x80.jpg "Validating HTTPS Cache Peers for Squid")
![Photo-2019-10-07-14-39-03_0266[1]](https://i1.wp.com/www.krazyworks.com/wp-content/uploads/2019/11/Photo-2019-10-07-14-39-03_02661-80x80.jpg "Verifying SNMP Connectivity on Multiple Hosts")
Not Found :(
: command not foundne 2:
(standard_in) 1: illegal character: ^M
(standard_in) 1: illegal character: ^M
: command not foundne 7:
memoria-baja.sh: line 17: syntax error: unexpected end of file
The “^M” is Windows end-of-line special character. You should be careful when you cut-and-paste the code. I suggest you use “vi” editor on the Unix/Linux system to check the code and made sure you get rid of the “^M” at the end of each line. Or download this file: https://www.krazyworks.com/wp-content/uploads/2009/08/memoria-baja.sh
Hi Igor
Now if I work … Thank you very much: D
Now I can sleep peacefully:)
Thank you.
thanks Igor!
it works for me, I could free up some RAM on my server.
=)
Ha, ha, ha, very funy. Just implemented script, and found out that in order to look for REAL ammount of free memory, you need to check -/+ buffers, because my linux box was doing “disk cache” and my memory apperared completely exausted (and it was not, it was disk caching using unused RAM) and my apache was restarted EVERY minute. EVERY MINUTE !
Do your homework, before publishing this kind of crap.
You have to admit that it was pretty silly of you to use this script on a system that uses Apache RAM cache. I guess you’ve learned your lesson. It’s a good idea to know what you are doing.
Not only that, but you also specifically recommended to set up the cron job to run this script every few hours, not every minute.
Andrija, you’re a moron.
How can i secure my apache server to keep bad guys away?
I’m doing a school project. We where given 6 words and we have to find out how to say them in a different language. Every word has to be a different language. I found the first five words. But the 6th word is flowers in the Apache language. The problem is, when I looked it up on the internet, I found out there are many different languages among the Apache tribes.
I need the proper spelling and how to pronounce it.
How can I find the answer to this?
I am not a computer course student, but I want to learn Apache, MySQL, and PHP. What are the softwares to use? Please suggest a plan I need to follow.
I am planning to learn by self-study at home.
Maybe running them and writting websites.
I want to start the easiest of course.
i have an apache 100 automatic atv quad bike i tried to start it this morning, the engine is turning over but it sounds like the fuel isnt getting through, i have checked the spark plug-which is fine, but it still wouldnt start. i tried jump-starting it from a lawnmower but still no success, i have nearly given up hope- please can somebody help me?
If China obtains the apache or its technology, together with the wz-10 helicopter they currently owns, will their airforce be invincle in asia?
I think if China gets the apache, it will further upgrade their ability to launch an attack on Taiwan.
Hello Everyone.
I am taking a intro to linux class and I have a assignment to make a simple website with Apache. Does anyone know where I can find a website that will have a step by step on how to make one. All my website has to say is my name and what i think about Linux.
I have a Red Hat linux box (Server 1) serving as a gateway computer for our network, as well as hosting our website. I’m currently developing another website on another linux box (server 2) in the network, but connected to the internet through the other. Is it possible to have the gateway computer direct webbrowsers to server 2? Is there a configuration in apache that would do that?
As title thanks. I am hoping to set up a forum and step 1 for me will be set up a server using Apache or IIS. Unfortunately I have little idea how to achieve that….
(PS: I want to run this forum off my own computer acting as a server)
How can I join the army, and be the gunner of an apache or similar gunship. What courses, do I need previous training, and where could I sign up?
Edit: I meant for America IF we go to war with them,
Apache means like a Chopper gunner not a sniper. Cause I bet everyone wants to be one because they don’t get shot at/die as much, so I’m wondering if you have to go through more training?
How to change local host to my paid domain in Apache?
I can’t message you!
Even tho my domain is currently hosted I can just use it?
@john I sent you a email.