Hello,
We are running a Cobalt Raq 4r with 512mb ram and 2 30GB Raid HD's. We have been experiencing extremely high loads lately, above 4 most of the time. One time, it was:
1 minute load average: 0.21
5 minute load average: 18.44
15 minute load average: 31.54

We know that the causes could be cgi scripts, mysql databases, but how do we know exactly what is causing it. Such as, exactly "what" script is causing the problem. I am extremely interested into knowing this. If anyone can help, please let me know.

I have used the command "top" in the shell but it doesn't help us too much. Is there any way of knowing what CGI script could cause this? (Or any other script for that matter)

ps aux | grep perl

If you are in the top command screen you can hit the "c" key and this will show the full path to the script with each process. This will help idendity the culprit.

Make sure you have tweaked settings in your MySql config file (/etc/my.cnf) - you'd be amazed at how it can affect load averages.

Although from my experience I have found that some perl scripts can be huge resource hogs on Raqs.....

I have the same problem... my raq4 is always 8 - 9 load averaged and at trafic hours it peaks 17 - 19

Is there any preset my.cnf for raq4 and raq3?

Could you post here your personal mysql configurations?

I am also running MYSQL with the default configuration and don't know exactly what to touch to tweak it. i have seen there are predefined confs for huge medium and small sites...

which one do you recommend for a Raq4 512 mb ram with intensive use of PHP and MYSQL? also for a raq3 ...

Thanks,

Here is my my.cnf:


[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server

[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = key_buffer=20M
set-variable = max_allowed_packet=1M
set-variable = table_cache=128
set-variable = sort_buffer=4M
set-variable = net_buffer_length=16K
log-bin
server-id = 1

# Point the following paths to different dedicated disks
tmpdir = /tmp/

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
set-variable = key_buffer=32M
set-variable = sort_buffer=4M
set-variable = read_buffer=8M
set-variable = write_buffer=4M

[myisamchk]
set-variable = key_buffer=70M
set-variable = sort_buffer=36M
set-variable = read_buffer=14M
set-variable = write_buffer=4M

[mysqlhotcopy]
interactive-timeout

set-variable = max_connections=200
set-variable = record_buffer=4M
set-variable = thread_stack=256K
set-variable = wait_timeout=20


I mainly run vbulletin with mod gzip enabled and persistent connections disabled.

I have a RAQ3 with 512 megs ram - usually my load is between 3 and 8 during peak periods (100+ people in the forums)

Try it with those settings..

Even if you don't run vbulletin you might want to check http://vbulletin.com/forum/forumdisplay.php?s=&forumid=14 for mysql/apache configuration tips - a lot of people there also have raqs.

Hi

I'm very interested in installing mod_gzip on a RaQ3 but it seems it won't work with the apache which is installed.

Did you have to compile a newer apache on your RaQ3?
If not, how did you get mod_gzip running?

Thanks a lot!
Marc

mod_gzip (apache module) doesn't work with Apache 1.3.6

You find here instructions to upgrade Apache on your RaQ3:
http://www.sakuralover.com/raq3/upgrade_raq3.htm

The instructions work also with newer versions of Apache. I installed couple of months ago Apache 1.3.20 on my RaQ3 :)

Thanks a lot for your quick reply!

Is it really necessary to install all this additional stuff:
-openssl
-mod_ssl
-mod_perl
-mod_pam

I mean this modules are already installed on the RaQ, aren't they?


Did you exactly do what is described in this HOWTO? Did you haveno problems at all after your upgrade?


TIA
Marc

I mean this modules are already installed on the RaQ, aren't they?
Yes, but they are older versions of the modules

Did you exactly do what is described in this HOWTO?

I followed the instructions but used newer versions of the modules:

Apache/1.3.20
PHP/4.0.5
mod_perl/1.25
mod_auth_pam/1.0a
mod_ssl/2.8.4
OpenSSL/0.9.6a

Did you haveno problems at all after your upgrade?
No, everything works fine :)