In the last month my server just started blowing up randomly. I had a perfect installation that worked flawlessly for 9 months but in the last month the load and memory usage just randomly start spiraling out of control.
It appears that something external causes this to happen but I have no idea what it could be. Rebooting the server will make it run normally for anywhere from a few minutes to 18-24 hours but that’s about the max.
The memory usage just keeps going up and up and up until the Apache process core dumps. The load spirals up to 20+.
[Tue Jan 05 11:31:22.629436 2016] [core:notice] [pid 1246] AH00052: child pid 8127 exit signal Segmentation fault (11)
For 9 months prior to this this server operated flawlessly with loads [in top] ranging from .01 - .20.
The server is running digital ocean’s one click WordPress installation image, it has 1 GB of memory and 1 GB swap file.
My list of active plugins is as follows: Blubrry PowerPress, CloudFlare, Disqus Comment System, Jetpack, Login LockDown, Monarch Plugin (Share On Theme123.Net), Nofollow Links, TinyMCE Advanced, Yoast SEO
None of the plugins have been changed in many months.
My server is running only one WordPress installation and one site. WordPress and plugins are always updated to the latest version. There are no major modifications on the site.
I have had problems in the past 100% on every WordPress installation with the sites being crashed via brute force hacking attempts to /xmlrpc.php I have had to completely deny access to that even though it screws up jetpack because I have not been able to get Order Allow,Deny to work. It either causes 520’s to all URLs across the whole server or it reports “order not allowed here” in the error log and it doesn’t work. This is a separate issue but I would be very grateful if anyone can explain that one either. Past experience indicates leaving xmlrpc.php open to the public will result in crashed sites 100% of the time.
Can anyone help? I’m getting really desperate here this is destroying my site. Haven’t been able to keep it online for more than 24 hours since early December. Nobody has any answers.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Disable Jetpack. After upping the RAM on my instance, moving the DB to another server at great expense, turns out it was just Jetpack. As always with Wordpress, start by disabling the plug ins first.
Hello, all
What you can also do is to use the MySQLTuner script. in order to check if your MySQL configuration is using the recommended values to match the available resources of your server.
The MySQLTuner is a script written in Perl and allows you to quickly test your MySQL configuration and it gives you suggestions for adjustments to increase performance and stability.
According to the official GitHub page, it supports 300 indicators for MySQL/MariaDB/Percona Server in this last version.
To run the script you could do the following:
- SSH to your Droplet
- Download the script:
wget http://mysqltuner.pl/ -O mysqltuner.pl
- Then execute it:
perl mysqltuner.pl
The script would run multiple checks against your MySQL instance, all checks done by MySQLTuner are documented here.
Also as stated in the official documentation, it is still extremely important for you to fully understand each change you make to a MySQL database server. If you don’t understand portions of the script’s output, or if you don’t understand the recommendations, you should consult a knowledgeable DBA or system administrator that you trust.
As a good practice make sure to always test your changes on staging environments before implementing them on your production database.
On the same note, if you want to have a worry-free MySQL hosting and focus on your application, I would recommend trying out the DigitalOcean Managed Databases:
https://www.digitalocean.com/products/managed-databases-mysql/
This was mini tutorial was posted from bobbyiliev in this question in our community: https://www.digitalocean.com/community/questions/how-to-tweak-mysql-mariadb-configuration-for-increased-performance-and-stability
Hope that this helps! Regards, Alex
Have you solved the issue? I have multiple Wordpress installations, all of them are running on separate droplets. All of them have the same issue you provided above.
Please let me know if you have solved it.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.