Server Optimization :) Any help that can be given will be appreciated [Archive]

pspcrazy

Thu 28th Jun '07, 3:27am

1. Dedicated Server
2. AMD Opteron 185 [2.6GHz]
2x Generic 1GB DDR1 [1GB] = 2 GB
Western Digital Raptor 10,000 RPM WD1500ADFD [150GB]
CentOs 4
2.6.9-42.ELsmp #1 SMP
Apache: 2.0.52
PHP Version 5.1.6
MySQL: 4.1.21
3. v3.6.0 with tons of hacks
4. Not that i know of, i use mysql 5.
5.No Idea
6. Top Stats
top - 01:20:02 up 16:34, 1 user, load average: 1.07, 1.44, 1.39
Tasks: 132 total, 1 running, 131 sleeping, 0 stopped, 0 zombie
Cpu(s): 15.7% us, 1.5% sy, 0.0% ni, 82.8% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 2074920k total, 1961996k used, 112924k free, 172024k buffers
Swap: 2096472k total, 452k used, 2096020k free, 1170096k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
20955 apache 16 0 38648 22m 5104 S 11 1.1 0:13.91 httpd
19957 apache 15 0 38400 22m 5616 S 11 1.1 0:22.98 httpd
23361 apache 15 0 37968 22m 5556 S 7 1.1 0:06.33 httpd
11222 mysql 15 0 150m 38m 5196 S 4 1.9 49:56.98 mysqld
21629 apache 15 0 38140 22m 5664 S 1 1.1 0:13.68 httpd
19846 apache 15 0 38648 23m 5592 S 0 1.1 0:18.03 httpd
23988 root 16 0 3816 992 764 R 0 0.0 0:00.22 top
1 root 16 0 2864 508 436 S 0 0.0 0:04.99 init
2 root RT 0 0 0 0 S 0 0.0 0:00.04 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:00.06 migration/1
5 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/1
6 root 5 -10 0 0 0 S 0 0.0 0:00.00 events/0
7 root 5 -10 0 0 0 S 0 0.0 0:00.01 events/1
8 root 5 -10 0 0 0 S 0 0.0 0:00.00 khelper
9 root 6 -10 0 0 0 S 0 0.0 0:00.00 kacpid
29 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/0
30 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/1
31 root 15 0 0 0 0 S 0 0.0 0:00.00 khubd
49 root 15 0 0 0 0 S 0 0.0 0:02.62 pdflush
50 root 15 0 0 0 0 S 0 0.0 0:03.60 kswapd0
51 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/0
52 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/1
196 root 25 0 0 0 0 S 0 0.0 0:00.00 kseriod
299 root 5 -10 0 0 0 S 0 0.0 0:00.00 ata/0
300 root 5 -10 0 0 0 S 0 0.0 0:00.00 ata/1
304 root 25 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_0
305 root 25 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_1
306 root 25 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_2
307 root 25 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_3
327 root 15 0 0 0 0 S 0 0.0 0:01.15 kjournald
1346 root 6 -10 2476 480 396 S 0 0.0 0:00.01 udevd
1555 root 6 -10 0 0 0 S 0 0.0 0:00.00 kauditd
1681 root 8 -10 0 0 0 S 0 0.0 0:00.00 kmirrord
1738 root 15 0 0 0 0 S 0 0.0 0:00.00 kjournald
1739 root 15 0 0 0 0 S 0 0.0 0:13.22 kjournald
2322 root 16 0 3556 540 448 S 0 0.0 0:01.35 syslogd
2326 root 16 0 3280 384 320 S 0 0.0 0:00.00 klogd
2339 root 16 0 1652 296 216 S 0 0.0 0:00.09 irqbalance
2350 rpc 18 0 3312 540 444 S 0 0.0 0:00.00 portmap
2369 rpcuser 20 0 2696 736 632 S 0 0.0 0:00.00 rpc.statd
2397 root 16 0 4328 564 304 S 0 0.0 0:00.00 rpc.idmapd
2474 root 16 0 3444 508 300 S 0 0.0 0:00.00 smartd
2532 root 16 0 2964 1512 1228 S 0 0.1 0:00.30 nailsd
2533 root 16 0 9820 2200 1840 S 0 0.1 0:00.01 nailslogd
2534 root 15 0 10904 4412 3312 S 0 0.2 0:05.00 nailslogd
2547 root 16 0 9956 2304 1880 S 0 0.1 0:01.61 mon
2560 root 16 0 4204 2068 1512 S 0 0.1 0:00.04 nailswebd
2563 nails 21 0 4204 1076 524 S 0 0.1 0:00.00 nailswebd
2569 root 21 0 1560 496 424 S 0 0.0 0:00.00 acpid
2579 root 17 0 12268 4328 2300 S 0 0.2 0:00.04 snmpd
2588 root 16 0 8776 1892 1456 S 0 0.1 0:00.00 cupsd
2589 root 16 0 9036 2744 2376 S 0 0.1 0:00.02 logepo
2646 root 15 0 5016 1140 836 S 0 0.1 0:01.45 sshd
2665 root 16 0 2932 808 672 S 0 0.0 0:00.21 xinetd
2677 ntp 16 0 5740 5740 3444 S 0 0.3 0:00.16 ntpd
2797 root 22 0 2736 456 380 S 0 0.0 0:00.00 gpm
2955 named 16 0 49472 3068 1808 S 0 0.1 0:00.06 named
3439 postgres 16 0 19108 2212 1832 S 0 0.1 0:00.00 postmaster
3441 postgres 25 0 9908 844 460 S 0 0.0 0:00.00 postmaster
3442 postgres 25 0 8916 984 560 S 0 0.0 0:00.00 postmaster
3460 root 16 0 30248 24m 2356 S 0 1.2 0:00.76 spamd
3461 popuser 16 0 30248 23m 1036 S 0 1.2 0:00.00 spamd
3462 popuser 16 0 30248 23m 992 S 0 1.2 0:00.00 spamd

