Skip to main content
paulk7737514
paulk7737514
Inspiring
August 5, 2020
Question

Site down due to overload of SQL resources

  • August 5, 2020
  • 2 replies
  • 475 views

This is a first for me. I have received an email from a client whose website has been taken down due to an overload of SQL resource in a shared hosting account. I will have to look at the database in phpMyAdmin and try to see what's going on.

 

The site be reviewed before it is allowed to be put back online. Link spamming may be the culprit, but the site is not a Wordpress blog. Anyone else ever have this issue?

    This topic has been closed for replies.

    2 replies

    O
    osgood_
    Legend
    August 5, 2020

    I've never personally come across it before and all my clients websites are on shared servers. Does this website attract a large volume of hits? If so maybe it should be on a dedicated server and not a shared one. The story probably goes the client wants everything as cheap as chips. If it is a website that attracts a large volume of hits then it is probably using more than its fair share of server calls which are allowed or set on shared hosting, so has effectively been throttled, penalised.

     

    Dont waste time, just tell your client straight, we need a better server, a dedicated one or better hosting plan, this will cost more, pay for it or pay the concequences of not paying for it - go somewhere else if you dont want to listen to a voice of experience because I cant be bothered dealing with a cheap skate. In my experience its never worth it, you'll only give yourself  a bigger headache than what you need.

     

    Go for it - you get way more respect from clients because you are being honest and positive. When you mouse around with clients they take control, you should be the one in control and advising them, they have no experience.

      paulk7737514
      paulk7737514Author
      Inspiring
      August 14, 2020

      Turned out to be link spam created by fake user registrations (6,000 and counting) as well as link spam left on a forum installed on the CMS but not deployed (70,000 or more) which bloated the database size to larger than 1 gigabyte. I added ReCaptcha which for some reason I forgot to do and disabled the forum.

      O
      osgood_
      Legend
      August 14, 2020

      It happens. There's really too much to think about when producing even a simple website these days and little time to think about everything in terms of what you are usually getting paid to produce the job. Producing websites these days are a job for a team, not an individual anymore, they've becme far too complex and need dedicated skills.

      Nancy OShea
      Community Expert
      Nancy OSheaCommunity Expert
      Community Expert
      August 5, 2020

      The site traffic may warrant upgrading to a better, faster hosting plan. 

      Or perhaps inefficient scripts are causing too many SQL queries and/or redundant database connections.

      https://support.infinityfree.net/limits/mysql-overload-limit/

       

      Profiling MySQL Queries with phpMyAdmin

      https://code.tutsplus.com/tutorials/profiling-mysql-queries-with-phpmyadmin--net-12687

       

      Speed up MySQL Queries 300 Times.

      https://opensource.com/article/17/5/speed-your-mysql-queries-300-times

       

      Nancy O'Shea— Product User & Community Expert
        Terms & ConditionsAccessibility statement
        Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices