Server Optimization Request

محروم.كوم · #1 07-29-2009, 09:30 PM

<div>Server is brand new, a few days old, but crashing every once in awhile.

Last crash, I grabbed this string. I've made some changes since to alleviate things (I hope).

Quote:
top - 08:16:37 up 16:56, 1 user, load average: 29.41, 35.30, 58.28
Tasks: 435 total, 14 running, 417 sleeping, 0 stopped, 4 zombie
Cpu0 : 12.7%us, 75.0%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 12.3%si, 0.0%st
Cpu1 : 6.4%us, 93.6%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 1.5%us, 87.7%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 10.8%si, 0.0%st
Cpu3 : 2.5%us, 93.6%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 4.0%si, 0.0%st
Mem: 12298820k total, 12188136k used, 110684k free, 26104k buffers
Swap: 2040212k total, 2040212k used, 0k free, 33064k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
19980 root 15 0 153m 105m 492 S 0.0 0.9 8:15.34 /usr/local/sbin/clamd
26285 nobody 16 0 251m 90m 76 S 0.0 0.8 0:02.74 /usr/local/apache/bin/httpd -k start -DSSL
26249 nobody 16 0 252m 90m 80 S 0.0 0.8 0:01.97 /usr/local/apache/bin/httpd -k start -DSSL
27962 mailnull 16 0 225m 74m 3172 S 3.5 0.6 0:10.81 MailScanner: checking with Spam Lists
27734 mailnull 16 0 225m 74m 3156 D 1.0 0.6 0:10.21 MailScanner: waiting for messages
28178 mailnull 18 0 225m 73m 3116 S 0.5 0.6 0:13.66 MailScanner: checking with SpamAssassin
29987 mailnull 19 0 228m 72m 1520 S 0.0 0.6 0:00.00 MailWatch SQL
30297 mailnull 19 0 225m 72m 1816 S 3.5 0.6 0:00.07 MailScanner: checking with SpamAssassin
30385 mailnull 16 0 225m 71m 648 S 0.0 0.6 0:00.00 MailScanner: checking with Spam Lists
24961 nobody 16 0 228m 68m 76 S 0.0 0.6 0:05.22 /usr/local/apache/bin/httpd -k start -DSSL
25638 nobody 16 0 228m 68m 72 S 0.0 0.6 0:00.92 /usr/local/apache/bin/httpd -k start -DSSL
24937 nobody 16 0 228m 68m 76 S 0.0 0.6 0:03.86 /usr/local/apache/bin/httpd -k start -DSSL
25305 nobody 16 0 228m 68m 76 S 0.0 0.6 0:02.65 /usr/local/apache/bin/httpd -k start -DSSL
24773 nobody 16 0 230m 68m 80 S 0.0 0.6 0:07.08 /usr/local/apache/bin/httpd -k start -DSSL
25326 nobody 16 0 228m 68m 76 S 0.0 0.6 0:04.39 /usr/local/apache/bin/httpd -k start -DSSL
25403 nobody 16 0 228m 68m 76 S 0.0 0.6 0:00.92 /usr/local/apache/bin/httpd -k start -DSSL
24762 nobody 16 0 230m 68m 84 S 0.0 0.6 0:07.79 /usr/local/apache/bin/httpd -k start -DSSL
25359 nobody 16 0 228m 68m 76 S 0.0 0.6 0:02.34 /usr/local/apache/bin/httpd -k start -DSSL
25635 nobody 16 0 228m 68m 76 S 0.0 0.6 0:01.02 /usr/local/apache/bin/httpd -k start -DSSL
25356 nobody 16 0 228m 68m 76 S 0.0 0.6 0:01.47 /usr/local/apache/bin/httpd -k start -DSSL

