Get the most out of your Centmin Mod LEMP stack
Become a Member

Wordpress Normal site but mysql load like crazy

Discussion in 'Blogs & CMS usage' started by YuchiRO, Mar 24, 2016.

  1. YuchiRO

    YuchiRO Member

    93
    6
    8
    Jan 12, 2015
    Ratings:
    +8
    Local Time:
    8:25 PM
    5.5.4
    Hi
    My site is wordpress and i dont use option 22 to install, i install manually :) (i dont know option 22 when i install my site)

    Everything work like normal but

    top - 14:46:54 up 8 min, 1 user, load average: 9.17, 7.53, 3.86
    Tasks: 203 total, 1 running, 202 sleeping, 0 stopped, 0 zombie
    Cpu(s): 52.0%us, 10.0%sy, 0.0%ni, 7.5%id, 29.6%wa, 0.0%hi, 0.3%si, 0.5%st
    Mem: 8058916k total, 1504940k used, 6553976k free, 182472k buffers
    Swap: 4194300k total, 0k used, 4194300k free, 293508k cached

    Why load average alway higher than 2 :(, at this time i have 75 user online. And mysql load 180% CPU. I dont use woocommerce. Just normal wordpress site :)

    What i need to check to ensure my vps is overload and need to be upgrade or something went wrong ?

    Thanks
     
  2. YuchiRO

    YuchiRO Member

    93
    6
    8
    Jan 12, 2015
    Ratings:
    +8
    Local Time:
    8:25 PM
    5.5.4
    My vps has 8 core and 8Gb ram :) and about 6k visit per day.

    Nginx 1.9.9 and Centmin Mod 1.2.3-eva2000.08
     
  3. eva2000

    eva2000 Administrator Staff Member

    30,850
    6,905
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,396
    Local Time:
    11:25 PM
    Nginx 1.13.x
    MariaDB 5.5
    CPU load optimal is 1.0 per cpu thread so 8 cpu thread normal = 8x1 = 8.0. 16 cpu server normal is 16x1 = 16.0

    so cpu load of 8 for
    • 2 cpu server = 8/2 = 4.0 load average
    • 4 cpu server = 8/4 = 2.0 load average
    • 8 cpu server = 8/8 = 1.0 load average
    When you type top command, hit number 1 to break down per cpu stats

    Centmin Mod is provided as is, so troubleshooting load issues is left to end user to do. However, there's many linux tools and scripts that can help you figure out what was causing the load issues and when.

    If you're providing info on this forum, more info might be helpful
    1. What version of Centmin Mod ? .08 stable or .09 beta ? If .09 beta when was it installed and when was last time you updated ?
    2. What's your VPS/Server hardware specifications ? cpu type ? memory available ? disk space ?
    3. Who's your web host ? Different hosts have different limits for server resource usage and some are more restrictive that others so it could just be their resource usage policy you tripped which may or may not be restrictive. If restrictive, then real solution would be finding a better web host. If not restrictive, then it's finding out what caused high cpu load.
    Tools and commands you will want to read up on and learn for basic system admin tasks and troubleshooting.
    Notes:
     
  4. YuchiRO

    YuchiRO Member

    93
    6
    8
    Jan 12, 2015
    Ratings:
    +8
    Local Time:
    8:25 PM
    5.5.4
    1. I used 08 stable

    2. My top 1 comand
    top - 15:40:03 up 1:01, 1 user, load average: 5.63, 7.94, 9.06
    Tasks: 201 total, 2 running, 199 sleeping, 0 stopped, 0 zombie
    Cpu0 : 41.3%us, 9.7%sy, 0.0%ni, 47.0%id, 1.3%wa, 0.0%hi, 0.0%si, 0.7%st
    Cpu1 : 55.3%us, 12.3%sy, 0.0%ni, 24.0%id, 7.0%wa, 0.0%hi, 0.7%si, 0.7%st
    Cpu2 : 55.4%us, 11.7%sy, 0.0%ni, 25.2%id, 6.7%wa, 0.0%hi, 0.3%si, 0.7%st
    Cpu3 : 43.5%us, 9.7%sy, 0.0%ni, 36.5%id, 9.0%wa, 0.0%hi, 0.7%si, 0.7%st
    Cpu4 : 44.3%us, 8.7%sy, 0.0%ni, 35.2%id, 10.7%wa, 0.0%hi, 0.3%si, 0.7%st
    Cpu5 : 44.3%us, 11.3%sy, 0.0%ni, 35.0%id, 8.3%wa, 0.0%hi, 0.3%si, 0.7%st
    Cpu6 : 46.3%us, 10.3%sy, 0.0%ni, 36.3%id, 6.7%wa, 0.0%hi, 0.0%si, 0.3%st
    Cpu7 : 45.2%us, 8.4%sy, 0.0%ni, 35.5%id, 10.0%wa, 0.0%hi, 0.3%si, 0.7%st
    Mem: 8058916k total, 5224640k used, 2834276k free, 331476k buffers
    Swap: 4194300k total, 0k used, 4194300k free, 3665524k cached

    3. I used leaseweb XL Virutal server with Processor: Xeon E5 - that all they told me about CPU :(, 8 core 8gb 160gb ssd.
     
  5. YuchiRO

    YuchiRO Member

    93
    6
    8
    Jan 12, 2015
    Ratings:
    +8
    Local Time:
    8:25 PM
    5.5.4
    Hi @eva2000

    This is normal and dont need to upgrade to higher vps or move to new dedicate server ? Sometime my site slow down to more a minute to complete load.

    Thanks :)
     
  6. eva2000

    eva2000 Administrator Staff Member

    30,850
    6,905
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,396
    Local Time:
    11:25 PM
    Nginx 1.13.x
    MariaDB 5.5
    less than <8.0 cpu load is normal on 8 cpu thread server 8/8 = 1.0 cpu load average. Above 8+ then yes higher load i.e. cpu load of 10 = 10/8 = 1.25 cpu load average
     
  7. YuchiRO

    YuchiRO Member

    93
    6
    8
    Jan 12, 2015
    Ratings:
    +8
    Local Time:
    8:25 PM
    5.5.4
    Thanks, i learn a lot when i join this forum :) and each your reply i lear more than one line you wrote.

    With 8 core i5 8Gb ram, and 80 online same time, my load average about 13-16 that's is not normal right ? I need upgrade my vps or i need to look all my config services ? At this time mysql load 200%.

    Thanks
     
  8. eva2000

    eva2000 Administrator Staff Member

    30,850
    6,905
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,396
    Local Time:
    11:25 PM
    Nginx 1.13.x
    MariaDB 5.5