SQL Crash? How to limit?

  • knucleheads

    (@knucleheads)


    11 years ago

    Hello everyone,
    I have a one-page site (for now… in the future, it will expand).
    I visit the site every week or so… and it often happens, that it is down.

    The message is the popular

    Error establishing a database connection

    .

    I ssh into the server, shut down apache… restart sql, then start apache.
    After that, all is good.
    Until the next time it crashes again.

    The server is very small… it’s a two-core, 256MB ram VPS running Ubuntu Server.
    Nothing else other than WordPress (and SQL) runs on that server.

    I was wondering what can I do to limit this crash?
    What suggestions can I follow?

    Looking forward to your feedback… I am not sure what to do with this problem.

    Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
  • catacaustic

    (@catacaustic)

    11 years ago

    I was wondering what can I do to limit this crash?

    Get a beefier server.

    There’s not much else that can be said about this. Check the error logs on the server, but it looks like the server can’t handle the load that’s being put on it, so the MySQL server crashes, which is why you get that error.

    adeizasama

    (@adeizasama)

    10 years, 10 months ago

    Hi,

    I’m having this exact same error. Admittedly we do get a lot of traffic, but this is why we bumped up to godaddys VPS and they said we wouldn’t have server strains.

    Is the server load really the only thing that can cause this?

    Thanks in advance.

    Thread Starter knucleheads

    (@knucleheads)

    10 years, 10 months ago

    adeizasama,
    What are your server specs?

    I fixed my issue by upgrading from 256mb ram, to 512.

    catacaustic

    (@catacaustic)

    10 years, 9 months ago

    Is the server load really the only thing that can cause this?

    No, but it is in 99.9999999% of cases.

    If you don’t beleive that it’s server load you’ll find errors in the various logs. I’d suggest looking there.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘SQL Crash? How to limit?’ is closed to new replies.