Home Web Development How to Reduce the Load on CPU and Database...

    How to Reduce the Load on CPU and Database of your Website

    With the increase in site traffic, the load on the CPU and MySQL Database increases. In this tutorial, I will guide you on how you can reduce the load on CPU and Database by optimizing your site and cut the cost of increasing your server resources.

    There are many articles on the Internet with dozens of points on how to reduce the load. What they just don’t write: both lazyload (Google PageSpeed recommends), and gzip-compression, and writing directives in robots.txt, and setting the cache in .htaccess for static files (although in the yard 2019 and 95% of hosts do it for you ), and many other little things.

    No, using lazyload is super, and processing the pictures on the server-side is also cool, and be sure to collect all the styles in one CSS file, and scripts in footer + async. But in terms of reducing the load, this will not help. Indeed, there are only a few working methods.


    1. Enable Caching

    For Joomla, I use the Jotcache component and for WordPress, we recommend using the W3 Total Cache plugin. Each for himself decides what caching time to set. Since I have a news site, I put 5 minutes. But if the speed of adding and updating information does not play a tangible role (for example, for article sites), you can set 30-90 minutes.

    PS: Standard built-in components will not help here. Caching should reduce the load by 2-3 times.

    W3 Total Cache
    W3 Total Cache
    Developer: BoldGrid
    Price: Free


    2. Reduce the number of database queries

    Each included component, module, plugin or extension is an additional database query. Especially if it is related to any content. Crookedly written modules can do dozens of database queries. For example, the “last records” module can make not 1 query to the database, but as many records as are displayed.

    For example, this one makes about 20 queries:

    What solution? Remove the module, look for another, reduce the number of queries experimentally. You can do the same using the W3 Total Cache plugin or any other caching plugins, just make sure to enable the database caching option in your plugin settings.

    This will surely help you reduce the load on your database by 50-70%.


    3. Block too many active bots

    You need to go to /your_site/access_log and see who is there and what is there. If we find too active bots that are of no use, block them.

    To do this, go to .htaccess and add the following lines:

    RewriteCond% {HTTP_USER_AGENT} PycURL [OR]

    RewriteCond% {HTTP_USER_AGENT} Aport [OR]

    RewriteCond% {HTTP_USER_AGENT} ia_archiver

    PycURL, Aport, ia_archiver are the names of the bots. Each line in the list ends with [OR], and the last is simply the name of the bot.

    By the way, some still suggest ignoring bots through robots.txt, but most bypass these directives.

    If your site consists of 10k + pages, believe me, this will significantly reduce the load. For a large site, even with little traffic, only bots can cause a load that goes beyond the base rate.

    My site is out of season now, traffic is 200 people a day. But access_log has 10,400 entries. Of them:

    • Semrush – 4000
    • GoogleBot – 700
    • Bing – 300
    • DotBot – 500
    • Mail.RU_Bot – 400
    • The remaining 2000 are bots, real people, and more.

    Semrush was previously more modest, but the constant 30% of requests per day of the total number is also a reason to go to the ban. As for YandexNews, which makes a request to the RSS feed, the RSS feed has the latest five news, which makes the load not so noticeable even with 4600 requests per day.

    Semrush, Ahrefs, Megaindex, Linkpad, Moz, etc. – Just parsing your site in order to find out external links and their direction. Whom to block, and whom to leave – of your choice.

    But in any case, using these methods, you can reduce the load and, possibly, return it to the framework of your current tariff.

    Editor's Pick

    Flutter vs Android Studio: Which is Better?

    Here begins the brief assessment of Flutter vs Android Studio. Flutter UI development kit developed by Google. This Flutter framework is...

    Cybersecurity 101 – How to Spot the Most Common Types of Malware

    The internet is a marvelous invention, but just as any great thing in life, it can often be a double-edged sword. You...

    10 Efficient Link Building Tactics for Ecommerce Stores

    Good organic ranking in search engines is essential for any eCommerce business, and link building is a powerful method to achieve it....

    11 Best Video Presentation Softwares To Up Your Presentation Game

    Have you got a major presentation coming up? Wish to attract the attention of your audience? The best way to ensure that...

    Top 3 Cameras For Recording Podcasts in 2020

    Video podcasting is a new and effective way of sharing, and airing your opinions. The platform gives a wide range of advantages...
    How to Reduce the Load on CPU and Database of your Website 2
    Vaibhav Jain
    Vaibhav is a specialist in Website Development whose goal is to never write a boring article. His enthusiasm for online business has spanned over two years, accompanying his articles with thorough knowledge about Website Development and many other topics. He also enjoys playing Cricket and is a Fitness enthusiast.
    Notify of
    Inline Feedbacks
    View all comments
    Would love your thoughts, please comment.x