7.Mysql Variables
auto_increment_increment 1
auto_increment_offset 1
automatic_sp_privileges ON
back_log 50
basedir /usr/
bdb_cache_size 8388600
bdb_home /var/lib/mysql/
bdb_log_buffer_size 32768
bdb_logdir
bdb_max_lock 10000
bdb_shared_data OFF
bdb_tmpdir /tmp/
binlog_cache_size 32768
bulk_insert_buffer_size 8388608
character_set_client latin1
character_set_connection latin1
character_set_database utf8
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 utf8_general_ci
collation_server latin1_swedish_ci
completion_type 0
concurrent_insert 1
connect_timeout 5
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
engine_condition_pushdown OFF
expire_logs_days 0
flush OFF
flush_time 0
ft_boolean_syntax + -><()~*:""&|
ft_max_word_len 84
ft_min_word_len 4
ft_query_expansion_limit 20
ft_stopword_file (built-in)
group_concat_max_len 1024
have_archive NO
have_bdb YES
have_blackhole_engine NO
have_compress YES
have_crypt YES
have_csv NO
have_dynamic_loading YES
have_example_engine NO
have_federated_engine NO
have_geometry YES
have_innodb YES
have_isam NO
have_ndbcluster NO
have_merge_engine YES
have_openssl DISABLED
have_query_cache YES
have_raid NO
have_rtree_keys YES
have_symlink YES
init_connect
init_file
init_slave
innodb_additional_mem_pool_size 1048576
innodb_autoextend_increment 8
innodb_buffer_pool_awe_mem_mb 0
innodb_buffer_pool_size 8388608
innodb_checksums ON
innodb_commit_concurrency 0
innodb_concurrency_tickets 500
innodb_data_file_path ibdata1:10M:autoextend
innodb_data_home_dir
innodb_doublewrite ON
innodb_fast_shutdown 1
innodb_file_io_threads 4
innodb_file_per_table OFF
innodb_flush_log_at_trx_commit 1
innodb_flush_method
innodb_force_recovery 0
innodb_lock_wait_timeout 50
innodb_locks_unsafe_for_binlog OFF
innodb_log_arch_dir
innodb_log_archive OFF
innodb_log_buffer_size 1048576
innodb_log_file_size 5242880
innodb_log_files_in_group 2
innodb_log_group_home_dir ./
innodb_max_dirty_pages_pct 90
innodb_max_purge_lag 0
innodb_mirrored_log_groups 1
innodb_open_files 300
innodb_support_xa ON
innodb_sync_spin_loops 20
innodb_table_locks ON
innodb_thread_concurrency 8
innodb_thread_sleep_delay 10000
interactive_timeout 28800
join_buffer_size 131072
key_buffer_size 8388600
key_cache_age_threshold 300
key_cache_block_size 1024
key_cache_division_limit 100
language /usr/share/mysql/english/
large_files_support ON
large_page_size 0
large_pages OFF
license GPL
local_infile OFF
locked_in_memory OFF
log OFF
log_bin OFF
log_bin_trust_function_creators OFF
log_error
log_queries_not_using_indexes OFF
log_slave_updates OFF
log_slow_queries OFF
log_warnings 1
long_query_time 10
low_priority_updates OFF
lower_case_file_system OFF
lower_case_table_names 0
max_allowed_packet 1048576
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connect_errors 10
max_connections 400
max_delayed_threads 20
max_error_count 64
max_heap_table_size 16777216
max_insert_delayed_threads 20
max_join_size 4294967295
max_length_for_sort_data 1024
max_prepared_stmt_count 16382
max_relay_log_size 0
max_seeks_for_key 4294967295
max_sort_length 1024
max_sp_recursion_depth 0
max_tmp_tables 32
max_user_connections 30
max_write_lock_count 4294967295
multi_range_count 256
myisam_data_pointer_size 6
myisam_max_sort_file_size 2147483647
myisam_recover_options OFF
myisam_repair_threads 1
myisam_sort_buffer_size 8388608
myisam_stats_method nulls_unequal
net_buffer_length 16384
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
new OFF
old_passwords ON
open_files_limit 2010
optimizer_prune_level 1
optimizer_search_depth 62
pid_file /var/run/mysqld/mysqld.pid
port 3306
preload_buffer_size 32768
prepared_stmt_count 0
protocol_version 10
query_alloc_block_size 8192
query_cache_limit 1048576
query_cache_min_res_unit 4096
query_cache_size 0
query_cache_type ON
query_cache_wlock_invalidate OFF
query_prealloc_size 8192
range_alloc_block_size 2048
read_buffer_size 131072
read_only OFF
read_rnd_buffer_size 262144
relay_log_purge ON
relay_log_space_limit 0
rpl_recovery_rank 0
secure_auth OFF
server_id 0
skip_external_locking ON
skip_networking OFF
skip_show_database OFF
slave_compressed_protocol OFF
slave_load_tmpdir /tmp/
slave_net_timeout 3600
slave_skip_errors OFF
slave_transaction_retries 10
slow_launch_time 2
socket /var/lib/mysql/mysql.sock
sort_buffer_size 2097144
sql_big_selects ON
sql_mode
sql_notes ON
sql_warnings OFF
ssl_ca
ssl_capath
ssl_cert
ssl_cipher
ssl_key
storage_engine MyISAM
sync_binlog 0
sync_frm ON
system_time_zone CDT
table_cache 64
table_lock_wait_timeout 50
table_type MyISAM
thread_cache_size 0
thread_stack 196608
time_format %H:%i:%s
time_zone SYSTEM
timed_mutexes OFF
tmp_table_size 33554432
tmpdir /tmp/
transaction_alloc_block_size 8192
transaction_prealloc_size 4096
tx_isolation REPEATABLE-READ
updatable_views_with_limit YES
version 5.0.24a
version_bdb Sleepycat Software: Berkeley DB 4.1.24: (August 25, 2006)
version_comment Source distribution
version_compile_machine i686
version_compile_os redhat-linux-gnu
wait_timeout 28800

