Question

Wordpress site going down every single night

Every single night my site goes down between 3am to 6am and has gone down now for about 20 days in a row. It didn’t go down nearly as much when it had 4x the daily traffic that it does now.

Because the droplet goes down at night and I wake up quite a few hours later, my site is down for 4-8 hours. It restarts immediately when I cue sudo service mysql restart command through the console

I want to investigate and fix why my mysql keeps going down so frequently. Can someone please explain how do i go about this in a simple way?

I already have SWAP paritition too

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Hi, @SamN

Thanks for getting back to me. The issue can and might be intermittent so this can only occur at different time of the day. What you can is also check the resource usage graphs in order to track the performance.

Droplet graphs are up-to-the minute visualizations of how your server is performing over time. They let you monitor Droplet performance metrics in the control panel.

Droplets come with some graphs available by default, and there are additional graphs available when you enable the free DigitalOcean Monitoring service.

You can check out the official docs here: https://www.digitalocean.com/docs/droplets/how-to/graphs/

Regards, Alex

Hello, @SamN

You can check if the MySQL server is not logging it’s errors in other file:

mysql -e "show variables like 'log_error'"

Also you can still check for any InnoDB: Cannot allocate memory for the buffer pool references in the log as this will indicate that you need to proceed with a memory upgrade for the droplet.

Hope that this helps!

Regards, Alex

Hello, @SamN

Could you please confirm that the MySQL service is the reason the site is experiencing the downtime issues? This will mean that every time you experience a downtime period your site will load with the “Error establishing database connection” error or similar depending from the error handling of your code or CMS.

You can always examine the MySQL error_log in order to track down any errors. On Ubuntu systems, the default location for the MySQL is /var/log/mysql/error.log

In many cases, the error logs are most easily read with the less program, a command line utility that allows you to view files but not edit them:

sudo less /var/log/mysql/error.log

When MySQL isn’t behaving as expected, you can obtain more information about the source of the trouble by running this command and diagnosing the error based on the log’s contents.

MySQL configuration

What you can also do is to use the MySQLTuner script.

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

You can also check our tutorials on How To Troubleshoot Issues in MySQL:

https://www.digitalocean.com/community/tutorial_series/how-to-troubleshoot-issues-in-mysql

Hope this helps!

Regards, Alex

Hello, the website can down due to many factors, server errors, worpress configuration, themes or plugins updates and changes, firstly you should know the cause of this down, contact your webhosting provider and they will check if the problem is not from server, if not, use google pagespeed inshights and see what affects your website