High load problem

[sis.argentina]

Hello everyone, I have a high load on my server, it is running
apache 1.3.37
mysql 4.1.21
PHP Version 4.4.4
Exim 4.60
dovecot 1.0.rc12
Spamassassin 3.2

Hardware:
Intel Pentium Dual Core 2.6Ghz
1Gb Ram

This server had almost 100 domains and has a high load because (I think) one domain is doing several queries and is running various php scripts.

I need to optimize apache, exim, (mysql already optimized).

In the attachment you have the output of top command, exim.conf, my.cnf and httpd.conf.

I need your help, thanks.

 

[rohit]

i looked at the top.txt and it only has a load of .68, which is not that too high. I am pretty much sure that there are users with servers with over 1 or 2 as their average server load.

Definitely mysql is taking the most of CPU, so do some mysql query logging and see which all queries are taking the most of the time and then get the client to index the field in those tables. Indexing will increase the speed of the queries and will lower the mysql load too.

Just my suggestion!!

 

[sis.argentina]

Thanks Rohit, the top.txt does not show my case, I made a mistake with the file of another server. In fact, the server with the problem has a load of 5.0 to 20.0 at rush hours.

Do you see my httpd.conf and my.cnf? What do you think?

Also I have a lot of spamd processes, any suggestion?

 

[nobaloney]

Try to optimize MySQL following the instructions here.

As far as spamd is concerned, yes a lot of spamd processes can cause problems.

I recommend not running SpamAssassin unless you've also got SpamBlocker turned on for all your domains; otherwise you may be simply overpowering your processor with processes.

Jeff

 

[sis.argentina]

Thanks Jeff, if you see my first attachtment, my my.cnf has been optimized with the post http://help.directadmin.com/item.php?id=44

I tried with the Status-Extended off, and the server worked better, but I still have problems with the spamd, I will try spamblocker.

Thanks for your comments, if anybody have the same problem please post here and together will find the better configuration for high performance.

 

[Knarsa]

Old thread but ..

Should I replace my ald my.cnf with this one or just add this line into my old?

Try to optimize MySQL following the instructions here.

As far as spamd is concerned, yes a lot of spamd processes can cause problems.

I recommend not running SpamAssassin unless you've also got SpamBlocker turned on for all your domains; otherwise you may be simply overpowering your processor with processes.

Jeff