Optimisation Request

[Cynthia]

1. Is this on dedicated or shared virual server. If shared, how many sites share this server (ask web host if needed)

Dedicated

2. Server Specs
Two servers - 1-web 1-database

Dual Opteron 252
8x36 GB SCSI Hard Drive
8 GB RAM
CentOS
RAID10 Card

Dual Core Dual Opteron 270
8x36 GB SCSI Hard Drive
8 GB RAM
CentOS
RAID10 Card

linux 2.6.23
Apache v2.2.3
PHP version: php 5.1.6
MySQL version: mysql 5.0.22

3. what version of vB are you running ?
3.6.8

4. n/a

5. n/a

6. your top stats:
webserver:
top - 05:05:20 up 1 day, 16:07, 2 users, load average: 0.43, 0.75, 0.67
Tasks: 291 total, 1 running, 290 sleeping, 0 stopped, 0 zombie
Cpu(s): 6.0%us, 0.3%sy, 0.0%ni, 93.6%id, 0.0%wa, 0.1%hi, 0.1%si, 0.0%st
Mem: 8163580k total, 2967840k used, 5195740k free, 200852k buffers
Swap: 4192956k total, 0k used, 4192956k free, 841416k cached
dbserver:
top - 05:03:51 up 23 days, 12:06, 1 user, load average: 1.20, 0.60, 0.50
Tasks: 125 total, 1 running, 124 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0%us, 0.3%sy, 2.2%ni, 91.8%id, 5.5%wa, 0.0%hi, 0.2%si, 0.0%st
Mem: 8163572k total, 8080468k used, 83104k free, 27560k buffers
Swap: 2096472k total, 760276k used, 1336196k free, 1633288k cached
7. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf or my.ini so post the contents inside of my.cnf (minus any passwords of course).

/etc/my.cnf :
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid



8. MySQL stats from mysqlreport

MySQL 5.0.22 uptime 1 17:46:50 Sun Jun 29 06:42:55 2008

__ Key __________________________________________________ _______________
Buffer used 6.00k of 8.00M %Used: 0.07
Current 1.46M %Usage: 18.31
Write hit 0.00%
Read hit 100.00%

__ Questions __________________________________________________ _________
Total 330.08k 2.2/s
DMS 320.26k 2.1/s %Total: 97.02
COM_QUIT 9.37k 0.1/s 2.84
Com_ 2.28k 0.0/s 0.69
-Unknown 1.83k 0.0/s 0.56
Slow 10 s 0 0/s 0.00 %DMS: 0.00 Log: OFF
DMS 320.26k 2.1/s 97.02
SELECT 320.14k 2.1/s 96.99 99.96
INSERT 123 0.0/s 0.04 0.04
REPLACE 0 0/s 0.00 0.00
DELETE 0 0/s 0.00 0.00
UPDATE 0 0/s 0.00 0.00
Com_ 2.28k 0.0/s 0.69
admin_comma 1.82k 0.0/s 0.55
set_option 375 0.0/s 0.11
change_db 88 0.0/s 0.03

__ SELECT and Sort __________________________________________________ ___
Scan 2 0.0/s %SELECT: 0.00
Range 0 0/s 0.00
Full join 0 0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 0 0/s
Sort range 0 0/s
Sort mrg pass 0 0/s

__ Table Locks __________________________________________________ _______
Waited 0 0/s %Total: 0.00
Immediate 320.27k 2.1/s

__ Tables __________________________________________________ ____________
Open 19 of 64 %Cache: 29.69
Opened 25 0.0/s

__ Connections __________________________________________________ _______
Max used 49 of 100 %Max: 49.00
Total 9.59k 0.1/s

__ Created Temp __________________________________________________ ______
Disk table 0 0/s
Table 2 0.0/s Size: 32.0M
File 5 0.0/s

__ Threads __________________________________________________ ___________
Running 1 of 17
Cached 0 of 0 %Hit: 0.01
Created 9.59k 0.1/s
Slow 0 0/s

__ Aborted __________________________________________________ ___________
Clients 433 0.0/s
Connects 1 0.0/s

__ Bytes __________________________________________________ _____________
Sent 27.62M 183.7/s
Received 23.85M 158.6/s

