WordPress.org

Ready to get started?Download WordPress

Forums

High load, lots of MySQL queries (5 posts)

  1. s1h4d0w
    Member
    Posted 1 year ago #

    Hey everyone,

    My hosting provider has taken down my website a few times now because of it creating a high load on the server. I'm running an up to date version of WordPress with a lot of plugins because it's a Wiki like website.

    These are some of the queries that run when the website causes a high load:

    | 2478 | desig140 | localhost | desig140_afwiki | Query | 4 | query end | insert into wp_wfLeechers (eMin, IP, hits) values (floor(unix_timestamp() / 60), 1314062157, 1) ON D |
    | 2480 | desig140 | localhost | desig140_afwiki | Query | 1 | Opening tables | SELECT post_id, meta_value FROM wp_postmeta WHERE meta_key = '_links_to_target'
    | 2494 | desig140 | localhost | desig140_afwiki | Query | 1 | Opening tables | SELECT option_value FROM wp_options WHERE option_name = 'seo_ultimate_module_noindex' LIMIT 1 |
    | 2504 | desig140 | localhost | desig140_afwiki | Query | 1 | Opening tables | SELECT option_value FROM wp_options WHERE option_name = 'su_settings' LIMIT 1 |

    Here's a list of my installed & activated plugins:

    http://i.imgur.com/fUhNboJ.jpg

    Can someone help me out with this? I've been having this problem for months now and I get about 5000-10000 pageviews each day. I have no idea what is causing this and would love to hear your opinion. I'd be forever grateful.

    Thank you!

  2. I'm running.... a lot of plugins

    Look at the queries you posted; they are run by your plugins. If you need that many plugins, find a better web host or use a VPS. This has little to do with WordPress itself and everything to do with the number of plugins causing the load. Who is the web host?

  3. s1h4d0w
    Member
    Posted 1 year ago #

    Thanks for the answer, it's Neostrada.nl a Dutch webhosting company. I've had service from them for years now and am reluctant to switch hosting companies. The strange thing is that it only seems to happen once a while. I recently reached 13000 pageviews on a single day and didn't have any problems.

    Is there any way the hosting company or I myself can collect more information?

  4. The strange thing is that it only seems to happen once a while.

    Tell them to look in the server logs.

    ...am reluctant to switch hosting companies

    With that amount of traffic, a wiki and forum and those plugins on a cheap shared host, you need to change to a VPS.

  5. s1h4d0w
    Member
    Posted 1 year ago #

    Thank you, I'll email my hosting provider and see what they can do for me. They've always been very helpful and professional so I'm sure I can work something out with them.

    I've been getting a steady stream of income from Adsense so I might be able to afford a more expensive hosting solution.

Topic Closed

This topic has been closed to new replies.

About this Topic