8. mysql statusAborted_clients 918
Aborted_connects 1135
Binlog_cache_disk_use 0
Binlog_cache_use 0
Bytes_received 2339
Bytes_sent 439485
Com_admin_commands 0
Com_alter_db 0
Com_alter_table 0
Com_analyze 0
Com_backup_table 0
Com_begin 0
Com_change_db 1
Com_change_master 0
Com_check 0
Com_checksum 0
Com_commit 0
Com_create_db 0
Com_create_function 0
Com_create_index 0
Com_create_table 0
Com_dealloc_sql 0
Com_delete 0
Com_delete_multi 0
Com_do 0
Com_drop_db 0
Com_drop_function 0
Com_drop_index 0
Com_drop_table 0
Com_drop_user 0
Com_execute_sql 0
Com_flush 0
Com_grant 0
Com_ha_close 0
Com_ha_open 0
Com_ha_read 0
Com_help 0
Com_insert 0
Com_insert_select 0
Com_kill 0
Com_load 0
Com_load_master_data 0
Com_load_master_table 0
Com_lock_tables 0
Com_optimize 0
Com_preload_keys 0
Com_prepare_sql 0
Com_purge 0
Com_purge_before_date 0
Com_rename_table 0
Com_repair 0
Com_replace 0
Com_replace_select 0
Com_reset 0
Com_restore_table 0
Com_revoke 0
Com_revoke_all 0
Com_rollback 0
Com_savepoint 0
Com_select 5
Com_set_option 0
Com_show_binlog_events 0
Com_show_binlogs 0
Com_show_charsets 0
Com_show_collations 0
Com_show_column_types 0
Com_show_create_db 0
Com_show_create_table 0
Com_show_databases 0
Com_show_errors 0
Com_show_fields 0
Com_show_grants 0
Com_show_innodb_status 0
Com_show_keys 0
Com_show_logs 0
Com_show_master_status 0
Com_show_ndb_status 0
Com_show_new_master 0
Com_show_open_tables 0
Com_show_privileges 0
Com_show_processlist 0
Com_show_slave_hosts 0
Com_show_slave_status 0
Com_show_status 1
Com_show_storage_engines 0
Com_show_tables 0
Com_show_triggers 0
Com_show_variables 0
Com_show_warnings 0
Com_slave_start 0
Com_slave_stop 0
Com_stmt_close 0
Com_stmt_execute 0
Com_stmt_fetch 0
Com_stmt_prepare 0
Com_stmt_reset 0
Com_stmt_send_long_data 0
Com_truncate 0
Com_unlock_tables 0
Com_update 1
Com_update_multi 0
Com_xa_commit 0
Com_xa_end 0
Com_xa_prepare 0
Com_xa_recover 0
Com_xa_rollback 0
Com_xa_start 0
Compression OFF
Connections 149963
Created_tmp_disk_tables 0
Created_tmp_files 16
Created_tmp_tables 1
Delayed_errors 0
Delayed_insert_threads 0
Delayed_writes 0
Flush_commands 1
Handler_commit 0
Handler_delete 0
Handler_discover 0
Handler_prepare 0
Handler_read_first 3
Handler_read_key 20
Handler_read_next 1386
Handler_read_prev 0
Handler_read_rnd 0
Handler_read_rnd_next 2
Handler_rollback 0
Handler_savepoint 0
Handler_savepoint_rollback 0
Handler_update 1
Handler_write 130
Innodb_buffer_pool_pages_data 229
Innodb_buffer_pool_pages_dirty 0
Innodb_buffer_pool_pages_flushed 7259
Innodb_buffer_pool_pages_free 273
Innodb_buffer_pool_pages_latched 0
Innodb_buffer_pool_pages_misc 10
Innodb_buffer_pool_pages_total 512
Innodb_buffer_pool_read_ahead_rnd 2
Innodb_buffer_pool_read_ahead_seq 0
Innodb_buffer_pool_read_requests 1804121
Innodb_buffer_pool_reads 174
Innodb_buffer_pool_wait_free 0
Innodb_buffer_pool_write_requests 19768
Innodb_data_fsyncs 5920
Innodb_data_pending_fsyncs 0
Innodb_data_pending_reads 0
Innodb_data_pending_writes 0
Innodb_data_read 5328896
Innodb_data_reads 194
Innodb_data_writes 11167
Innodb_data_written 240197120
Innodb_dblwr_pages_written 7259
Innodb_dblwr_writes 1426
Innodb_log_waits 0
Innodb_log_write_requests 2421
Innodb_log_writes 2129
Innodb_os_log_fsyncs 3060
Innodb_os_log_pending_fsyncs 0
Innodb_os_log_pending_writes 0
Innodb_os_log_written 1858560
Innodb_page_size 16384
Innodb_pages_created 37
Innodb_pages_read 192
Innodb_pages_written 7259
Innodb_row_lock_current_waits 0
Innodb_row_lock_time 0
Innodb_row_lock_time_avg 0
Innodb_row_lock_time_max 0
Innodb_row_lock_waits 0
Innodb_rows_deleted 981
Innodb_rows_inserted 916
Innodb_rows_read 53578
Innodb_rows_updated 672
Key_blocks_not_flushed 0
Key_blocks_unused 5675
Key_blocks_used 7248
Key_read_requests 53273658
Key_reads 402546
Key_write_requests 501067
Key_writes 88482
Last_query_cost 296.361305
Max_used_connections 53
Not_flushed_delayed_rows 0
Open_files 119
Open_streams 0
Open_tables 64
Opened_tables 3
Qcache_free_blocks 0
Qcache_free_memory 0
Qcache_hits 0
Qcache_inserts 0
Qcache_lowmem_prunes 0
Qcache_not_cached 0
Qcache_queries_in_cache 0
Qcache_total_blocks 0
Questions 1737032
Rpl_status NULL
Select_full_join 0
Select_full_range_join 0
Select_range 1
Select_range_check 0
Select_scan 2
Slave_open_temp_tables 0
Slave_retried_transactions 0
Slave_running OFF
Slow_launch_threads 0
Slow_queries 0
Sort_merge_passes 0
Sort_range 0
Sort_rows 0
Sort_scan 0
Ssl_accept_renegotiates 0
Ssl_accepts 0
Ssl_callback_cache_hits 0
Ssl_cipher
Ssl_cipher_list
Ssl_client_connects 0
Ssl_connect_renegotiates 0
Ssl_ctx_verify_depth 0
Ssl_ctx_verify_mode 0
Ssl_default_timeout 0
Ssl_finished_accepts 0
Ssl_finished_connects 0
Ssl_session_cache_hits 0
Ssl_session_cache_misses 0
Ssl_session_cache_mode NONE
Ssl_session_cache_overflows 0
Ssl_session_cache_size 0
Ssl_session_cache_timeouts 0
Ssl_sessions_reused 0
Ssl_used_session_cache_entries 0
Ssl_verify_depth 0
Ssl_verify_mode 0
Ssl_version
Table_locks_immediate 1654083
Table_locks_waited 1458
Tc_log_max_pages_used 0
Tc_log_page_size 0
Tc_log_page_waits 0
Threads_cached 0
Threads_connected 22
Threads_created 149962
Threads_running 1
Uptime 19284

