High load, lots of MySQL queries

  • s1h4d0w

    (@s1h4d0w)


    11 years, 2 months 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:

    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)
  • Mark Ratledge

    (@songdogtech)

    11 years, 2 months ago

    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?

    Thread Starter s1h4d0w

    (@s1h4d0w)

    11 years, 2 months 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?

    Mark Ratledge

    (@songdogtech)

    11 years, 2 months ago

    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.

    Thread Starter s1h4d0w

    (@s1h4d0w)

    11 years, 2 months 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.

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