To high CPU load
I have a dual Xeon 2.8 ghz server with 1 GB ram, IDE discs. We don't have THAT hight traffic in my point of view but for some reason apache eats alot of CPU.
We have about 35,000 impressions per day. And a maximum of 100 user loggedin to the system at the same time.
Still apache takes 70-90% of the cpu most of the time. My script is fairly large and takes about 20 MB of ram to run.
I've analyzed the script with Zend studio and there shouldn't be any weird loops or crazy sql queries.
1.) Could this be a apache config problem? Or is it simply the load? Could you help me analyze this?
I use "mass dynamical virtualhosts" so virtualhosts shouldn't be a problem.
2.) Do I have to use a separate image server, all httpd sessions look pretty large.
This is a part from the result of the top command...
top - 22:34:15 up 36 days, 12:06, 3 users, load average: 7.25, 6.32, 7.18
Tasks: 153 total, 12 running, 141 sleeping, 0 stopped, 0 zombie
Cpu(s): 89.4% us, 9.1% sy, 0.0% ni, 0.9% id, 0.7% wa, 0.0% hi, 0.0% si
Mem: 1034024k total, 916916k used, 117108k free, 94524k buffers
Swap: 4192944k total, 22392k used, 4170552k free, 277660k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
25721 apache 17 0 33972 21m 12m R 72.3 2.1 0:23.89 httpd
26169 apache 16 0 33940 21m 12m R 70.0 2.1 0:20.53 httpd
23963 apache 16 0 32708 21m 12m R 44.0 2.1 0:30.30 httpd
24071 apache 16 0 32636 20m 12m S 41.1 2.1 0:32.01 httpd
28499 apache 16 0 32796 21m 12m S 34.5 2.1 0:04.96 httpd
28766 mysql 19 0 47544 10m 5232 R 26.3 1.0 0:07.40 mysqld
29042 apache 17 0 33052 21m 12m R 24.0 2.1 0:00.74 httpd
29035 apache 25 0 33172 21m 12m R 22.7 2.1 0:01.11 httpd
28487 apache 20 0 30300 18m 12m R 15.8 1.8 0:01.11 httpd
24086 apache 16 0 32672 20m 12m R 10.2 2.1 0:28.37 httpd
28958 mysql 15 0 47544 10m 5232 S 5.6 1.0 0:00.37 mysqld
29033 mysql 16 0 47544 10m 5232 S 4.6 1.0 0:00.24 mysqld
20091 apache 15 0 32860 21m 12m S 2.3 2.1 1:03.33 httpd
29058 mysql 15 0 47544 10m 5232 S 2.3 1.0 0:00.07 mysqld
20092 apache 16 0 32656 20m 12m S 2.0 2.1 0:46.05 httpd
29059 mysql 15 0 47544 10m 5232 S 1.0 1.0 0:00.03 mysqld
29039 root 16 0 2528 1000 1676 R 0.7 0.1 0:00.07 top
2005 mysql 15 0 47544 10m 5232 S 0.3 1.0 122:35.78 mysqld
24088 apache 15 0 32640 20m 12m S 0.3 2.1 0:33.55 httpd
29065 mysql 16 0 47544 10m 5232 S 0.3 1.0 0:00.01 mysqld
29072 mysql 15 0 47544 10m 5232 S 0.3 1.0 0:00.01 mysqld
top - 22:34:15 up 36 days, 12:06, 3 users, load average: 7.25, 6.32, 7.18
Tasks: 153 total, 12 running, 141 sleeping, 0 stopped, 0 zombie
Cpu(s): 89.4% us, 9.1% sy, 0.0% ni, 0.9% id, 0.7% wa, 0.0% hi, 0.0% si
Mem: 1034024k total, 916916k used, 117108k free, 94524k buffers
Swap: 4192944k total, 22392k used, 4170552k free, 277660k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
25721 apache 17 0 33972 21m 12m R 72.3 2.1 0:23.89 httpd
26169 apache 16 0 33940 21m 12m R 70.0 2.1 0:20.53 httpd
23963 apache 16 0 32708 21m 12m R 44.0 2.1 0:30.30 httpd
24071 apache 16 0 32636 20m 12m S 41.1 2.1 0:32.01 httpd
28499 apache 16 0 32796 21m 12m S 34.5 2.1 0:04.96 httpd
28766 mysql 19 0 47544 10m 5232 R 26.3 1.0 0:07.40 mysqld
29042 apache 17 0 33052 21m 12m R 24.0 2.1 0:00.74 httpd
29035 apache 25 0 33172 21m 12m R 22.7 2.1 0:01.11 httpd
28487 apache 20 0 30300 18m 12m R 15.8 1.8 0:01.11 httpd
24086 apache 16 0 32672 20m 12m R 10.2 2.1 0:28.37 httpd
28958 mysql 15 0 47544 10m 5232 S 5.6 1.0 0:00.37 mysqld
29033 mysql 16 0 47544 10m 5232 S 4.6 1.0 0:00.24 mysqld
20091 apache 15 0 32860 21m 12m S 2.3 2.1 1:03.33 httpd
29058 mysql 15 0 47544 10m 5232 S 2.3 1.0 0:00.07 mysqld
20092 apache 16 0 32656 20m 12m S 2.0 2.1 0:46.05 httpd
29059 mysql 15 0 47544 10m 5232 S 1.0 1.0 0:00.03 mysqld
29039 root 16 0 2528 1000 1676 R 0.7 0.1 0:00.07 top
2005 mysql 15 0 47544 10m 5232 S 0.3 1.0 122:35.78 mysqld
24088 apache 15 0 32640 20m 12m S 0.3 2.1 0:33.55 httpd
29065 mysql 16 0 47544 10m 5232 S 0.3 1.0 0:00.01 mysqld
29072 mysql 15 0 47544 10m 5232 S 0.3 1.0 0:00.01 mysqld
From apache status page:
Parent Server Generation: 7
Server uptime: 3 days 9 hours 35 minutes 12 seconds
Total accesses: 1674901 - Total Traffic: 9.1 GB
CPU Usage: u1613.82 s146.04 cu6.43 cs0 - .601% CPU load
5.7 requests/sec - 32.6 kB/second - 5.7 kB/request
18 requests currently being processed, 9 idle workers
Parent Server Generation: 7
Server uptime: 3 days 9 hours 35 minutes 12 seconds
Total accesses: 1674901 - Total Traffic: 9.1 GB
CPU Usage: u1613.82 s146.04 cu6.43 cs0 - .601% CPU load
5.7 requests/sec - 32.6 kB/second - 5.7 kB/request
18 requests currently being processed, 9 idle workers
# uptime
22:36:54 up 36 days, 12:09, 3 users, load average: 2.82, 5.06, 6.59
22:36:54 up 36 days, 12:09, 3 users, load average: 2.82, 5.06, 6.59
Uptime sometimes show numbers like 10 or 7...
