berberber
07-01-2004, 01:34 PM
Hello every body.
My problem is very common, as a lot of threats about this topic already exist, I read a lot of them, but It is really hard to find out the right solution..
My server (I cannot afford bigger)
2 Gz celeron
256 Mo RAM
Plesk 7.0.3
Latest Redhat
Mysql 4.0.2 ( i ll ask my hoster to upgrade tonight to 4.1)
any websites, one of them with the images script 4images
so, after a few minuts, (can be hours), evrything becomes very slow and the load average goes subitly from 1 to 70, until I restart Apache,
then the proccess begins again.
as It works fine first, I think It must be a configuration issue. (don't say me please again I need 1 Gb RAM, it's too expensive for me)
in the httpd.conf file :
Timeout 60
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
StartServers 8
MinSpareServers 10
MaxSpareServers 20
MaxClients 150
MaxRequestsPerChild 1000
StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
and my my.conf looks like that
[mysqld]
query-cache-type = 1
query-cache-size = 100M
default-character-set=latin1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb
skip-networking
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
max_connections=300
Can anybody help me ?
Thanks, Bernhard
My problem is very common, as a lot of threats about this topic already exist, I read a lot of them, but It is really hard to find out the right solution..
My server (I cannot afford bigger)
2 Gz celeron
256 Mo RAM
Plesk 7.0.3
Latest Redhat
Mysql 4.0.2 ( i ll ask my hoster to upgrade tonight to 4.1)
any websites, one of them with the images script 4images
so, after a few minuts, (can be hours), evrything becomes very slow and the load average goes subitly from 1 to 70, until I restart Apache,
then the proccess begins again.
as It works fine first, I think It must be a configuration issue. (don't say me please again I need 1 Gb RAM, it's too expensive for me)
in the httpd.conf file :
Timeout 60
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
StartServers 8
MinSpareServers 10
MaxSpareServers 20
MaxClients 150
MaxRequestsPerChild 1000
StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
and my my.conf looks like that
[mysqld]
query-cache-type = 1
query-cache-size = 100M
default-character-set=latin1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb
skip-networking
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
max_connections=300
Can anybody help me ?
Thanks, Bernhard