Performance issues (video included)

[ealdridge]

We Currently Have Sugar CRM installed... the mySQL db size is around190MB

Hardware Info:IBM Quad 4 x 1.4Ghz MP Xeon (2.5GB Ram) Raid 5 - 15K Drives....
O/S Info: Red Hat Enterprise Linux ES release 4 (Nahant Update 3)
WebServer: Apache - this only runs our CRM (no other apps / services are running on this server)
PHP Version: 4.3.9
MySQL Version: 4.1.12
Sugar Version: 4.0.0

Just simple tasks as "login" will max the processor out.. this video was taken this morning before any users were logged in ... My next step to try to improve performance is to move the DB to another server...

LINK TO VIDEO AVI FILE (186KB)

[GeneralSmirnov]

Seeing as the httpd process is the cycle burner what version are you running?

[ealdridge]

Seeing as the httpd process is the cycle burner what version are you running?

Server version: Apache/2.0.52

[GeneralSmirnov]

1) Apache 2.2.2 is out
2) Isn't the process name for Apache2 be httpd2 not httpd?
3) The other option is that it is PHP related, which these forums seems to suggest is the case. There are a few suggestions floating around regarding ISAPI modules etc.

[ealdridge]

1) Apache 2.2.2 is out
2) Isn't the process name for Apache2 be httpd2 not httpd?
3) The other option is that it is PHP related, which these forums seems to suggest is the case. There are a few suggestions floating around regarding ISAPI modules etc.

not sure about the "process name",

i just ran this command to get the version

"httpd -version"

and wouldnt (up2date) update apache to the current version? just the other day i ran "up2date -u", im still learning my way around the nix box.... so any suggestions are welcomed

[frb]

Quick hints:
* I tend to use yum instead of up2date
* do install php-eaccelerator
* log4php.properties in debug: see what's happening in there (look for time gaps between lines to spot the part causing the cpu to burn)
* search for other performance/tuning related threads, there are a few others

Franck