Ubuntu / Moodle REALLY SLOOOOWWWWW

Hi All,

I have an Ubuntu 6.06 Lamp Server running Moodle 1.8.2 and have been testing it this morning with a class to see how it handles and to put it mildly VERY BAD.

The server itself is a dual Xeon 3ghz with 2Gb DDR2 memory and 100Gb RAID5 but even with this I am seeing:

Code:

---

top - 10:26:30 up 21:56,  1 user,  load average: 22.63, 12.73, 5.84
Tasks:  74 total,  9 running,  65 sleeping,  0 stopped,  0 zombie
Cpu(s): 98.7% us,  1.3% sy,  0.0% ni,  0.0% id,  0.0% wa,  0.0% hi,  0.0% si
Mem:  2076004k total,  720676k used,  1355328k free,  109156k buffers
Swap:  1469908k total,        0k used,  1469908k free,  135780k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
15765 www-data  16  0 37796  24m 4772 R  46  1.2  1:10.84 apache2
14491 www-data  16  0 40444  27m 4836 R  35  1.3  1:04.42 apache2
16055 www-data  16  0 37236  24m 4688 S  32  1.2  1:00.79 apache2
16069 www-data  16  0 37236  24m 4760 S  18  1.2  1:00.32 apache2
16053 www-data  15  0 39104  25m 4736 S  18  1.3  1:10.59 apache2
16068 www-data  15  0 37552  24m 4740 S  14  1.2  1:10.05 apache2
16036 www-data  16  0 38388  25m 4796 S  11  1.2  1:10.62 apache2
15790 www-data  16  0 37436  24m 4768 R    6  1.2  0:57.44 apache2
15778 www-data  15  0 39040  25m 4760 S    6  1.3  1:01.68 apache2
15788 www-data  15  0 37540  24m 4800 S    5  1.2  1:17.28 apache2
14346 www-data  16  0 41256  27m 3820 R    5  1.3  1:13.78 apache2
13733 www-data  16  0 38364  25m 4740 R    3  1.2  1:06.87 apache2
16058 www-data  15  0 37840  24m 4808 S    1  1.2  1:06.84 apache2
 3862 mysql    15  0  132m  24m 4772 S    1  1.2  0:25.81 mysqld
    1 root      22  0  1568  528  460 S    0  0.0  0:01.52 init
    2 root      RT  0    0    0    0 S    0  0.0  0:00.08 migration/0
    3 root      34  19    0    0    0 S    0  0.0  0:00.00 ksoftirqd/0

---

I really want to use this and get the whole school to use it but if a class of 20 cause this much trouble then I stuck, anyone got any ideas at all??

Can you install apachetop and run that?

sorry geoff where to get it from??

Code:

---

sudo apt-get install apachetop

---

The load average is worryingly high :)

Code:

---

sudo apt-get install apachetop

---

Sorry guys getting the following when trying to run as suggested:

Reading package lists... Done
Building dependency tree... Done
E: Couldn't find package apachetop

??

@Webman: Tell me about it

Enable the 'Universe' repository in your /etc/apt/sources.list

ok have it installed, what is the command to run it??

Have run apachetop but keep getting:

Cannot connect to fam: connection refused

Ooh, I remeber this bug. FAM isn't listed as a dependancy for apachetop (when it really should be).

Code:

---

sudo apt-get install fam

---

:)

Seems it's already there:

Code:

---

Reading package lists... Done
Building dependency tree... Done
fam is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 49 not upgraded.

---

Is it running?

Code:

---

sudo ps aux | grep fam

---

if not

Code:

---

sudo /etc/init.d/fam restart

---

Results of grep fam

Code:

---

root    27210  0.0  0.0  2880  800 pts/0    S+  11:11  0:00 grep fam

---

results of restart

Code:

---

* Restarting file alteration monitor...                                [ ok ]

---

So does apachetop work now?

Hmm...

Would some form of cacheing help... ?

Well if there was an underlying configuration error with PHP, apache or mysql we are better off finding it, rather than papering over the cracks with a reverse proxy or a php accelerator. The machine really should be able to cope with that load.