Consuming excessive server resources

  • I get a message from my hosting (Hostgator): ?A temporary block has been placed on database access by your user account xxxx on gator4158. The database associated with /home3/xxxx was consuming excessive server resources and degrading overall system performance….”
    After several days of correspondence, they explained clearly:
    ?Regrettably we are still not detecting any changes as being made to the site; we will need to see this happen before restrictions can be lifted:
    I urge you to look into queries that use order by RAND(), as captured in our initial logs:
    COMMAND: Query
    INFO: select frase, autor from wp_vr_fr_frases ORDER BY rand()
    Order by RAND() is highly inefficient and uses an inordinate amount of resources compared towards other methods of selecting random database rows. You can see more regarding this in the following article:
    Benchmark of order by rand() versus other efficient methods: https://www.warpconduit.net/2011/03/23/selecting-a-random-record-using-mysql-benchmark-results/”
    So, I disabled VR-Frases (collect & share quotes)’ widget which uses ORDER BY RAND(). I don’t understand how a small widget can affect a large server database, but I admit I don’t have much knowledge about that. I want to continue using the widget in my blog. What can be done?

  • The topic ‘Consuming excessive server resources’ is closed to new replies.