9. I have 3 other sites on the server that use mysql and php. One is wordpress and the other is a cms.
10. cookie timeout: 900, Concurrent users on server: 230, max=400
11. PHP Info: http://pspcrazy.com/phpinfo.php
12. Httpd Stuff:
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 20
StartServers 8
MaxClients 256

AND Maxrequestsperchild value = 4000
13. None were found :)
14. Outputted Commands:
uname -a: Linux www1.pspcrazy.com 2.6.9-42.ELsmp #1 SMP Sat Aug 12 09:39:11 CDT 2006 i686 athlon i386 GNU/Linux

ulimit -aH:
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 32767
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited

cat /proc/cpuinfo:
processor : 0
vendor_id : AuthenticAMD
cpu family : 15
model : 35
model name : Dual Core AMD Opteron(tm) Processor 185
stepping : 2
cpu MHz : 2595.204
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow pni
bogomips : 5189.82

processor : 1
vendor_id : AuthenticAMD
cpu family : 15
model : 35
model name : Dual Core AMD Opteron(tm) Processor 185
stepping : 2
cpu MHz : 2595.204
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow pni
bogomips : 5186.21

eva2000

Thu 28th Jun '07, 12:02pm

Try the following in this exact order. You can ignore any of the suggestions that you have already done.

1. Upgrade MySQL server to 5.0.27 or 5.0.41
2. Upgrade Apache to 2.0.59 and PHP to 5.2.3 or if you have problems install PHP 4.4.7 (in either case install as ISAPI module and NO CGI)
3. Edit /etc/my.cnf and place the following mysql server settings in /etc/my.cnf and restart mysql server afterwards

