XFileMirror - High CPU Load

Message
Author
paromi
Posts: 31
Joined: Oct 10, 2011 3:16 pm

High CPU Load

#1 Postby paromi » Jan 23, 2012 2:35 pm

I notice that my server has high CPU load, mainly due to the mysql process witch has >50% cpu load.
here are my mysql processes:


mysql> SHOW PROCESSLIST;
+--------+--------------+-----------+--------------+---------+-------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+--------------+-----------+--------------+---------+-------+-------+------------------+
| 704248 | leechprotect | localhost | leechprotect | Sleep | 10951 | | NULL |
| 732021 | mirrors_db | localhost | mirrors_db | Sleep | 139 | | NULL |
| 752907 | mirrors_db | localhost | mirrors_db | Sleep | 190 | | NULL |
| 767520 | root | localhost | NULL | Query | 0 | NULL | SHOW PROCESSLIST |
+--------+--------------+-----------+--------------+---------+-------+-------+------------------+
4 rows in set (0.00 sec)

and here is the processes running :
http://i.imgur.com/mePGd.png


how can we solve this ?

admin
Site Admin
Posts: 1839
Joined: Mar 22, 2006 12:32 pm

#2 Postby admin » Jan 23, 2012 6:54 pm

Well, not sure what exactly can cause such mysqld load, as there's only 3 sleeping connections. One from leechprotect and two from xfilemirror I guess.
First of all, I would suggest to pay attention on " leechprotect " connection. Because 10951 connection time sounds not really good.

paromi
Posts: 31
Joined: Oct 10, 2011 3:16 pm

#3 Postby paromi » Feb 23, 2012 1:56 pm

any ideeas on how to optimize the upload.cgi script ?

its causes my server to stay on full load nonstop

26414 mirrors 17 0 118m 30m 3276 R 47.0 0.9 9:15.02 upload.cgi
18726 mirrors 17 0 96108 31m 1872 R 34.8 0.9 5:34.61 upload.cgi
30228 mysql 15 0 786m 166m 3604 S 27.0 4.9 8225:19 mysqld


i suspect this causes the upload to not work properly, when users upload a file it gets stuck at 100% and doesent redirect to the downloads page.

this problem is more persisent since you have updated to 1.2 version.

admin
Site Admin
Posts: 1839
Joined: Mar 22, 2006 12:32 pm

#4 Postby admin » Feb 24, 2012 7:52 am

top - 02:29:48 up 70 days, 15:12, 1 user, load average: 1.57, 2.06, 2.65
Tasks: 119 total, 1 running, 117 sleeping, 0 stopped, 1 zombie
Cpu(s): 4.5%us, 1.5%sy, 0.0%ni, 49.2%id, 44.3%wa, 0.0%hi, 0.3%si, 0.2%st
Mem: 3464192k total, 3451296k used, 12896k free, 8668k buffers
Swap: 4192944k total, 3478752k used, 714192k free, 1901152k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
28574 mirrors 34 19 3350m 537m 500 D 0.0 15.9 1:42.15 analog
15924 mysql 15 0 874m 141m 4228 S 6.0 4.2 3:56.58 mysqld
6163 mirrors 15 0 132m 43m 3360 S 0.0 1.3 6:30.14
upload.cgi
19276 mirrors 16 0 138m 33m 2684 S 0.7 1.0 34:03.57 upload.cgi