Related

Product Now Available: Managed MySQL Databases Product
Slow phpMyAdmin/MySQL import Question Question
How does one fix this MySQL zero day vulnerability on Ubuntu 14.04? Question Question

Question

LAMP Stack, Ubuntu 14, using virtual host, mysql crashes daily but for only one website the other is unaffected?

Posted May 1, 2017 1.5k views
UbuntuMySQL

I’ve already upped the innodb buffer to 64mb, applied the recommended Apache tweaks. These sites are hosted on a 1GB dropplet, running 2 WP sites. I haven’t tried SWAP, but I’m thinking it’s not a RAM issue since only one site crashes while the other remains operational. I could be wrong .... about the RAM … any ideas on where I should start looking? Thanks in advance.

Add a comment
By:
N8Ting
Add a comment

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.

×
3 answers
hansen May 1, 2017

Hi @N8Ting

Define “crashes” - do you have any logs or what’s the error?
Do not add SWAP to DigitalOcean droplets - it will become slower, just add more RAM if needed.
I would probably have a look at the recommendations from MySQL Tuner based on your database statistics: https://github.com/major/MySQLTuner-perl

Reply Report
N8Ting May 1, 2017

“Crashes” probably isn’t the correct word since the other site is unaffected. I get the “error establishing database connection” message on screen. If I restart Mysql it’s back up and running. I’m pretty new to this whole thing, I’ve tried to find the error logs, the only log I did manage to find only had the activity from when I restarted mysql this morning. Recommendations on which log files to view? Again, I appreciate the help.

Reply Report
  • hansen May 1, 2017

    @N8Ting
    You can find usually find you MySQL log in /var/log/mysql/error.log
    Are you connecting to MySQL the same way on both sites? Meaning are you connecting through localhost and port 3306 - or are you using a socket.

    Reply Report
N8Ting May 2, 2017

Good morning and thank you for working with me. The error log you mentioned is the one I previewed but only had info from when I restarted Mysql. The site has not failed since yesterday morning, so I’ll continue to watch and when it fails again I’ll dig into the error log then. As far as I know they connect in the exact same way using localhost.

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help