__ InnoDB Buffer Pool __________________________________________________
Usage 608.00k of 8.00M %Used: 7.42
Read hit 99.85%
Pages
Free 474 %Total: 92.58
Data 37 7.23 %Drty: 0.00
Misc 1 0.20
Latched 0 0.00
Reads 13.86k 0.1/s
From file 21 0.0/s 0.15
Ahead Rnd 2 0.0/s
Ahead Sql 0 0/s
Writes 322 0.0/s
Flushes 161 0.0/s
Wait Free 0 0/s

__ InnoDB Lock __________________________________________________ _______
Waits 0 0/s
Current 0
Time acquiring
Total 0 ms
Average 0 ms
Max 0 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 54 0.0/s
Writes 405 0.0/s
fsync 324 0.0/s
Pending
Reads 0
Writes 0
fsync 0

Pages
Created 0 0/s
Read 37 0.0/s
Written 161 0.0/s

Rows
Deleted 0 0/s
Inserted 80 0.0/s
Read 268 0.0/s
Updated 0 0/sFrom AdminCP:

MySQL Variables
Variable_name Value
auto_increment_increment 1
auto_increment_offset 1
automatic_sp_privileges ON
back_log 50
basedir /usr/
bdb_cache_size 8388600
bdb_home /mysql/mysql/
bdb_log_buffer_size 1280000
bdb_logdir
bdb_max_lock 10000
bdb_shared_data OFF
bdb_tmpdir /mysql/mysqltemp/
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 2
connect_timeout 15
datadir /mysql/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_example_engine NO
have_federated_engine NO
have_geometry YES
have_innodb YES
have_isam NO
have_ndbcluster NO
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 20971520
innodb_autoextend_increment 8
innodb_buffer_pool_awe_mem_mb 0
innodb_buffer_pool_size 4297064448
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 30
innodb_locks_unsafe_for_binlog OFF
innodb_log_arch_dir
innodb_log_archive OFF
innodb_log_buffer_size 8388608
innodb_log_file_size 314572800
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 3141632
key_buffer_size 2147483648
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_slave_updates OFF
log_slow_queries ON
log_warnings 1
long_query_time 3
low_priority_updates OFF
lower_case_file_system OFF
lower_case_table_names 0
max_allowed_packet 67107840
max_binlog_cache_size 18446744073709551615
max_binlog_size 1073741824
max_connect_errors 10
max_connections 550
max_delayed_threads 20
max_error_count 64
max_heap_table_size 67107840
max_insert_delayed_threads 20
max_join_size 18446744073709551615
max_length_for_sort_data 1024
max_prepared_stmt_count 16382
max_relay_log_size 0
max_seeks_for_key 18446744073709551615
max_sort_length 1024
max_sp_recursion_depth 0
max_tmp_tables 32
max_user_connections 0
max_write_lock_count 16
multi_range_count 256
myisam_data_pointer_size 6
myisam_max_sort_file_size 268435456000
myisam_recover_options OFF
myisam_repair_threads 1
myisam_sort_buffer_size 134217728
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 5560
optimizer_prune_level 1
optimizer_search_depth 62
pid_file /var/run/mysqld/mysqld.pid
prepared_stmt_count 0
port 3306
preload_buffer_size 32768
protocol_version 10
query_alloc_block_size 65536
query_cache_limit 49283072
query_cache_min_res_unit 4096
query_cache_size 360710144
query_cache_type ON
query_cache_wlock_invalidate OFF
query_prealloc_size 262144
range_alloc_block_size 2048
read_buffer_size 67104768
read_only OFF
read_rnd_buffer_size 782336
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 /mysql/mysqltemp/
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 16777208
sql_mode
sql_notes ON
sql_warnings ON
storage_engine MyISAM
sync_binlog 0
sync_frm ON
system_time_zone PDT
table_cache 2500
table_lock_wait_timeout 20
table_type MyISAM
thread_cache_size 1900
thread_stack 262144
time_format %H:%i:%s
time_zone SYSTEM
timed_mutexes OFF
tmp_table_size 1572864000
tmpdir /mysql/mysqltemp
transaction_alloc_block_size 8192
transaction_prealloc_size 4096
tx_isolation REPEATABLE-READ
updatable_views_with_limit YES
version 5.0.22-log
version_bdb Sleepycat Software: Berkeley DB 4.1.24: (May 25, 2006)
version_comment Source distribution
version_compile_machine x86_64
version_compile_os redhat-linux-gnu
wait_timeout 30
MySQL Status
Variable_name Value
Aborted_clients 6135
Aborted_connects 1013
Binlog_cache_disk_use 0
Binlog_cache_use 0
Bytes_received 2383
Bytes_sent 131005
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 6802330
Created_tmp_disk_tables 0
Created_tmp_files 3019
Created_tmp_tables 2
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 13
Handler_read_next 234
Handler_read_prev 0
Handler_read_rnd 903
Handler_read_rnd_next 1228
Handler_rollback 0
Handler_savepoint 0
Handler_savepoint_rollback 0
Handler_update 1
Handler_write 1033
Innodb_buffer_pool_pages_data 257027
Innodb_buffer_pool_pages_dirty 5273
Innodb_buffer_pool_pages_flushed 1458099
Innodb_buffer_pool_pages_free 0
Innodb_buffer_pool_pages_latched 0
Innodb_buffer_pool_pages_misc 5245
Innodb_buffer_pool_pages_total 262272
Innodb_buffer_pool_read_ahead_rnd 1923791
Innodb_buffer_pool_read_ahead_seq 950676
Innodb_buffer_pool_read_requests 39968553263
Innodb_buffer_pool_reads 54133013
Innodb_buffer_pool_wait_free 0
Innodb_buffer_pool_write_requests 16082554
Innodb_data_fsyncs 1857430
Innodb_data_pending_fsyncs 0
Innodb_data_pending_reads 0
Innodb_data_pending_writes 0
Innodb_data_read 2224653438976
Innodb_data_reads 78184330
Innodb_data_writes 2784724
Innodb_data_written 50489041408
Innodb_dblwr_pages_written 1458099
Innodb_dblwr_writes 53434
Innodb_log_waits 0
Innodb_log_write_requests 4329668
Innodb_log_writes 1701860
Innodb_os_log_fsyncs 1753231
Innodb_os_log_pending_fsyncs 0
Innodb_os_log_pending_writes 0
Innodb_os_log_written 2685201408
Innodb_page_size 16384
Innodb_pages_created 53842
Innodb_pages_read 135782343
Innodb_pages_written 1458099
Innodb_row_lock_current_waits 0
Innodb_row_lock_time 28332
Innodb_row_lock_time_avg 232
Innodb_row_lock_time_max 3104
Innodb_row_lock_waits 122
Innodb_rows_deleted 217449
Innodb_rows_inserted 577070
Innodb_rows_read 11243105364
Innodb_rows_updated 2581290
Key_blocks_not_flushed 0
Key_blocks_unused 1229055
Key_blocks_used 485715
Key_read_requests 1013311740
Key_reads 570421
Key_write_requests 11799495
Key_writes 11257160
Last_query_cost 0.000000
Max_used_connections 551
Not_flushed_delayed_rows 0
Open_files 1013
Open_streams 0
Open_tables 2497
Opened_tables 0
Qcache_free_blocks 45365
Qcache_free_memory 184998568
Qcache_hits 55060688
Qcache_inserts 21688201
Qcache_lowmem_prunes 189645
Qcache_not_cached 2825250
Qcache_queries_in_cache 119786
Qcache_total_blocks 286306
Questions 109391963
Rpl_status NULL
Select_full_join 1
Select_full_range_join 0
Select_range 0
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 903
Sort_scan 1
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 73978128
Table_locks_waited 83252
Tc_log_max_pages_used 0
Tc_log_page_size 0
Tc_log_page_waits 0
Threads_cached 548
Threads_connected 3
Threads_created 551
Threads_running 2
Uptime 5196989. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?