[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 650
key_buffer = 64M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 2500
thread_cache_size = 384
wait_timeout = 35
connect_timeout = 10
tmp_table_size = 128M
max_heap_table_size = 128M
max_allowed_packet = 64M
max_connect_errors = 10
thread_concurrency = 4
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 64M
query_cache_type = 1
query_prealloc_size = 131072
query_alloc_block_size = 65536
default-storage-engine = MyISAM

[mysqld_safe]
nice = -5
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

[mysqlhotcopy]
interactive-timeout

4. Install APC Cache lastest version from http://pecl.php.net/package/APC. Read install guide at http://www.vbulletin.com/forum/showthread.php?t=165367 - please remove Zend Optimizer from php.ini before installing APC Cache. OR try the alternative PHP caching software, Xcache which seems to be a bit faster than APC Cache - http://www.vbulletin.com/forum/showthread.php?t=213267

5. Upgrade to vB 3.6.7 http://www.vbulletin.com/forum/showthread.php?t=229950 if you're on vB 3.6.x

6. If you just upgraded to vB 3.5.x/3.6.x try to disable these 4 options:

Admin CP -> vBulletin Options -> Forums Home Page Options -> Display Logged in Users?

Admin CP -> vBulletin Options -> Forum Display Options (forumdisplay) -> Show Users Browsing Forums

Admin CP -> vBulletin Options -> Thread Display Options -> Show Users Browsing Thread

Admin CP -> vBulletin Options -> Message Searching Options -> Automatic Similar Thread search

7. Edit httpd.conf values to following and restart apache

KeepAlive: On
MaxKeepAliveRequests: 100
KeepAliveTimeout: 1
MinSpareServers: 10
MaxSpareServers: 15
StartServers: 15
MaxClients: 180
MaxRequestsPerChild: 1000

8. Ensure vB admincp gzip is disabled since you already have Apache with mod_deflate which does the same thing

pspcrazy

Thu 12th Jul '07, 3:24pm

Thanks, but now ever since i added a new site on my server, the server has been crashing during peak time :| .
Only changes to the server are:

Now there is 2 vbulletin's on the server, and 1 more wordpress that has over 300 consecutive members on at once time.

Any updates to the code i should do? The server crashes daily now at peak time.

eva2000

Sun 15th Jul '07, 8:31am

at peak or close to peak prior to crashing AND after crashing, post output for these 2 commands

top

mysqladmin -u root -p var ext ver > stats.txt

open the stats.txt file to copy and paste it's contents.

pspcrazy

Fri 3rd Aug '07, 8:03am

ignore the crash thing as i fixed that. Here is my current issue:

I have the same server as above except now with xcache. I now also have a new large site running on it as well. This extra site is wordpress with vbulletin. During peak times the new site causes the server to crash, so when optimizing it please keep in mind that this is two major sites now. New spec check below:

1. Dedicated Server
2. AMD Opteron 185 [2.6GHz]
3x Generic 1GB DDR1 [1GB] = 3 GB
Western Digital Raptor 10,000 RPM WD1500ADFD [150GB]
CentOs 4
2.6.9-42.ELsmp #1 SMP
Apache: 2.0.52
PHP Version 5.1.6
MySQL: 4.1.21
3. v3.6.0 with tons of hacks, and a 3.6.7.
4. Not that i know of, i use mysql 5.
5.No Idea
6. Top Stats
top - 06:09:05 up 8:01, 3 users, load average: 0.92, 1.21, 1.41
Tasks: 135 total, 1 running, 134 sleeping, 0 stopped, 0 zombie
Cpu(s): 30.8% us, 3.2% sy, 0.0% ni, 65.8% id, 0.0% wa, 0.2% hi, 0.0% si
Mem: 3115244k total, 2233244k used, 882000k free, 76296k buffers
Swap: 2096472k total, 8560k used, 2087912k free, 1432296k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
23730 apache 16 0 99748 25m 12m S 10 0.8 0:02.14 httpd
23637 apache 16 0 98.5m 27m 13m S 10 0.9 0:03.03 httpd
23670 apache 15 0 96844 19m 9.9m S 10 0.7 0:01.32 httpd
23726 apache 16 0 98.8m 27m 12m S 10 0.9 0:01.13 httpd
23750 apache 15 0 97240 19m 9868 S 10 0.7 0:00.34 httpd
23614 apache 15 0 98.7m 29m 15m S 7 1.0 0:05.65 httpd
23735 apache 15 0 98.3m 25m 12m S 7 0.8 0:00.81 httpd
10176 mysql 15 0 406m 286m 4952 S 3 9.4 84:21.27 mysqld
23722 apache 15 0 99140 24m 12m S 1 0.8 0:02.07 httpd
23665 apache 15 0 99.0m 28m 13m S 0 0.9 0:02.53 httpd
23724 apache 15 0 97196 20m 9.9m S 0 0.7 0:00.74 httpd
1 root 16 0 3276 548 468 S 0 0.0 0:05.01 init
2 root RT 0 0 0 0 S 0 0.0 0:00.04 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:00.04 migration/1
5 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/1
6 root 5 -10 0 0 0 S 0 0.0 0:00.00 events/0
7 root 5 -10 0 0 0 S 0 0.0 0:00.00 events/1
8 root 10 -10 0 0 0 S 0 0.0 0:00.00 khelper
9 root 6 -10 0 0 0 S 0 0.0 0:00.00 kacpid
30 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/0
31 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/1
32 root 15 0 0 0 0 S 0 0.0 0:00.00 khubd
50 root 15 0 0 0 0 S 0 0.0 0:00.76 pdflush
51 root 15 0 0 0 0 S 0 0.0 0:01.11 kswapd0
52 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/0
53 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/1
197 root 25 0 0 0 0 S 0 0.0 0:00.00 kseriod
300 root 5 -10 0 0 0 S 0 0.0 0:00.00 ata/0
301 root 5 -10 0 0 0 S 0 0.0 0:00.00 ata/1
305 root 24 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_0
306 root 25 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_1
307 root 25 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_2
308 root 25 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_3
328 root 15 0 0 0 0 S 0 0.0 0:00.79 kjournald
1353 root 6 -10 2268 440 360 S 0 0.0 0:00.01 udevd
1560 root 6 -10 0 0 0 S 0 0.0 0:00.00 kauditd
1685 root 8 -10 0 0 0 S 0 0.0 0:00.00 kmirrord
1743 root 22 0 0 0 0 S 0 0.0 0:00.00 kjournald
1744 root 15 0 0 0 0 S 0 0.0 0:07.23 kjournald
2342 root 16 0 2892 540 448 S 0 0.0 0:00.81 syslogd
2346 root 15 0 3256 384 320 S 0 0.0 0:00.00 klogd
2359 root 16 0 1836 292 216 S 0 0.0 0:00.24 irqbalance
2374 named 18 0 48104 2552 1708 S 0 0.1 0:00.02 named
2424 rpc 17 0 1736 544 444 S 0 0.0 0:00.00 portmap
2443 rpcuser 20 0 3396 728 632 S 0 0.0 0:00.00 rpc.statd
2471 root 16 0 4268 304 200 S 0 0.0 0:00.02 rpc.idmapd
2549 root 16 0 2924 500 300 S 0 0.0 0:00.00 smartd
2610 root 22 0 1680 448 372 S 0 0.0 0:00.00 acpid
2620 root 18 0 11472 4152 2300 S 0 0.1 0:00.04 snmpd
2629 root 16 0 8732 1852 1456 S 0 0.1 0:00.00 cupsd
2659 root 16 0 4472 1044 836 S 0 0.0 0:00.24 sshd
2672 root 16 0 2820 796 672 S 0 0.0 0:00.06 xinetd
2684 ntp 16 0 5592 5592 3444 S 0 0.2 0:00.51 ntpd
2787 postgres 16 0 19236 2040 1752 S 0 0.1 0:00.00 postmaster
2789 postgres 18 0 10036 472 180 S 0 0.0 0:00.00 postmaster
2790 postgres 18 0 9044 540 208 S 0 0.0 0:00.00 postmaster
2800 root 15 0 9260 2664 2024 S 0 0.1 0:00.21 sshd
2821 root 24 0 5200 712 608 S 0 0.0 0:00.00 couriertcpd
2823 root 25 0 4128 420 320 S 0 0.0 0:00.00 courierlogger
2833 root 25 0 4500 712 608 S 0 0.0 0:00.00 couriertcpd
2835 root 25 0 3712 420 320 S 0 0.0 0:00.00 courierlogger
2843 root 16 0 5388 720 616 S 0 0.0 0:00.00 couriertcpd
2845 root 16 0 3976 620 508 S 0 0.0 0:00.00 courierlogger

7. Varables:
auto_increment_increment 1 auto_increment_offset 1 automatic_sp_privileges ON back_log 50 basedir /usr/ bdb_cache_size 8388600 bdb_home /var/lib/mysql/ bdb_log_buffer_size 1024000 bdb_logdir bdb_max_lock 10000 bdb_shared_data OFF bdb_tmpdir /tmp/ binlog_cache_size 32768 bulk_insert_buffer_size 8388608 character_set_client latin1 character_set_connection latin1 character_set_database utf8 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 utf8_general_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 engine_condition_pushdown OFF expire_logs_days 0 flush OFF flush_time 0 ft_boolean_syntax + -><()~*:""&| ft_max_word_len 84 ft_min_word_len 4 ft_query_expansion_limit 20 ft_stopword_file (built-in) group_concat_max_len 1024 have_archive NO have_bdb YES have_blackhole_engine NO have_compress YES have_crypt YES have_csv NO have_dynamic_loading YES have_example_engine NO have_federated_engine NO have_geometry YES have_innodb YES have_isam NO have_ndbcluster NO have_merge_engine YES have_openssl DISABLED have_query_cache YES have_raid NO have_rtree_keys YES have_symlink YES init_connect init_file init_slave innodb_additional_mem_pool_size 1048576 innodb_autoextend_increment 8 innodb_buffer_pool_awe_mem_mb 0 innodb_buffer_pool_size 8388608 innodb_checksums ON innodb_commit_concurrency 0 innodb_concurrency_tickets 500 innodb_data_file_path ibdata1:10M:autoextend innodb_data_home_dir innodb_doublewrite ON innodb_fast_shutdown 1 innodb_file_io_threads 4 innodb_file_per_table OFF innodb_flush_log_at_trx_commit 1 innodb_flush_method innodb_force_recovery 0 innodb_lock_wait_timeout 50 innodb_locks_unsafe_for_binlog OFF innodb_log_arch_dir innodb_log_archive OFF innodb_log_buffer_size 1048576 innodb_log_file_size 5242880 innodb_log_files_in_group 2 innodb_log_group_home_dir ./ innodb_max_dirty_pages_pct 90 innodb_max_purge_lag 0 innodb_mirrored_log_groups 1 innodb_open_files 300 innodb_support_xa ON innodb_sync_spin_loops 20 innodb_table_locks ON innodb_thread_concurrency 8 innodb_thread_sleep_delay 10000 interactive_timeout 28800 join_buffer_size 2093056 key_buffer_size 209715200 key_cache_age_threshold 300 key_cache_block_size 1024 key_cache_division_limit 100 language /usr/share/mysql/english/ large_files_support ON large_page_size 0 large_pages OFF license GPL local_infile ON locked_in_memory OFF log OFF log_bin OFF log_bin_trust_function_creators OFF log_error log_queries_not_using_indexes OFF log_slave_updates OFF log_slow_queries OFF log_warnings 1 long_query_time 10 low_priority_updates OFF lower_case_file_system OFF lower_case_table_names 0 max_allowed_packet 16776192 max_binlog_cache_size 4294967295 max_binlog_size 1073741824 max_connect_errors 1500 max_connections 500 max_delayed_threads 20 max_error_count 64 max_heap_table_size 16777216 max_insert_delayed_threads 20 max_join_size 4294967295 max_length_for_sort_data 1024 max_prepared_stmt_count 16382 max_relay_log_size 0 max_seeks_for_key 4294967295 max_sort_length 1024 max_sp_recursion_depth 0 max_tmp_tables 32 max_user_connections 0 max_write_lock_count 4294967295 multi_range_count 256 myisam_data_pointer_size 6 myisam_max_sort_file_size 2147483647 myisam_recover_options OFF myisam_repair_threads 1 myisam_sort_buffer_size 125829120 myisam_stats_method nulls_unequal net_buffer_length 16384 net_read_timeout 30 net_retry_count 10 net_write_timeout 60 new OFF old_passwords OFF open_files_limit 4510 optimizer_prune_level 1 optimizer_search_depth 62 pid_file /var/run/mysqld/mysqld.pid port 3306 preload_buffer_size 32768 prepared_stmt_count 0 protocol_version 10 query_alloc_block_size 8192 query_cache_limit 1048576 query_cache_min_res_unit 4096 query_cache_size 33554432 query_cache_type ON query_cache_wlock_invalidate OFF query_prealloc_size 8192 range_alloc_block_size 2048 read_buffer_size 2093056 read_only OFF read_rnd_buffer_size 262144 relay_log_purge ON relay_log_space_limit 0 rpl_recovery_rank 0 secure_auth OFF server_id 0 skip_external_locking ON skip_networking OFF skip_show_database OFF slave_compressed_protocol OFF slave_load_tmpdir /tmp/ slave_net_timeout 3600 slave_skip_errors OFF slave_transaction_retries 10 slow_launch_time 2 socket /var/lib/mysql/mysql.sock sort_buffer_size 3145720 sql_big_selects ON sql_mode sql_notes ON sql_warnings OFF ssl_ca ssl_capath ssl_cert ssl_cipher ssl_key storage_engine MyISAM sync_binlog 0 sync_frm ON system_time_zone CDT table_cache 2000 table_lock_wait_timeout 50 table_type MyISAM thread_cache_size 150 thread_stack 196608 time_format %H:%i:%s time_zone SYSTEM timed_mutexes OFF tmp_table_size 33554432 tmpdir /tmp/ transaction_alloc_block_size 8192 transaction_prealloc_size 4096 tx_isolation REPEATABLE-READ updatable_views_with_limit YES version 5.0.24a version_bdb Sleepycat Software: Berkeley DB 4.1.24: (August 25, 2006) version_comment Source distribution version_compile_machine i686 version_compile_os redhat-linux-gnu wait_timeout 15
8. Status:
Aborted_clients 7784 Aborted_connects 6 Binlog_cache_disk_use 0 Binlog_cache_use 0 Bytes_received 2339 Bytes_sent 437801 Com_admin_commands 0 Com_alter_db 0 Com_alter_table 0 Com_analyze 0 Com_backup_table 0 Com_begin 0 Com_change_db 1 Com_change_master 0 Com_check 0 Com_checksum 0 Com_commit 0 Com_create_db 0 Com_create_function 0 Com_create_index 0 Com_create_table 0 Com_dealloc_sql 0 Com_delete 0 Com_delete_multi 0 Com_do 0 Com_drop_db 0 Com_drop_function 0 Com_drop_index 0 Com_drop_table 0 Com_drop_user 0 Com_execute_sql 0 Com_flush 0 Com_grant 0 Com_ha_close 0 Com_ha_open 0 Com_ha_read 0 Com_help 0 Com_insert 0 Com_insert_select 0 Com_kill 0 Com_load 0 Com_load_master_data 0 Com_load_master_table 0 Com_lock_tables 0 Com_optimize 0 Com_preload_keys 0 Com_prepare_sql 0 Com_purge 0 Com_purge_before_date 0 Com_rename_table 0 Com_repair 0 Com_replace 0 Com_replace_select 0 Com_reset 0 Com_restore_table 0 Com_revoke 0 Com_revoke_all 0 Com_rollback 0 Com_savepoint 0 Com_select 4 Com_set_option 0 Com_show_binlog_events 0 Com_show_binlogs 0 Com_show_charsets 0 Com_show_collations 0 Com_show_column_types 0 Com_show_create_db 0 Com_show_create_table 0 Com_show_databases 0 Com_show_errors 0 Com_show_fields 0 Com_show_grants 0 Com_show_innodb_status 0 Com_show_keys 0 Com_show_logs 0 Com_show_master_status 0 Com_show_ndb_status 0 Com_show_new_master 0 Com_show_open_tables 0 Com_show_privileges 0 Com_show_processlist 0 Com_show_slave_hosts 0 Com_show_slave_status 0 Com_show_status 1 Com_show_storage_engines 0 Com_show_tables 0 Com_show_triggers 0 Com_show_variables 0 Com_show_warnings 0 Com_slave_start 0 Com_slave_stop 0 Com_stmt_close 0 Com_stmt_execute 0 Com_stmt_fetch 0 Com_stmt_prepare 0 Com_stmt_reset 0 Com_stmt_send_long_data 0 Com_truncate 0 Com_unlock_tables 0 Com_update 1 Com_update_multi 0 Com_xa_commit 0 Com_xa_end 0 Com_xa_prepare 0 Com_xa_recover 0 Com_xa_rollback 0 Com_xa_start 0 Compression OFF Connections 251721 Created_tmp_disk_tables 0 Created_tmp_files 13 Created_tmp_tables 1 Delayed_errors 0 Delayed_insert_threads 0 Delayed_writes 0 Flush_commands 1 Handler_commit 0 Handler_delete 0 Handler_discover 0 Handler_prepare 0 Handler_read_first 2 Handler_read_key 20 Handler_read_next 1 Handler_read_prev 0 Handler_read_rnd 0 Handler_read_rnd_next 2 Handler_rollback 0 Handler_savepoint 0 Handler_savepoint_rollback 0 Handler_update 1 Handler_write 130 Innodb_buffer_pool_pages_data 510 Innodb_buffer_pool_pages_dirty 0 Innodb_buffer_pool_pages_flushed 4269 Innodb_buffer_pool_pages_free 0 Innodb_buffer_pool_pages_latched 0 Innodb_buffer_pool_pages_misc 2 Innodb_buffer_pool_pages_total 512 Innodb_buffer_pool_read_ahead_rnd 18 Innodb_buffer_pool_read_ahead_seq 5 Innodb_buffer_pool_read_requests 970370 Innodb_buffer_pool_reads 602 Innodb_buffer_pool_wait_free 0 Innodb_buffer_pool_write_requests 140946 Innodb_data_fsyncs 11005 Innodb_data_pending_fsyncs 0 Innodb_data_pending_reads 0 Innodb_data_pending_writes 0 Innodb_data_read 14389248 Innodb_data_reads 701 Innodb_data_writes 13828 Innodb_data_written 150058496 Innodb_dblwr_pages_written 4269 Innodb_dblwr_writes 912 Innodb_log_waits 0 Innodb_log_write_requests 11835 Innodb_log_writes 8554 Innodb_os_log_fsyncs 9178 Innodb_os_log_pending_fsyncs 0 Innodb_os_log_pending_writes 0 Innodb_os_log_written 9850880 Innodb_page_size 16384 Innodb_pages_created 176 Innodb_pages_read 745 Innodb_pages_written 4269 Innodb_row_lock_current_waits 0 Innodb_row_lock_time 0 Innodb_row_lock_time_avg 0 Innodb_row_lock_time_max 0 Innodb_row_lock_waits 0 Innodb_rows_deleted 456 Innodb_rows_inserted 29223 Innodb_rows_read 151737 Innodb_rows_updated 8045 Key_blocks_not_flushed 0 Key_blocks_unused 170699 Key_blocks_used 181759 Key_read_requests 36872298 Key_reads 532508 Key_write_requests 292293 Key_writes 27560 Last_query_cost 0.000000 Max_used_connections 71 Not_flushed_delayed_rows 0 Open_files 1931 Open_streams 0 Open_tables 1334 Opened_tables 0 Qcache_free_blocks 1606 Qcache_free_memory 11821072 Qcache_hits 2840144 Qcache_inserts 466382 Qcache_lowmem_prunes 46472 Qcache_not_cached 123999 Qcache_queries_in_cache 4861 Qcache_total_blocks 12058 Questions 4208707 Rpl_status NULL Select_full_join 0 Select_full_range_join 0 Select_range 1 Select_range_check 0 Select_scan 1 Slave_open_temp_tables 0 Slave_retried_transactions 0 Slave_running OFF Slow_launch_threads 0 Slow_queries 0 Sort_merge_passes 0 Sort_range 0 Sort_rows 0 Sort_scan 0 Ssl_accept_renegotiates 0 Ssl_accepts 0 Ssl_callback_cache_hits 0 Ssl_cipher Ssl_cipher_list Ssl_client_connects 0 Ssl_connect_renegotiates 0 Ssl_ctx_verify_depth 0 Ssl_ctx_verify_mode 0 Ssl_default_timeout 0 Ssl_finished_accepts 0 Ssl_finished_connects 0 Ssl_session_cache_hits 0 Ssl_session_cache_misses 0 Ssl_session_cache_mode NONE Ssl_session_cache_overflows 0 Ssl_session_cache_size 0 Ssl_session_cache_timeouts 0 Ssl_sessions_reused 0 Ssl_used_session_cache_entries 0 Ssl_verify_depth 0 Ssl_verify_mode 0 Ssl_version Table_locks_immediate 854939 Table_locks_waited 1395 Tc_log_max_pages_used 0 Tc_log_page_size 0 Tc_log_page_waits 0 Threads_cached 64 Threads_connected 7 Threads_created 71 Threads_running 1 Uptime 21520
9. I have 3 other sites on the server that use mysql and php. One is wordpress and the other is a cms.

Summary of sites of server:
2x vbulliten (3.6.0 and 3.6.7)
1x wordpress
1x custom cms

10. cookie timeout: 900, Concurrent users on server: 230, max= 800
11. PHP Info: http://pspcrazy.com/phpinfo.php
12. Httpd Stuff:
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 1
MinSpareServers 10
MaxSpareServers 15
StartServers 15
MaxClients 600

AND Maxrequestsperchild value = 1000

Oh and oddly my httpd.conf has this in it:

##
## Server-Pool Size Regulation (MPM specific)
##

# prefork MPM
# StartServers: number of server processes to start
# MinSpareServers: minimum number of server processes which are kept spare
# MaxSpareServers: maximum number of server processes which are kept spare
# ServerLimit: maximum value for MaxClients for the lifetime of the server
# MaxClients: maximum number of server processes allowed to start
# MaxRequestsPerChild: maximum number of requests a server process serves
<IfModule prefork.c>
StartServers 15
MinSpareServers 10
MaxSpareServers 15
ServerLimit 600
MaxClients 600
MaxRequestsPerChild 1000
</IfModule>

# worker MPM
# StartServers: initial number of server processes to start
# MaxClients: maximum number of simultaneous client connections
# MinSpareThreads: minimum number of worker threads which are kept spare
# MaxSpareThreads: maximum number of worker threads which are kept spare
# ThreadsPerChild: constant number of worker threads in each server process
# MaxRequestsPerChild: maximum number of requests a server process serves
<IfModule worker.c>
StartServers 2
MaxClients 200
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 1000
</IfModule>

I wonder why that is there?
13. None were found :)
14. Outputted Commands:
uname -a:
Linux www1.pspcrazy.com 2.6.9-42.ELsmp #1 SMP Sat Aug 12 09:39:11 CDT 2006 i686 athlon i386 GNU/Linux

