Daily Crashing of mySQL database

  • Despite using WordPress for 8 years, this is my first ever support request, so please be gentle with me ??

    My client’s website at https://fantasywire.co.uk seems to crash the MySQL server most days (or goes super slow) at around 15:15 UTC.

    A have a managed VPN with TSOHost in the UK. I have liaised with them to fix this issue, but they say it’s the website causing the problem, so outside their scope.

    TSOHost say they have to reboot the server most days (although they didn’t tell me about this until pressed).

    I have carried out all the recommendations for fixing the “Error establishing a database connection” error that is thrown, but this mostly assumes I can’t get into my site at all. In my instance, I can get into it fine, except from early afternoon, until some time later when TSO reboot my server.

    My issue is, that I don’t know what I should be looking for, so I have no idea how to fault find this. I don’t even know how, or if I’m able to reboot the server from cPanel, which might help whilst trying to solve this.

    If you could recommend an initial course of action, that would be really great.
    Thanks

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    If your database server is crashing, the first place to look is the server’s error logs, both /var/log/messages and /var/log/mysql (or /var/log/mariadb).

    Also, use a mysql tuning tool to see if you can get better performance from your server. Here’s one: https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl

    Your host is blaming WP because that’s the easiest thing for them to do. However, it’s not WP that’s crashing, it’s the server.

    Thread Starter tallturtle

    (@tallturtle)

    Hi Steven
    Thanks for your rapid reply.
    I’m afraid I don’t know where to look for the server error logs. I’ve had a look around cPanel and haven’t found anything that looks like your suggestion.

    The link to the server configuration utility also doesn’t make any sense to me either.

    I know I’m coming across as a complete idiot, but it’s just that this isn’t my area of expertise. Believe it or not, I’m actually quite technically minded, so don’t give up on me yet

    Thanks
    Phil

    • This reply was modified 3 years, 8 months ago by tallturtle.
    • This reply was modified 3 years, 8 months ago by tallturtle.
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Daily Crashing of mySQL database’ is closed to new replies.