S
Secret Agent
Guest
I have an issue here that I want to resolve, but want to learn on my own without hiring an admin. I like to learn these things so please help me out if you would.
Problem:
Servre load is constnatly high 95% of the time during the normal business day/hours (at night, its normal oddly). Maybe a cron script, trying to find out. The cpu is the issue here. It ranges between 8 - 12 for several hours, what seems between about 8am - 8pm (just a guess). Every now and then, it WILL go down to normal levels, 2-3 CPU then shoot backup. I am not able to find out what is causing this.
Server Info:
Dual Xeon 2.8Ghz HT
4GB Memory
Dual 300GB SCSI Disks (10k)
32% Drive Usage (Primary)
Kernal
uname -r
2.6.16.1
Centos 4.3
PHP SuExec Support Enabled
PHP 4.4.2
Apache 1.3x
MySQL 4.1x
SuExec enabled
A block of 256 IP addresses (this is a reseller hosting server). Only about 10 or so IP's are not used. The rest (say 85% or so) are for resellers' nameservers while remainder for SSL static IPs.
APF . BFD . LSM . SIM . LES . MOD SECURITY . DOS INFLATE . LIB .
MYSQL QUERIES OPTIMIZED AS OF YESTERDAY ALSO.
/etc/my.cnf
Problem:
Servre load is constnatly high 95% of the time during the normal business day/hours (at night, its normal oddly). Maybe a cron script, trying to find out. The cpu is the issue here. It ranges between 8 - 12 for several hours, what seems between about 8am - 8pm (just a guess). Every now and then, it WILL go down to normal levels, 2-3 CPU then shoot backup. I am not able to find out what is causing this.
Server Info:
Dual Xeon 2.8Ghz HT
4GB Memory
Dual 300GB SCSI Disks (10k)
32% Drive Usage (Primary)
Kernal
uname -r
2.6.16.1
Centos 4.3
PHP SuExec Support Enabled
PHP 4.4.2
Apache 1.3x
MySQL 4.1x
SuExec enabled
A block of 256 IP addresses (this is a reseller hosting server). Only about 10 or so IP's are not used. The rest (say 85% or so) are for resellers' nameservers while remainder for SSL static IPs.
APF . BFD . LSM . SIM . LES . MOD SECURITY . DOS INFLATE . LIB .
MYSQL QUERIES OPTIMIZED AS OF YESTERDAY ALSO.
/etc/my.cnf
Code:
This is my /etc/my.cnf file
[mysqld]
datadir=/var/lib/mysql
skip-locking
#skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=128M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=200
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=256M ## 64MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=4M ## 1MB for every 1GB of RAM
read_buffer_size=4M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=4M ## 1MB for every 1GB of RAM
thread_concurrency=8 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
log_slow_queries=/var/log/mysql-slow-queries.log
long_query_time=2
collation-server=latin1_general_ci
old-passwords
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=256M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=256M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
Attachments
-
7.4 KB Views: 99