it was ALL MySQL processes, at first I was baffled, Top results didn’t show me anything other than a HUGE list of MySQLD processes, here is a copy of Top that I posted on another forum thinking that my message board was behind it…
———-
root@EDM1 [~]# top
top – 13:38:22 up 10 days, 18:44, 2 users, load average: 65.16, 67.69, 44.99
Tasks: 261 total, 66 running, 194 sleeping, 0 stopped, 1 zombie
Cpu(s): 64.1% us, 35.4% sy, 0.0% ni, 0.0% id, 0.0% wa, 0.2% hi, 0.4% si
Mem: 1033784k total, 1029088k used, 4696k free, 85028k buffers
Swap: 2096472k total, 1128k used, 2095344k free, 328000k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
15754 mysql 16 0 60884 36m 3760 R 14.9 3.6 0:03.49 mysqld
15963 mysql 16 0 60628 36m 3760 S 9.4 3.6 0:00.89 mysqld
15926 mysql 15 0 60884 36m 3760 S 8.8 3.6 0:04.54 mysqld
15694 mysql 16 0 60884 36m 3760 R 8.5 3.6 0:04.69 mysqld
15943 mysql 16 0 60628 36m 3760 S 8.5 3.6 0:01.31 mysqld
15946 mysql 16 0 60628 36m 3760 S 8.5 3.6 0:00.81 mysqld
15962 mysql 16 0 60628 36m 3760 S 7.6 3.6 0:00.82 mysqld
15757 mysql 16 0 60884 36m 3760 R 7.3 3.6 0:01.68 mysqld
15756 mysql 16 0 60884 36m 3760 R 7.0 3.6 0:01.70 mysqld
15937 mysql 16 0 60884 36m 3760 R 7.0 3.6 0:01.43 mysqld
Cut for Brevity
———————
So I started digging into MySQL processed and noticed that the running MyDQL processes were ALL from my WordPress accounts. At first, it looked like they were all from the WP-Referral plugin, which I removed from the sites.
Still the load continued to spike like crazy.
Since my forum is my main focus and seeing how wordpress was causing it to come a stand still, so I moved my account via WHM to another server and it’s dropped the CPU load drastically.
Here’s a snippet of top below
#3 Today, 6:05pm
encryption
Member Join Date: May 2005
Age: 29
Posts: 99
UPDATE
——–
It wasn’t vBulletin after all, turns out my Blogging site was sucking up all the resources, I’ve moved it to a different server I own and both servers are performing flawlessly (dunno why). 6 hours at it and it’s fixed.
Here is a snippet of Top now
top – 18:07:46 up 4:23, 1 user, load average: 0.18, 0.15, 0.16
Tasks: 130 total, 1 running, 129 sleeping, 0 stopped, 0 zombie
Cpu(s): 33.3% us, 33.3% sy, 0.0% ni, 33.3% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 1033784k total, 953332k used, 80452k free, 31544k buffers
Swap: 2096472k total, 144k used, 2096328k free, 640412k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
13111 root 16 0 2524 984 1684 R 99.9 0.1 0:00.13 top
1 root 16 0 2036 576 1424 S 0.0 0.1 0:00.63 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.01 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.01 migration/1
5 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
6 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/0
7 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/1
—————-
Has anyone experienced anything like this ?
