/ Register

Learn about Centmin Mod LEMP Stack today
Register Now

Wordpress Normal site but mysql load like crazy

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

Previous Thread Next Thread
Loading...
  1. Mar 24, 2016 #1
    YuchiRO

    YuchiRO Member

    100
    6
    18
    Jan 12, 2015
    Ratings:
    +8
    Local Time:
    5:35 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. Mar 24, 2016 #2
    YuchiRO

    YuchiRO Member

    100
    6
    18
    Jan 12, 2015
    Ratings:
    +8
    Local Time:
    5:35 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. Mar 24, 2016 #3
    eva2000

    eva2000 Administrator Staff Member

    55,182
    12,251
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,829
    Local Time:
    8:35 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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. Mar 24, 2016 #4
    YuchiRO

    YuchiRO Member

    100
    6
    18
    Jan 12, 2015
    Ratings:
    +8
    Local Time:
    5:35 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. Mar 25, 2016 #5
    YuchiRO

    YuchiRO Member

    100
    6
    18
    Jan 12, 2015
    Ratings:
    +8
    Local Time:
    5:35 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. Mar 25, 2016 #6
    eva2000

    eva2000 Administrator Staff Member

    55,182
    12,251
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,829
    Local Time:
    8:35 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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. Mar 25, 2016 #7
    YuchiRO

    YuchiRO Member

    100
    6
    18
    Jan 12, 2015
    Ratings:
    +8
    Local Time:
    5:35 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. Mar 25, 2016 #8
    eva2000

    eva2000 Administrator Staff Member

    55,182
    12,251
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,829
    Local Time:
    8:35 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
Previous Thread Next Thread
Loading...

.