ulimit -aH:

core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 49151
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited

cat /proc/cpuinfo:

processor : 0
vendor_id : AuthenticAMD
cpu family : 15
model : 35
model name : Dual Core AMD Opteron(tm) Processor 185
stepping : 2
cpu MHz : 2594.657
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow pni
bogomips : 5189.95

processor : 1
vendor_id : AuthenticAMD
cpu family : 15
model : 35
model name : Dual Core AMD Opteron(tm) Processor 185
stepping : 2
cpu MHz : 2594.657
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow pni
bogomips : 5186.32

jason|xoxide

Fri 3rd Aug '07, 12:14pm

Your phpinfo link is broken...

Wordpress is not known for handling heavy load very well. Make sure you're running 2.2.1 as it is much better than older versions. Also make sure you install the wp-cache plugin as that will help.

You might try lowering your "MaxClients" and "ServerLimit" values in your httpd.conf; 600 is WAY too high for a server like that (with httpd using the prefork mpm they'll use about 12GB of memory just serving static html if they all fire at once). You should also test your site with KeepAlive turned off. I've found that heavy load sites tend to fare better that way.

You could also run lighttpd on another IP or another port to serve the static content (js, css, images, etc.) as it consumes far fewer resources than httpd.

eva2000

Sat 4th Aug '07, 7:33am

service optimisation here is really for vB related issues only.. if you disable wordpress on your server do you have the same issues ?

pspcrazy

Sun 5th Aug '07, 12:05pm

Yes i do oddly enough since all the videos are actually in vbulletin as well. I use a vbulletin mod that adds the videos in the posts, so it adds a bit of server load tossing it to ranges like 90-100-140 it's crazy really.

Oh and what exactly is preform mpm and that? Is it really needed?

eva2000

Mon 6th Aug '07, 3:28am

ouch vB was never intended for such large file storage as videos.. that will drive up the loads.. best would be to use a dedicated script other than vB for just the videos and host the videos on maybe a separate server using a subdomain off your main domain i.e. videos.domain.com

prefork mpm is one of the ways apache 2 can be compiled/installed http://httpd.apache.org/docs/2.0/mod/prefork.html

try disabling that vB mod and see if loads go down could be a poorly coded mod too ?