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 ?
XFileMirror - High CPU Load
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.
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.
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