Guy i need opinion :
I own a dedi with one large WP site, other then hosting the site, my dedi also doing scrapping job .... but recently i face some problem, when my scrapping script run, it will overload my dedi resource (base on my hosting company explanation ) ...
MYSQL Load Log :
My server info :Code:top - 23:18:17 up 117 days, 7:01, 2 users, load average: 11.54, 11.76, 15.92 Tasks: 238 total, 3 running, 235 sleeping, 0 stopped, 0 zombie Cpu(s): 24.9%us, 8.1%sy, 0.0%ni, 65.3%id, 1.6%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 8184916k total, 6305772k used, 1879144k free, 290576k buffers Swap: 8385848k total, 150664k used, 8235184k free, 2522844k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 28983 mysql 15 0 2246m 1.7g 4552 S 373.0 21.4 3662:47 mysqld 24731 apache 16 0 130m 28m 4044 S 13.8 0.4 0:00.70 httpd 24852 apache 18 0 118m 15m 3344 R 5.9 0.2 0:00.05 httpd 579 root 10 -5 0 0 0 S 2.0 0.0 20:59.28 md3_raid1 1898 root 10 -5 0 0 0 D 2.0 0.0 30:23.46 kjournald 24859 root 15 0 12736 1092 716 R 2.0 0.0 0:00.01 top 1 root 15 0 10348 104 72 S 0.0 0.0 2:03.63 init 2 root RT -5 0 0 0 S 0.0 0.0 0:01.41 migration/0 3 root 34 19 0 0 0 S 0.0 0.0 0:03.17 ksoftirqd/0 4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/0 5 root RT -5 0 0 0 S 0.0 0.0 0:01.04 migration/1 6 root 34 19 0 0 0 R 0.0 0.0 0:00.66 ksoftirqd/1 7 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/1 8 root RT -5 0 0 0 S 0.0 0.0 0:02.41 migration/2 9 root 34 19 0 0 0 S 0.0 0.0 1:27.58 ksoftirqd/2 10 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/2 11 root RT -5 0 0 0 S 0.0 0.0 0:01.03 migration/3 MySQL is using 374% of the CPU.
Processor Name Intel(R) Xeon(R) CPU X3330 @ 2.66GHz
Vendor ID GenuineIntel
Processor Speed (MHz) 2667.000
Total Memory 8184916 kB
Free Memory 1159572 kB
Total Swap Memory 8385848 kB
Free Swap Memory 8235184 kB
So my hosting company advice me to add another dedi to do scrapping job and this server just for publishing job.
But i'm not sure should trust the hosting guy or not ? cause adding another server means, i need manually upgrade my db + images from one server to another server, for me it seem like doing another redundant job, do i have another alternative ??
thanks in advance ...


LinkBack URL
About LinkBacks
Reply With Quote

Bookmarks