Wordpress, CS-Cart shopping cart software, and Advertiser Manager ad software

10. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?

Average 1000 Max 2748 cookie timeout 600

11. http://www.mothering.com/phpinfo.php

12.
KeepAlive OFF
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 50
MaxSpareServers 100
StartServers 50 (there is another setting like this under IfModule worker.c that is set to 2)
MaxClients 1200 (worker.c is set to 150)
MaxRequestsPerChild 500 (worker.c is set to 0)

13.check to see if any files i.e. apache log files are hitting 2GB or 4GB max file size limits i.e. see if you have max file size exceeded messages in apache error log

[root@web ~]# find / -size +2000000k
/home/mother/71606_forum.sql
find: /proc/9414/task/9414/fd/4: No such file or directory
find: /proc/9414/task/9414/fdinfo/4: No such file or directory
find: /proc/9414/fd/4: No such file or directory
find: /proc/9414/fdinfo/4: No such file or directoryand:
[root@db ~]# find / -size +2000000k
find: /proc/15997/task/16001/fd/125: No such file or directory
find: /proc/15997/task/16054/fdinfo/125: No such file or directory
find: /proc/15997/task/14585/fd/125: No such file or directory
find: /proc/15997/task/14590/fdinfo/125: No such file or directory
find: /proc/15997/task/14856/fdinfo/632: No such file or directory
find: /proc/15997/task/28028/fd/632: No such file or directory
find: /proc/15997/task/32529/fd/125: No such file or directory
find: /proc/15997/task/32546/fd/690: No such file or directory
find: /proc/15997/task/32551/fd/632: No such file or directory
find: /proc/15997/task/32578/fd/690: No such file or directory
find: /proc/15997/task/32593/fd/125: No such file or directory
find: /proc/15997/task/32598/fdinfo/125: No such file or directory
find: /proc/15997/task/32634/fd/632: No such file or directory
find: /proc/15997/task/32686/fdinfo/632: No such file or directory
find: /proc/15997/task/32730/fdinfo/690: No such file or directory
find: /proc/15997/task/32752/fdinfo/125: No such file or directory
find: /proc/15997/task/32764/fd/632: No such file or directory
find: /proc/15997/task/501/fd/671: No such file or directory
find: /proc/15997/task/502/fdinfo/683: No such file or directory
find: /proc/15997/task/522/fd/125: No such file or directory
find: /proc/15997/task/614/fd/683: No such file or directory
find: /proc/15997/task/891/fdinfo/721: No such file or directory
find: /proc/15997/task/959/fdinfo/683: No such file or directory
find: /proc/15997/task/987/fdinfo/125: No such file or directory
find: /proc/15997/task/988/fd/721: No such file or directory
find: /proc/24170/task/24170/fd/4: No such file or directory
find: /proc/24170/task/24170/fdinfo/4: No such file or directory
find: /proc/24170/fd/4: No such file or directory
find: /proc/24170/fdinfo/4: No such file or directory
/mysql/mysql/motherin_discussions/#sql-baa_80c3b9.MYI
/mysql/mysql/motherin_discussions/postindex.MYD
/mysql/mysql/motherin_discussions/#sql-d2d_28.MYD
/mysql/mysql/motherin_discussions/postindex.MYI
/mysql/mysql/motherin_discussions/#sql-baa_80c3b9.MYD
/mysql/mysql/motherin_discussions/#sql-baa_80c3b9.TMD
/mysql/mysql/motherin_discussions/.#sql-baa_80c3b9.MYI.gF2slz
/mysql/mysql/motherin_discussions/.#sql-baa_80c3b9.MYI.nJ6I8u
/mysql/mysql/motherin_discussions/#sql-d2d_28.TMD
/mysql/mysql/ibdata1
14.
webserver:
uname -a:
Linux web.mothering.com 2.6.23.14-admingeekz #1 SMP Sat Apr 12 06:57:24 PDT 2008 x86_64 x86_64 x86_64 GNU/Linux

ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
max nice (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 77824
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
max rt priority (-r) 0
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 77824
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited


cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU X5365 @ 3.00GHz
stepping : 11
cpu MHz : 2992.498
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 0
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good pni monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr dca lahf_lm
bogomips : 5988.19
clflush size : 64
cache_alignment : 64
address sizes : 38 bits physical, 48 bits virtual
power management:

processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU X5365 @ 3.00GHz
stepping : 11
cpu MHz : 2992.498
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 2
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good pni monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr dca lahf_lm
bogomips : 5985.04
clflush size : 64
cache_alignment : 64
address sizes : 38 bits physical, 48 bits virtual
power management:

processor : 2
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU X5365 @ 3.00GHz
stepping : 11
cpu MHz : 2992.498
cache size : 4096 KB
physical id : 1
siblings : 4
core id : 0
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good pni monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr dca lahf_lm
bogomips : 5985.03
clflush size : 64
cache_alignment : 64
address sizes : 38 bits physical, 48 bits virtual
power management:

processor : 3
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU X5365 @ 3.00GHz
stepping : 11
cpu MHz : 2992.498
cache size : 4096 KB
physical id : 1
siblings : 4
core id : 2
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good pni monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr dca lahf_lm
bogomips : 5985.05
clflush size : 64
cache_alignment : 64
address sizes : 38 bits physical, 48 bits virtual
power management:

processor : 4
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU X5365 @ 3.00GHz
stepping : 11
cpu MHz : 2992.498
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 1
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good pni monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr dca lahf_lm
bogomips : 5985.04
clflush size : 64
cache_alignment : 64
address sizes : 38 bits physical, 48 bits virtual
power management:

processor : 5
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU X5365 @ 3.00GHz
stepping : 11
cpu MHz : 2992.498
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 3
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good pni monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr dca lahf_lm
bogomips : 5985.01
clflush size : 64
cache_alignment : 64
address sizes : 38 bits physical, 48 bits virtual
power management:

processor : 6
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU X5365 @ 3.00GHz
stepping : 11
cpu MHz : 2992.498
cache size : 4096 KB
physical id : 1
siblings : 4
core id : 1
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good pni monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr dca lahf_lm
bogomips : 5984.62
clflush size : 64
cache_alignment : 64
address sizes : 38 bits physical, 48 bits virtual
power management:

processor : 7
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU X5365 @ 3.00GHz
stepping : 11
cpu MHz : 2992.498
cache size : 4096 KB
physical id : 1
siblings : 4
core id : 3
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good pni monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr dca lahf_lm
bogomips : 5985.05
clflush size : 64
cache_alignment : 64
address sizes : 38 bits physical, 48 bits virtual
power management:dbserver
uname -a:
Linux db.mothering.com 2.6.23.14-admingeekz #1 SMP Thu Apr 24 09:01:46 PDT 2008 x86_64 x86_64 x86_64 GNU/Linux

ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
max nice (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 77824
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
max rt priority (-r) 0
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 77824
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited



cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
stepping : 7
cpu MHz : 1861.915
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 0
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good pni monitor ds_cpl vmx tm2 ssse3 cx16 xtpr dca lahf_lm
bogomips : 3726.14
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
stepping : 7
cpu MHz : 1861.915
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 2
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good pni monitor ds_cpl vmx tm2 ssse3 cx16 xtpr dca lahf_lm
bogomips : 3723.83
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 2
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
stepping : 7
cpu MHz : 1861.915
cache size : 4096 KB
physical id : 1
siblings : 4
core id : 0
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good pni monitor ds_cpl vmx tm2 ssse3 cx16 xtpr dca lahf_lm
bogomips : 3723.87
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 3
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
stepping : 7
cpu MHz : 1861.915
cache size : 4096 KB
physical id : 1
siblings : 4
core id : 2
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good pni monitor ds_cpl vmx tm2 ssse3 cx16 xtpr dca lahf_lm
bogomips : 3723.86
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 4
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
stepping : 7
cpu MHz : 1861.915
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 1
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good pni monitor ds_cpl vmx tm2 ssse3 cx16 xtpr dca lahf_lm
bogomips : 3723.88
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 5
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
stepping : 7
cpu MHz : 1861.915
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 3
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good pni monitor ds_cpl vmx tm2 ssse3 cx16 xtpr dca lahf_lm
bogomips : 3723.84
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 6
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
stepping : 7
cpu MHz : 1861.915
cache size : 4096 KB
physical id : 1
siblings : 4
core id : 1
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good pni monitor ds_cpl vmx tm2 ssse3 cx16 xtpr dca lahf_lm
bogomips : 3723.21
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 7
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
stepping : 7
cpu MHz : 1861.915
cache size : 4096 KB
physical id : 1
siblings : 4
core id : 3
cpu cores : 4
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good pni monitor ds_cpl vmx tm2 ssse3 cx16 xtpr dca lahf_lm
bogomips : 3723.98
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:

[eva2000]

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

1. Upgrade MySQL 5.0.45 or 5.0.51 if possible and then upgrade PHP to 5.2.5 / 5.2.6 or if you have problems install PHP 4.4.8 (in either case install as apache module and NOT CGI. For windows based PHP try FastCGI method or ISAPI method). Backup your databases prior to mysql upgrades where possible using mysqldump via ssh telnet and not via admincp backup options or phpmyadmin which in some cases of large databases can result in incomplete backups!
2. Edit mysql server's /etc/my.cnf or c:\my.ini for windows and place the following mysql server settings in /etc/my.cnf and restart mysql server afterwards. Make sure to restart mysql server everytime you make changes to your my.cnf for the changes to take effect.

If mysql doesn't restart properly after my.cnf changes and you're on VPS server, make sure skip-innodb entry is removed or commented out from below my.cnf


[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-name-resolve
safe-show-database
old_passwords
back_log = 50
skip-innodb
max_connections = 650
key_buffer_size = 640M
myisam_sort_buffer_size = 256M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 5000
thread_cache_size = 768
wait_timeout = 20
connect_timeout = 10
tmp_table_size = 144M
max_heap_table_size = 144M
max_allowed_packet = 64M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 8
concurrent_insert = 2
table_lock_wait_timeout = 30
read_rnd_buffer_size = 1M
bulk_insert_buffer_size = 8M
query_cache_limit = 8M
query_cache_size = 384M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_write_lock_count = 16

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
nice = -10
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 64M

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


If you get mysql server gone away error messages, then keep increasing wait_timeout value in my.cnf by 60 second increments, then restart mysql after my.cnf changes for it to take effect. Test for a few days and see if you get less or eliminate that error message. If it still occurs, then keep repeating the 60 second increment until the message goes away. Each vB forum and server will have different optimal wait_timeout values depending on your vB forum traffic patterns and server hardware specifications.

3. Remove Eaccelerator or APC Cache if they're installed (check phpinfo.php url of yours to see) and instead install Xcache v1.2.1 final release or Xcache v1.2.2 http://xcache.lighttpd.net/wiki/Release-1.2.2 which seems to be a bit faster than APC Cache - http://www.vbulletin.com/forum/showthread.php?t=213267. Xcache site http://xcache.lighttpd.net/, documentation http://trac.lighttpd.net/trac/wiki/Docs and forums http://forum.lighttpd.net/forum/4

Remember to set in php.ini the values for xcache.size to 32M or 64M and for xcache.count to a value of equal to number of processor cores you have so single core cpu = 1 or single dual core cpu = 2 or single quad core cpu = 4 or dual cpus each with dual core = 4 or dual cpus each with quad core = 8.

4. Upgrade to vB 3.0.17 http://www.vbulletin.com/forum/showthread.php?t=209720 if you're on vB 3.0.xx or upgrade to vB 3.5.8 http://www.vbulletin.com/forum/showthread.php?t=221903 if you're on vB 3.5.x. Or if on vB 3.6.x, upgrade to vB 3.6.10 PL1 http://www.vbulletin.com/forum/showthread.php?t=274882.

But ultimately, the latest stable vB 3.7.2 is highly recommended http://www.vbulletin.com/forum/showthread.php?t=276496. You can use my method of upgrading outlined at http://www.vbulletin.com/forum/showthread.php?t=187770 which is essentially same in that you make a copy of your live database and import it into a new empty database and point vB 3.7.0 config.php to that new imported database name, so you essentially do an upgrade on a copy of your database, leaving original database intact in case of any problems. This method also allows you to run the original database on a different directory so to run both original forum/database along side the upgraded forum/database so you can easily revert all changed templates on upgraded forum and then using old forum/database transfer or port your custom style/images etc to the new upgrade database.

Read each versions listed thread to understand the changes that have occured etc.

5. 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

Or relevant sections in vB 3.7.x

6. Check phpinfo.php url to see if you have mod_gzip (Apache 1.3.x) or mod_deflate (Apache 2.x) loaded/installed (on phpinfo.php url page in browser you can do CTRL+F to bring up find prompt and type in mod_gzip or mod_deflate to quickly see). If you have either mod_gzip or mod_deflate loaded, then ensure vB admincp gzip compression is disabled since it's the same thing as mod_gzip or mod_deflate and double compression will just increase cpu loads. If you don't have mod_gzip or mod_deflate installed, then DO NOT set vB admincp gzip compression to a level higher than 1. Higher than 1, will only increase cpu loads unncessarily.

7. Edit httpd.conf values to following and restart apachee for each change to take effect

KeepAlive: On
MaxKeepAliveRequests: 100
KeepAliveTimeout: 3
MinSpareServers: 15
MaxSpareServers: 25
StartServers: 15
MaxClients: 256
MaxRequestsPerChild: 1000

Your maxclients is unnecessary high so lower it!

8. You may need to install same mysql version on web server, and recompile PHP with the --with-mysql=/path/to/mysql option to tell PHP to use the latest mysql 5.0.x client libraries i.e. if mysqldump/mysqlcheck/mysqladmin are located at /usr/bin/ or /usr/local/mysql/bin then you need to compile PHP with --with-mysql=/usr or --with-mysql=/usr/local/mysql - just had a few issues with one vB client have issues with PHP connecting to external mysql server until i did this.

9. If you have split web + db servers, ensure web server has dual gigabit 1000Mbps speed network cards as outlined at http://www.vbulletin.org/forum/showthread.php?t=111191

[Cynthia]

Thank you George. We'll get to work on this and report back.

Can you tell me if this statement is true for us?

MySQL is not tuned for any kind of performance…almost a completely stock configuration.

[eva2000]

Yeah that's true you're running mysql out of the box default settings so to speak from your my.cnf posted in 1st post

[Cynthia]

Thanks George. I'll report back once we get Sphinx integrated and all of the suggested optimizations done.

[eva2000]

No probs :)

[Cynthia]

George, since making these changes we are unable to fully search IP addresses. We can search a user's profile for their IP addresses and get results. But searching for others who use the same ip addresses as a user results in a timeout. We also get a time out if we search for a specific ip address. What do you suggest?

[eva2000]

try raising wait_timeout in my.cnf to 30 or 45 seconds and see if it helps (restart mysql after making my.cnf changes)

[Cynthia]

Thanks. If it still times out should we set it higher?

[eva2000]

Yeah try higher value..

You should also upgrade PHP as 5.1.6 is very old, PHP 5.2.6 is recommended

[Cynthia]

George, please read this from our server admin and advise please:
My.cnf was updated from 30 > 45. As for the php upgrade the centos official repository is 5.1.6-20, currently you were using -15 so I updated you to -20. On a side note, is there a particular advantage that 5.2.x offers over 5.1.x that trumps compliance with CentOS official repository? CentOS is the free version of RedHat Enterprise, the enterprise market has a different outlook on package updates vs developers. Redhat provides a stable platform for servers because they aren't always updating to the latest versions. Stable dosn't always mean "not crash" but more about not having to worry about commands that worked last month failing now due to an upgrade. From mailing lists RHEL5 isn't gong to be upgraded to 5.2.x php this product cycle. If the issues are about security RedHat backports all security patchs to the versions they officially support, this is one of the advantages of official CentOS repo's being used and what the -20 means. If there is a critical feature in 5.2.x let me know but I recommend staying with the official repo.

[Cynthia]

At first it worked at 45. Then later in the day, when the forum had more traffic, it started timing out again so we set it to 60. But even at 60, when the forum is really busy, it will not load the page results. Any suggestions?

We also have this issue with the Control Panel Home page.

[eva2000]

George, please read this from our server admin and advise please:
vaguely recall folks on 5.1.6 had higher cpu loads until they updated to 5.2.x series so worth a shot

try timeout value of 300 and see if it helps

[Cynthia]

Thanks George.

I did check with our server admin on the upgrade to 5.2.x and he said he looked over the graphs since we've been monitoring and doesn't see an
advantage to doing so because the server load is very low. I've attached a graph showing the load over the last week and it looks fine, never even breaks the 2.0 mark. The processors aren't being stressed so if slight efficiency boost is the only reason to upgrade wouldn't it be better to stick with the official centos repo?

[eva2000]

well it's better for web host and more convenient for them, but fact is 100000s of centos users and alot of centos vB users are using PHP 5.2.6 without issue.