25130 nobody 16 0 227m 67m 76 S 0.0 0.6 0:06.12 /usr/local/apache/bin/httpd -k start -DSSL
25388 nobody 16 0 229m 67m 80 S 0.0 0.6 0:01.42 /usr/local/apache/bin/httpd -k start -DSSL
24668 nobody 16 0 227m 67m 76 S 0.0 0.6 0:01.55 /usr/local/apache/bin/httpd -k start -DSSL
25340 nobody 16 0 227m 67m 76 S 0.0 0.6 0:01.60 /usr/local/apache/bin/httpd -k start -DSSL
25614 nobody 16 0 227m 67m 72 S 0.0 0.6 0:01.40 /usr/local/apache/bin/httpd -k start -DSSL
26143 nobody 16 0 221m 61m 72 S 0.0 0.5 0:00.51 /usr/local/apache/bin/httpd -k start -DSSL
26164 nobody 17 0 221m 61m 76 S 0.0 0.5 0:01.79 /usr/local/apache/bin/httpd -k start -DSSL
26250 nobody 19 0 221m 61m 76 S 0.0 0.5 0:02.75 /usr/local/apache/bin/httpd -k start -DSSL
26171 nobody 16 0 221m 60m 76 S 0.0 0.5 0:00.50 /usr/local/apache/bin/httpd -k start -DSSL
25857 nobody 16 0 219m 60m 76 S 0.0 0.5 0:00.65 /usr/local/apache/bin/httpd -k start -DSSL
25940 nobody 16 0 219m 60m 76 S 0.0 0.5 0:00.59 /usr/local/apache/bin/httpd -k start -DSSL
25555 nobody 18 0 219m 60m 72 S 0.0 0.5 0:00.54 /usr/local/apache/bin/httpd -k start -DSSL
26228 nobody 17 0 219m 60m 72 S 0.0 0.5 0:01.76 /usr/local/apache/bin/httpd -k start -DSSL
26229 nobody 20 0 219m 60m 76 S 0.0 0.5 0:04.66 /usr/local/apache/bin/httpd -k start -DSSL
25455 nobody 22 0 219m 59m 72 S 0.0 0.5 0:00.53 /usr/local/apache/bin/httpd -k start -DSSL
25530 nobody 23 0 219m 59m 72 S 0.0 0.5 0:00.50 /usr/local/apache/bin/httpd -k start -DSSL
26139 nobody 16 0 219m 59m 72 S 0.0 0.5 0:00.54 /usr/local/apache/bin/httpd -k start -DSSL
25912 nobody 16 0 219m 59m 76 S 0.0 0.5 0:00.49 /usr/local/apache/bin/httpd -k start -DSSL
26255 nobody 16 0 219m 59m 76 S 0.0 0.5 0:02.10 /usr/local/apache/bin/httpd -k start -DSSL
26226 nobody 15 0 218m 58m 76 S 0.0 0.5 0:02.16 /usr/local/apache/bin/httpd -k start -DSSL
26163 nobody 16 0 217m 57m 76 S 0.0 0.5 0:01.36 /usr/local/apache/bin/httpd -k start -DSSL
26162 nobody 16 0 217m 57m 72 S 0.0 0.5 0:00.74 /usr/local/apache/bin/httpd -k start -DSSL
26196 nobody 16 0 217m 57m 76 S 0.0 0.5 0:01.25 /usr/local/apache/bin/httpd -k start -DSSL
26230 nobody 19 0 217m 57m 76 S 0.0 0.5 0:03.22 /usr/local/apache/bin/httpd -k start -DSSL
26109 nobody 16 0 217m 57m 76 S 0.0 0.5 0:01.55 /usr/local/apache/bin/httpd -k start -DSSL
26161 nobody 19 0 217m 57m 76 S 0.0 0.5 0:03.48 /usr/local/apache/bin/httpd -k start -DSSL
25647 nobody 16 0 217m 57m 72 S 0.0 0.5 0:00.42 /usr/local/apache/bin/httpd -k start -DSSL
26096 nobody 16 0 217m 57m 72 S 0.0 0.5 0:00.41 /usr/local/apache/bin/httpd -k start -DSSL
26111 nobody 16 0 217m 57m 68 S 0.0 0.5 0:00.40 /usr/local/apache/bin/httpd -k start -DSSL
1. Dedicated/Shared Dedicated. 5 sites, 3 of which have vbforums. Most popular, http://www.online-literature.com/forums/ has thousands of subforums which creates a unique situation. Site gets 80,000 unique visitors a day. Other sites are less popular.

