Server CPU loads 750% most of time by mysql

  • Hello,
    From 2 weeks i have a big problem with my WP installation. I have installed wp in a dedicated server with 16GB ram, Quad-Core, 16mbps international bandwidth. It worked correctly until i upgraded from 3.9 to 4.0 and now, it has a super high cpu loading caused by mysql. Most of the time, i saw it to raise up to 750% (seen via top command on ssh).
    I have installed and running this plugins:
    Dashboard sticky note
    Facebook
    jNewsticker for WordPress
    Currency Exchange (made by me)
    Login with Ajax
    Query Monitor
    Regenerate thumbnails
    Weather widget estonac weather
    Widget Logic
    Wp-Optimize
    Wp-Pagenavi
    WPML Multilingual CMS
    Wp Super cache
    Wp to twitter

    The website is done for a News Agency company and has 1 year up and running. Now, in the system are about 32.000posts in three different languages.
    I have tried to disable all the plugins but seems that the fault is not comming from a plugin. Wp Super Cache is up and running, and i have up to 35visitors online all the time.
    I have tried everything that i have found in the internet regarding the same issue, but i had no succes yet. The site works fine for some minutes and, instantly, overloads the cpu.
    The server is build in Centos 6, and running Virtualmin for control panel.
    Hope that i have gave all the needed informations, and someone can help me on this issue.
    Thank you in advance ??

Viewing 2 replies - 1 through 2 (of 2 total)

  • What SQL queries are using that much CPU? You should be able to view the top queries for something like mytop etc.

    You may also be able to configure your mysql tmpdir to RAM for faster processing as you have 16GB of RAM.

    Side note, and I’m not sarcastic, did you try rebooting the server ? There’s always the possibility of a process gone mad while looking like the usual apache instances, or even of an injection leading to nasty processes running hidden in background, that will be gone after a reboot.

    You may also to to find if there isn’t a bottleneck you haven’t noticed. Heck, there can be hundred possible bottleneck causes, you know.
    Adding Munin for instance for hardware and software monitoring (like accesses/second, processes, IOs/second R/W, Munin processing time, mysql queries/second, mysql slow queries/second, mysql threads, http loadtime of a page, processes fork rate/second, number of threads, CPU % usage, Memory usage).
    Running mysqltuner.pl, tuning-primer.sh and apachebuddy.pl to see if they don’t highlight some configured limits are way too low.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Server CPU loads 750% most of time by mysql’ is closed to new replies.

Tags