Website database crashes at busy traffic

  • Hello

    My website has been having problems for a long time now with the database crashing if we get may 50-100 users (I know this isnt alot) visiting the same page at once.

    Its generally a page like this which uses my plugin I made: https://www.vanity-tournaments.com/cups/pc/league-of-legends/cup-4

    I am now using a dedicated VPS and still had this problem yesterday with a crash at the busiest point of the day.

    The host offering me the VPS said “Your site is literally one of the most demanding sites we’ve ever hosted and your description of what it does really is making me wonder why this should be.”

    Does anyone have any suggestions on what this could be or how I could fix it.

    Thanks

    Elliot

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

  • if your host thinks a site with 100 users at the same time is busy you should consider changing the host ??
    anyway – there are a thousands things which can overloads the server.
    plugins, theme, apache configs, server hardware, etc.

    a quick fix is using a caching plugin.
    There are a few big ones available and I personally prefer w3tc
    https://www.ads-software.com/plugins/w3-total-cache/

    Have you run your site through Google’s PageSpeed analyzer? It shows a lot of areas that need to be optimized that are probably killing your server.

    https://developers.google.com/speed/pagespeed/insights/?url=http%3A%2F%2Fwww.vanity-tournaments.com%2Fcups%2Fpc%2Fleague-of-legends%2Fcup-4%2F

    Thread Starter Elliot Sowersby

    (@elliotvs)

    Hi gerald,

    The host was regarding towards how much bandwidth we take and server crashes compered to our traffic.

    Thanks for the suggestions. I have installed W3 Total Cache and has improved the site speed test and page size.

    I have made my own plugin that has quite alot of SQL queries, could this cause an issue?

    Thanks for the help.

    Elliot

    Anything that uses a lot of SQL queries will add a whole lot of load to the server. Database calls are one of the most load-intensive things that you can do to your stie, so doing evrything that you can to optimise the database calls would definately be the first priority.

    I have made my own plugin that has quite alot of SQL queries, could this cause an issue?

    if the query is running on every pageview it could overload your server easily.
    w3tc plugin is able to cache db queries also.

    Thread Starter Elliot Sowersby

    (@elliotvs)

    Ok thanks for the help.

    Using W3 Total Cache last night seemed to work as we had about 120 visitors on the same page at once and it didnt crash, whilst last time it crashed with about 60.

    However with W3 Total Cache there was some problems because the database updates alot with people submitting data etc quite frequently to the database which is displayed on the website, because of the cache some people where not seeing the latest version of the data etc.

    as far as I remember it’s possible to manually exclude specific database queries from caching. you can ask for help in the w3tc plugin support section here.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Website database crashes at busy traffic’ is closed to new replies.