LeeS
Thu 4th Sep '03, 7:26am
Due to a kernel panic problem our box recently had to be re-installed (Ensim, from RackShack). We had this problem partially, but nowhere near as bad before, where every couple of days to a week, the httpd would die and need to be restarted and the semaphores cleared out.
While I haven't had to touch the semaphores as yet, apache is dying as much as once every 45 minutes now. There is nothing 'wrong' with apache, it's a good, clean, ensim cd-rom restore that ran fine for 5 days during testing. Only when we released vB3 to the masses, did we start getting problems.
Our users are starting to get pissed with the continual down time, but I don't know what do to. Anyone?
Some stats:
Single P4 2.4GHz, 1024mb ram, 60gb hard disk (2x).
Apache 1.3.27, PHP 4.2.2, MySQL 3.23.56.
Usually around 200 people surfing at the same time.
Current my.cnf
---
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
tmpdir=/tmp
set-variable = max_connections=400
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=2M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=128
set-variable = wait_timeout=3600
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
httpd.conf (pertinent parts)
---
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 150
While I haven't had to touch the semaphores as yet, apache is dying as much as once every 45 minutes now. There is nothing 'wrong' with apache, it's a good, clean, ensim cd-rom restore that ran fine for 5 days during testing. Only when we released vB3 to the masses, did we start getting problems.
Our users are starting to get pissed with the continual down time, but I don't know what do to. Anyone?
Some stats:
Single P4 2.4GHz, 1024mb ram, 60gb hard disk (2x).
Apache 1.3.27, PHP 4.2.2, MySQL 3.23.56.
Usually around 200 people surfing at the same time.
Current my.cnf
---
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
tmpdir=/tmp
set-variable = max_connections=400
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=2M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=128
set-variable = wait_timeout=3600
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
httpd.conf (pertinent parts)
---
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 150