High CPU Usage on VPS

[LuDo8]

@tut2tut

I just verified with the host and the 3 cores are dedicated not shared. So it seems to be a problem on my end.

@DLow , what kind of mySQL, any ideas where to start?

Thanks.

LuDo8 Reviewed by LuDo8 on 20th Jan 2012. High CPU Usage on VPS Hey guys, I get a lot of CPU spikes and I'm not quite sure how to fix it. http://i.lulzimg.com/2e85d176e2.jpg http://i.lulzimg.com/5b3174e9bc.jpg It constantly goes from very low 0-2% to 50-99% as you can see from the two screenshots. Its a 3GB 3 CPU Core VPS on Centos 5 64bit, Nginx, APC, and MySQL hosting about 2 wordpress sites with a combined daily traffic of about 6k UV/day. For the VPS specs I know for a fact that is plenty of power for just 6k traffic. And the port Rating: 5

[Krun!x]

@tut2tut

I just verified with the host and the 3 cores are dedicated not shared. So it seems to be a problem on my end.

@DLow , what kind of mySQL, any ideas where to start?

Thanks.

VPS doesn't normally come with dedicated CPU cores. What CPU do they run on the Node and how much are you paying? You can check with the following command:
# cat /proc/cpuinfo

You may also want to test drives speed. I/O is most important when it comes to VPS Node.
# dd if=/dev/zero of=test bs=64k count=16k conv=fdatasync

Since you run WordPress, make sure you use one of numerous caching plugins out there. I recommend W3 Total Cache.

[Lock Down]

Do you allow attachments or have any files greater than 4 meg.

This link refers to smf but uses same type vps you have and has adjustments to php that could help. http://www.simplemachines.org/commun...topic=451021.0

[DLow]

As Kruno said, I highly doubt you have actual dedicated CPU's

I also agree with Kruno run the disk i/o test

[LuDo8]

@Lockdown, I don' have any attachments or files available for download so it shouldn't be the problem, but I read through that post and made those edits anyway, hopefully they will make a difference, I will report back on that. Thanks


@Krunix ran the commands you posted:

# cat /proc/cpuinfo
processor       : 0
vendor_id       : GenuineIntel
cpu family      : 6
model           : 30
model name      : Intel(R) Xeon(R) CPU           X3470  @ 2.93GHz
stepping        : 5
cpu MHz         : 2933.392
cache size      : 8192 KB
physical id     : 0
siblings        : 8
core id         : 0
cpu cores       : 4
apicid          : 0
fpu             : yes
fpu_exception   : yes
cpuid level     : 11
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx rdtscp lm constant_tsc nonstop_tsc pni monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr sse4_1 sse4_2 popcnt lahf_lm
bogomips        : 5866.78
clflush size    : 64
cache_alignment : 64
address sizes   : 36 bits physical, 48 bits virtual
power management: [8]

processor       : 1
vendor_id       : GenuineIntel
cpu family      : 6
model           : 30
model name      : Intel(R) Xeon(R) CPU           X3470  @ 2.93GHz
stepping        : 5
cpu MHz         : 2933.392
cache size      : 8192 KB
physical id     : 0
siblings        : 8
core id         : 1
cpu cores       : 4
apicid          : 2
fpu             : yes
fpu_exception   : yes
cpuid level     : 11
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx rdtscp lm constant_tsc nonstop_tsc pni monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr sse4_1 sse4_2 popcnt lahf_lm
bogomips        : 5866.53
clflush size    : 64
cache_alignment : 64
address sizes   : 36 bits physical, 48 bits virtual
power management: [8]

processor       : 2
vendor_id       : GenuineIntel
cpu family      : 6
model           : 30
model name      : Intel(R) Xeon(R) CPU           X3470  @ 2.93GHz
stepping        : 5
cpu MHz         : 2933.392
cache size      : 8192 KB
physical id     : 0
siblings        : 8
core id         : 2
cpu cores       : 4
apicid          : 4
fpu             : yes
fpu_exception   : yes
cpuid level     : 11
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx rdtscp lm constant_tsc nonstop_tsc pni monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr sse4_1 sse4_2 popcnt lahf_lm
bogomips        : 5866.62
clflush size    : 64
cache_alignment : 64
address sizes   : 36 bits physical, 48 bits virtual
power management: [8]