2. Server Specs
Red Hat Enterprise Linux - 5.x - 64 bit
7/22/2009 100 Mbps Uplink
7/22/2009 5 IPs
7/22/2009 Intel Xeon 5405 2.0 GHz Quad Core Processor
7/22/2009 12 GB RAM
7/22/2009 146 GB 10K RPM SCSI/SAS HDD
7/22/2009 x6 Drive Capacity
7/22/2009 146 GB 10K RPM SCSI/SAS HDD
7/22/2009 2000 GB Bandwidth
7/22/2009 cPanel/WHM with Fantastico
apache 2.2
php newest version (5.2.10 I think? whatever the newest is)
mysql, also newest version in 5.x

3. Version of VB? 3.8.3

4. NA
5. NA

6. Top Stats (not during crash)
Quote:
top - 09:56:25 up 18:35, 2 users, load average: 1.04, 1.24, 1.26
Tasks: 153 total, 1 running, 151 sleeping, 0 stopped, 1 zombie
Cpu0 : 19.4%us, 2.0%sy, 0.0%ni, 77.6%id, 0.0%wa, 0.0%hi, 1.0%si, 0.0%st
Cpu1 : 35.8%us, 2.5%sy, 0.0%ni, 60.2%id, 1.5%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 45.0%us, 1.5%sy, 0.0%ni, 53.5%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 27.0%us, 3.5%sy, 0.0%ni, 69.5%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 12298820k total, 6678576k used, 5620244k free, 143492k buffers
Swap: 2040212k total, 67708k used, 1972504k free, 3047416k cached
7. Mysql

Quote:
# Example MySQL config file for very large systems.
#
# This is for a large system with memory of 1G-2G where the system runs mainly
# MySQL.
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /var/lib/mysql) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
skip-innodb
tmpdir = /home/mysqltemp
key_buffer = 384M
max_allowed_packet = 64M
table_cache = 728
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 128M
thread_cache_size = 512
query_cache_limit = 6M
query_cache_size = 128M
query_cache_type = 1
query_prealloc_size = 163840
query_alloc_block_size = 32768
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 4
max_connections = 450
max_connect_errors = 10
wait_timeout = 60
connect_timeout = 10

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 64M
write_buffer = 64M

[mysqlhotcopy]
interactive-timeout
I edited some comment junk in the middle out of that my.cnf

8. More Mysql stuff
<div style="margin:20px; margin-top:5px; "> Quote:

Variable_name Value
auto_increment_increment 1
auto_increment_offset 1
automatic_sp_privileges ON
back_log 50
basedir /
binlog_cache_size 32768
bulk_insert_buffer_size 8388608
character_set_client latin1
character_set_connection latin1
character_set_database latin1
character_set_filesystem binary
character_set_results latin1
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/

collation_connection latin1_swedish_ci
collation_database latin1_swedish_ci
collation_server latin1_swedish_ci
completion_type 0
concurrent_insert 1
connect_timeout 10
datadir /var/lib/mysql/
date_format %Y-%m-%d
datetime_format %Y-%m-%d %H:%i:%s
default_week_format 0
delay_key_write ON
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
div_precision_increment 4
keep_files_on_create OFF
engine_condition_pushdown OFF
expire_logs_days 0
flush OFF
flush_time 0
ft_boolean_syntax + -> __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
Server optimization request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-20-2009 04:10 PM
Server Optimization Request. First time optimization	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-08-2009 04:40 AM
Server Optimization Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-07-2009 05:50 AM
Server Optimization Request - Please help! Server loads way too high!	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-05-2009 02:00 AM
Server Optimization Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	04-20-2009 03:30 PM