WordPress.org

Support

Support » How-To and Troubleshooting » High load, lots of MySQL queries

High load, lots of MySQL queries

  • 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:

    View post on imgur.com

    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!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator Mark Ratledge

    @songdogtech

    Forum Moderator

    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?

    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?

    Moderator Mark Ratledge

    @songdogtech

    Forum Moderator

    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.

    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.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘High load, lots of MySQL queries’ is closed to new replies.
Skip to toolbar