And for the I/O test:

# dd if=/dev/zero of=test bs=64k count=16k conv=fdatasync
16384+0 records in
16384+0 records out
1073741824 bytes (1.1 GB) copied, 8.95598 s, 120 MB/s

dd if=/dev/zero of=test bs=64k count=16k conv=fdatasync
16384+0 records in
16384+0 records out
1073741824 bytes (1.1 GB) copied, 9.02439 s, 119 MB/s

I pay about $45 USD/month (with coupon reg. price is $87/month) it seems the I/O good because most others on WHT get 40-80 MB/s on average and I'm 119+

As for the cores, yea I understand most if not all VPS's do NOT come with dedicated cores but $45 isn't really bargain basement price and I specifically asked if they are dedicated or shared. I even worded it, "so no one else can use these cpu cores, only myself correct? and they told me "yes, only you have access to those cores"

If I disable my sites, cpu usage is zero.

The funny thing is when I enable W3 it brings my site down to a crawl, and if I disable it, it becomes twice as fast.

[LuDo8]

Not sure if this is of any help, but I ran mysqltuner , maybe someone can tell me there's too many connections?

One error I noticed for sure is the maximum possible ram usage allowed which is 10.9Gigs I only have 3Gigs of ram, and have no idea how to lower/edit those mysql settings.

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.1.52-log
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated -InnoDB -ISAM -NDBCluster
[OK] Total fragmented tables: 0

-------- Security Recommendations  -------------------------------------------
ERROR 1142 (42000) at line 1: SELECT command denied to user ''@'localhost' for table 'user'
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 23h 46m 46s (5M q [60.858 qps], 43K conn, TX: 35B, RX: 714M)
[--] Reads / Writes: 97% / 3%
[--] Total buffers: 220.0M global + 70.4M per thread (151 max threads)
[!!] Maximum possible memory usage: 10.6G (353% of installed RAM)
[OK] Slow queries: 0% (0/5M)
[OK] Highest usage of available connections: 16% (25/151)
[!!] Cannot calculate MyISAM index size - re-run script as root user
[OK] Query cache efficiency: 90.9% (4M cached / 5M selects)
[!!] Query cache prunes per day: 165335
[OK] Sorts requiring temporary tables: 7% (6K temp sorts / 88K sorts)
[OK] Temporary tables created on disk: 12% (36K on disk / 291K total)
[OK] Thread cache hit rate: 99% (94 created / 43K connections)
[OK] Table cache hit rate: 65% (120 open / 183 opened)
[OK] Open file limit used: 17% (210/1K)
[OK] Table locks acquired immediately: 99% (986K immediate / 986K locks)

-------- Recommendations -----------------------------------------------------
General recommendations:
    MySQL started within last 24 hours - recommendations may be inaccurate
    Reduce your overall MySQL memory footprint for system stability
    Enable the slow query log to troubleshoot bad queries
Variables to adjust:
  *** MySQL's maximum memory usage is dangerously high ***
  *** Add RAM before increasing MySQL buffer variables ***
    query_cache_size (> 16M)

[Krun!x]

I/O is fairly good.

CPU cores are not dedicated. X3470 has 4 cores in total. If you got 3 dedicated cores for $45 a month they got only 1 core(dedicated right?) to sell.

There are only 2 options.
1) They lied to you.
or
2) They are making a heavy loss on that node.

[DLow]

@ Krun!x

You left out

3) your host has over-sold the hell out of there "node"

[Lock Down]

I think you re mistaken.. FIrst I didn't think there was a way to tell how many cores are allocated to your VPS.

Your calculation should by 2 (cpu) x 4 cores = 8

3 for LuDo8 leaves 5 for everyone else... (guessing of course)

But I would have to agree that greed would dictate they would not give you 3 for $45 but only they know for sure.....

It would seem to me if cpu usage goes through the roof with w3 than there is a w3 plugin or script that has gone wild..

Since I don't use w3 can't help there except to say use top -c to see if you can get more information about the malformed script.

[vikassaini01]

Try mySQL Tuner for mysql, it may fix the issue.