[resolved] Host problem with WordPress blog (3 posts)

  1. TabrezIqbal
    Posted 9 years ago #

    I think this happens one or the other time with every one whose blog is hosted under shared hosting.

    One of my articles got dugg yesterday and resulted in quite a few hits for the next 24 hrs(~5000). Very soon I also recieved an email from my hosting provider(siteground) that the traffic has caused the server to get overloaded and has affected the performance of other websites including mine. The usual stuff.

    The only useful information that they have provided me with was that my website contains a large number of internal links(270 is their count) and they result in large number of simultaneous MySQL queries.

    Is there any caveat regarding how many internal links should be there on a website for X amount of server resources? Is the number of internal links on my blog too high? Or am I/SiteGround missing any database optimization tricks(which could be the actual culprit)?

    Any help is appreciated.
    Thank you,

  2. yosemite
    Posted 9 years ago #

    Install wp-cache? This is a common solution for your circumstances...

  3. TabrezIqbal
    Posted 9 years ago #

    Oh great, I was also thinking on the same lines. If the database is being accessed by wordpress + plugins for the links displayed on a page every single time it is loaded, then its a total waste of CPU cycles as well as the database queries. I thought WordPress already does the caching for such things in wp-content/cache directory. Hope to have a smooth time with WP-Cache plugin.

    Thank you very much.

    PS: Is there a simple way(a couple of function calls here n there) to record every database query sent by wordpress to mysql and the time taken by them into a log file? Like we generally use the following code to output the no of queries and time taken for a page load:
    echo $wpdb->num_queries;

    Anyone packaged this for the entire website?

Topic Closed

This topic has been closed to new replies.

About this Topic