PDA

View Full Version : Server Optimization Request - Loads Extremely High

focus
Mon 7th Jul '08, 11:06pm
1. Is this on dedicated or shared virual server. If shared, how many sites share this server (ask web host if needed).


This is 2 Dedicated Servers, 1 for SQL and the other for web, running 1 Centoss 5.2 on VMWARE ESX Virtual Machine per server.

2. your server specs. For example:



cpu speed/type single or dual cpus): Dual Intel(R) Xeon(R) CPU QUad Core L5310 @ 1.60GHz
how much memory installed: 8GB per machine, 1GB for VMWare ESX and 6-7 GB for the virtual Machine
hard drive type/configuration: RAID 10 146 SAS Drives
linux distributor or windows version: Centos 5.2 64 Bit

apache/IIS version:
Server version: Apache/2.2.9 (Unix)
Server built: Jun 23 2008 11:53:01
Server's Module Magic Number: 20051115:15
Server loaded: APR 1.3.0, APR-Util 1.3.0
Compiled using: APR 1.3.0, APR-Util 1.3.0
Architecture: 64-bit
Server MPM: Prefork
threaded: no
forked: yes (variable process count)
Server compiled with....
-D APACHE_MPM_DIR="server/mpm/prefork"
-D APR_HAS_SENDFILE
-D APR_HAS_MMAP
-D APR_HAVE_IPV6 (IPv4-mapped addresses enabled)
-D APR_USE_SYSVSEM_SERIALIZE
-D APR_USE_PTHREAD_SERIALIZE
-D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
-D APR_HAS_OTHER_CHILD
-D AP_HAVE_RELIABLE_PIPED_LOGS
-D DYNAMIC_MODULE_LIMIT=128
-D HTTPD_ROOT="/etc/httpd"
-D SUEXEC_BIN="/usr/sbin/suexec"
-D DEFAULT_PIDLOG="/var/logs/httpd.pid"
-D DEFAULT_SCOREBOARD="logs/apache_runtime_status"
-D DEFAULT_LOCKFILE="/var/logs/accept.lock"
-D DEFAULT_ERRORLOG="logs/error_log"
-D AP_TYPES_CONFIG_FILE="conf/mime.types"
-D SERVER_CONFIG_FILE="conf/httpd.conf"

PHP version:
PHP 5.2.6 (cli) (built: Jun 23 2008 12:16:21)
Copyright (c) 1997-2008 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies

MySQL version: Mysql Community 5.0.22

3. what version of vB are you running ?
VB 3.7.1

4. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
Mysql 5, No InnoDB tables

5. if possible how mysql was compiled/installed
Mysql Installed and updated by YUM

6. your top stats

Top for WEB Server:


top - 18:24:21 up 4 days, 50 min, 2 users, load average: 21.08, 21.22, 21.15
Tasks: 245 total, 17 running, 228 sleeping, 0 stopped, 0 zombie
Cpu(s): 85.1%us, 6.1%sy, 0.0%ni, 0.2%id, 0.0%wa, 3.8%hi, 4.8%si, 0.0%st
Mem: 6723280k total, 4970468k used, 1752812k free, 656316k buffers
Swap: 2048248k total, 0k used, 2048248k free, 1997184k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11219 apache 16 0 160m 29m 4060 R 14 0.5 0:28.50 httpd
11786 apache 15 0 160m 29m 3992 R 13 0.4 0:11.43 httpd
11956 apache 15 0 145m 16m 3400 S 12 0.2 0:00.76 httpd
11576 apache 15 0 161m 29m 3996 S 11 0.5 0:19.13 httpd
10761 apache 15 0 162m 30m 4048 S 11 0.5 0:46.61 httpd
11575 apache 15 0 160m 30m 4212 S 10 0.5 0:20.39 httpd
11312 apache 15 0 161m 29m 4136 S 10 0.5 0:26.21 httpd
11813 apache 15 0 147m 17m 3564 S 10 0.3 0:06.94 httpd
11858 apache 15 0 156m 25m 4052 S 10 0.4 0:06.59 httpd
11921 apache 15 0 141m 11m 3472 S 10 0.2 0:01.88 httpd
11579 apache 15 0 163m 31m 4052 S 10 0.5 0:19.84 httpd
11920 apache 15 0 141m 11m 3456 S 10 0.2 0:03.79 httpd
11935 apache 15 0 140m 10m 3236 S 10 0.2 0:02.51 httpd
11046 apache 15 0 160m 29m 4384 S 9 0.4 0:34.43 httpd
11671 apache 15 0 150m 21m 3932 S 9 0.3 0:12.17 httpd
11717 apache 15 0 158m 27m 4004 S 9 0.4 0:11.75 httpd
9693 apache 16 0 161m 30m 4420 S 9 0.5 1:10.68 httpd
10388 apache 15 0 161m 30m 4416 S 9 0.5 0:57.08 httpd
11581 apache 15 0 146m 16m 3652 S 9 0.3 0:17.80 httpd
11668 apache 15 0 141m 12m 3572 S 9 0.2 0:16.08 httpd
11785 apache 15 0 158m 27m 4356 S 9 0.4 0:09.35 httpd
11787 apache 16 0 145m 15m 3980 R 9 0.2 0:06.79 httpd
10743 apache 16 0 161m 30m 4464 R 8 0.5 0:45.88 httpd
11577 apache 15 0 160m 29m 4064 S 8 0.4 0:18.81 httpd
11634 apache 15 0 159m 28m 4048 S 8 0.4 0:15.70 httpd
11639 apache 15 0 141m 12m 3924 S 8 0.2 0:16.54 httpd
11650 apache 15 0 160m 29m 4000 R 8 0.4 0:15.61 httpd
11670 apache 16 0 161m 30m 4016 S 8 0.5 0:15.80 httpd
10996 apache 15 0 144m 13m 4040 S 8 0.2 0:37.94 httpd
11672 apache 15 0 141m 12m 3520 S 8 0.2 0:13.75 httpd
11781 apache 15 0 160m 29m 4048 S 8 0.4 0:08.98 httpd
11960 apache 15 0 139m 10m 3324 S 8 0.2 0:01.30 httpd
10826 apache 15 0 149m 18m 4472 S 8 0.3 0:40.41 httpd
11552 apache 15 0 145m 15m 4004 R 8 0.2 0:18.23 httpd
11962 apache 15 0 141m 11m 3380 S 8 0.2 0:00.55 httpd
11591 apache 15 0 160m 29m 4012 S 7 0.4 0:17.80 httpd

Top for SQL server

top - 18:23:56 up 9 days, 13:14, 2 users, load average: 0.15, 0.28, 0.39
Tasks: 100 total, 1 running, 99 sleeping, 0 stopped, 0 zombie
Cpu(s): 2.7%us, 2.3%sy, 0.0%ni, 88.4%id, 0.6%wa, 3.5%hi, 2.5%si, 0.0%st
Mem: 5859284k total, 5798492k used, 60792k free, 274932k buffers
Swap: 2048248k total, 116k used, 2048132k free, 4819816k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3019 mysql 15 0 826m 521m 4056 S 26 9.1 3346:35 mysqld
1428 root 10 -5 0 0 0 S 2 0.0 1:48.89 kjournald
1 root 15 0 10312 692 576 S 0 0.0 0:03.31 init
2 root RT 0 0 0 0 S 0 0.0 0:26.04 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:13.11 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:02.38 watchdog/0
5 root RT 0 0 0 0 S 0 0.0 0:06.61 migration/1
6 root 34 19 0 0 0 S 0 0.0 0:00.05 ksoftirqd/1
7 root RT 0 0 0 0 S 0 0.0 0:00.03 watchdog/1
8 root RT 0 0 0 0 S 0 0.0 0:06.89 migration/2
9 root 34 19 0 0 0 S 0 0.0 0:00.04 ksoftirqd/2
10 root RT 0 0 0 0 S 0 0.0 0:00.02 watchdog/2
11 root RT 0 0 0 0 S 0 0.0 0:06.69 migration/3
12 root 34 19 0 0 0 S 0 0.0 0:00.05 ksoftirqd/3
13 root RT 0 0 0 0 S 0 0.0 0:00.01 watchdog/3
14 root 10 -5 0 0 0 S 0 0.0 29:21.76 events/0
15 root 10 -5 0 0 0 S 0 0.0 0:15.35 events/1
16 root 10 -5 0 0 0 S 0 0.0 0:07.82 events/2
17 root 10 -5 0 0 0 S 0 0.0 0:04.38 events/3
18 root 10 -5 0 0 0 S 0 0.0 0:00.00 khelper
67 root 11 -5 0 0 0 S 0 0.0 0:00.01 kthread
74 root 10 -5 0 0 0 S 0 0.0 1:08.31 kblockd/0
75 root 10 -5 0 0 0 S 0 0.0 0:15.69 kblockd/1
76 root 10 -5 0 0 0 S 0 0.0 0:14.67 kblockd/2
77 root 10 -5 0 0 0 S 0 0.0 0:13.79 kblockd/3
78 root 14 -5 0 0 0 S 0 0.0 0:00.00 kacpid
135 root 14 -5 0 0 0 S 0 0.0 0:00.00 cqueue/0
136 root 15 -5 0 0 0 S 0 0.0 0:00.00 cqueue/1
137 root 15 -5 0 0 0 S 0 0.0 0:00.00 cqueue/2
138 root 15 -5 0 0 0 S 0 0.0 0:00.00 cqueue/3
141 root 14 -5 0 0 0 S 0 0.0 0:00.00 khubd
143 root 10 -5 0 0 0 S 0 0.0 0:00.00 kseriod
228 root 20 0 0 0 0 S 0 0.0 0:00.00 pdflush
229 root 15 0 0 0 0 S 0 0.0 2:45.95 pdflush
230 root 10 -5 0 0 0 S 0 0.0 0:06.66 kswapd0
231 root 16 -5 0 0 0 S 0 0.0 0:00.00 aio/0
232 root 17 -5 0 0 0 S 0 0.0 0:00.00 aio/1
233 root 17 -5 0 0 0 S 0 0.0 0:00.00 aio/2

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).
[mysqld]
skip-name-resolve
#bind-address=127.0.0.1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=4M
query_cache_size=128M
query_cache_type=1
max_connections=3072
interactive_timeout=100
wait_timeout=300
#wait_timeout=100
#wait_timeout=28800
#connect_timeout=20
connect_timeout=15
thread_cache_size=128
key_buffer=64M
join_buffer=1M
max_allowed_packet=64M
table_cache=1024
record_buffer=1M
sort_buffer_size=4M
read_buffer_size=4M
max_connect_errors=20
thread_concurrency=4
myisam_sort_buffer_size=128M

[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=20000

[mysqldump]
quick
max_allowed_packet=128M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=128M
sort_buffer=128M
read_buffer=64M
write_buffer=64M

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

[mysqlhotcopy]
interactive-timeout

8. MySQL stats from ssh
+---------------------------------+--------------------------------------------------------+
| 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 | /var/lib/mysql/ |
| bdb_log_buffer_size | 524288 |
| 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 | 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 | 15 |
| 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_example_engine | NO |
| have_federated_engine | NO |
| have_geometry | YES |
| have_innodb | DISABLED |
| 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 | 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 | |
| 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 | 100 |
| join_buffer_size | 1044480 |
| key_buffer_size | 67108864 |
| 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 | 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 | 67107840 |
| max_binlog_cache_size | 18446744073709551615 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 20 |
| max_connections | 3072 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| 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 | 18446744073709551615 |
| multi_range_count | 256 |
| myisam_data_pointer_size | 6 |
| myisam_max_sort_file_size | 9223372036854775807 |
| 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 | 15370 |
| 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 | 8192 |
| query_cache_limit | 4194304 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 134217728 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 4190208 |
| 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 | 4194296 |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | ON |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| system_time_zone | EDT |
| table_cache | 1024 |
| table_lock_wait_timeout | 50 |
| table_type | MyISAM |
| thread_cache_size | 128 |
| thread_stack | 262144 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| timed_mutexes | OFF |
| tmp_table_size | 33554432 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| updatable_views_with_limit | YES |
| version | 5.0.22 |
| 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 | 300 |
+---------------------------------+--------------------------------------------------------+
+-----------------------------------+---------------+
| Variable_name | Value |
+-----------------------------------+---------------+
| Aborted_clients | 9113 |
| Aborted_connects | 1824 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 44051695885 |
| Bytes_sent | 9023345572356 |
| Com_admin_commands | 9538 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 28513822 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 747 |
| Com_create_table | 3449 |
| Com_dealloc_sql | 3118 |
| Com_delete | 119823 |
| Com_delete_multi | 47 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 2704 |
| Com_drop_user | 0 |
| Com_execute_sql | 69670 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 4259526 |
| Com_insert_select | 11556 |
| 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 | 4845 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 118332 |
| 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 | 27525316 |
| Com_set_option | 4157587 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 9 |
| Com_show_charsets | 31 |
| Com_show_collations | 31 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 1 |
| Com_show_databases | 31 |
| Com_show_errors | 0 |
| Com_show_fields | 2757 |
| Com_show_grants | 11 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 749 |
| 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 | 3 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 2553 |
| Com_show_triggers | 0 |
| Com_show_variables | 354 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 3118 |
| Com_stmt_execute | 69670 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare | 4845 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 738 |
| Com_unlock_tables | 0 |
| Com_update | 9509336 |
| Com_update_multi | 735 |
| 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 | 21268124 |
| Created_tmp_disk_tables | 255776 |
| Created_tmp_files | 5580 |
| Created_tmp_tables | 5453780 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 3647815 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 1849789 |
| Handler_read_key | 2466551502 |
| Handler_read_next | 2897718066 |
| Handler_read_prev | 15832762 |
| Handler_read_rnd | 1594258279 |
| Handler_read_rnd_next | 13979844929 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 37924132 |
| Handler_write | 1567690812 |
| Innodb_buffer_pool_pages_data | 0 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 0 |
| Innodb_buffer_pool_pages_free | 0 |
| Innodb_buffer_pool_pages_latched | 0 |
| Innodb_buffer_pool_pages_misc | 0 |
| Innodb_buffer_pool_pages_total | 0 |
| Innodb_buffer_pool_read_ahead_rnd | 0 |
| Innodb_buffer_pool_read_ahead_seq | 0 |
| Innodb_buffer_pool_read_requests | 0 |
| Innodb_buffer_pool_reads | 0 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 0 |
| Innodb_data_fsyncs | 0 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 0 |
| Innodb_data_reads | 0 |
| Innodb_data_writes | 0 |
| Innodb_data_written | 0 |
| Innodb_dblwr_pages_written | 0 |
| Innodb_dblwr_writes | 0 |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 0 |
| Innodb_log_writes | 0 |
| Innodb_os_log_fsyncs | 0 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 0 |
| Innodb_page_size | 0 |
| Innodb_pages_created | 0 |
| Innodb_pages_read | 0 |
| Innodb_pages_written | 0 |
| 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 | 0 |
| Innodb_rows_inserted | 0 |
| Innodb_rows_read | 0 |
| Innodb_rows_updated | 0 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 0 |
| Key_blocks_used | 53585 |
| Key_read_requests | 8212991203 |
| Key_reads | 54475969 |
| Key_write_requests | 54897985 |
| Key_writes | 16729981 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 546 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 1139 |
| Open_streams | 0 |
| Open_tables | 1022 |
| Opened_tables | 12208 |
| Qcache_free_blocks | 2648 |
| Qcache_free_memory | 61792384 |
| Qcache_hits | 94468974 |
| Qcache_inserts | 25691582 |
| Qcache_lowmem_prunes | 971330 |
| Qcache_not_cached | 1839247 |
| Qcache_queries_in_cache | 9628 |
| Qcache_total_blocks | 23384 |
| Questions | 189970367 |
| Rpl_status | NULL |
| Select_full_join | 9589 |
| Select_full_range_join | 224 |
| Select_range | 2533816 |
| Select_range_check | 0 |
| Select_scan | 13276639 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 11248 |
| Sort_merge_passes | 2790 |
| Sort_range | 6543371 |
| Sort_rows | 1975368427 |
| Sort_scan | 5608539 |
| 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 | 59306734 |
| Table_locks_waited | 2022670 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 110 |
| Threads_connected | 18 |
| Threads_created | 12830 |
| Threads_running | 3 |
| Uptime | 879317 |
+-----------------------------------+---------------+
Uptime: 879317 Threads: 20 Questions: 189970373 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 1022 Queries per second avg: 216.043
mysqladmin Ver 8.41 Distrib 5.0.22, for redhat-linux-gnu on x86_64
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 5.0.22
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 10 days 4 hours 15 min 17 sec

Threads: 20 Questions: 189970373 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 1022 Queries per second avg: 216.043
+----------+----------------------+-------------------+--------------------+---------+------+------------------+--------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----------+----------------------+-------------------+--------------------+---------+------+------------------+----------------------+
| 21268076 | database_user | 192.168.1.2:57797 | database_db | Sleep | 1 | | |
| 21268094 | database_user | 192.168.1.2:57815 | database_db | Sleep | 0 | | |
| 21268097 | database_user | 192.168.1.2:57818 | database_db | Sleep | 0 | | |
| 21268103 | database_user | 192.168.1.2:57824 | database_db | Sleep | 0 | | |
| 21268107 | database_user | 192.168.1.2:57828 | database_db | Sleep | 0 | | |
| 21268108 | database_user | 192.168.1.2:57829 | database_db | Sleep | 0 | | |
| 21268111 | database_user | 192.168.1.2:57832 | database_db | Sleep | 0 | | |
| 21268113 | database_user | 192.168.1.2:57834 | database_db | Sleep | 0 | | |
| 21268115 | database_user | 192.168.1.2:57836 | database_db | Sleep | 0 | | |
| 21268116 | database_user | 192.168.1.2:57837 | database_db | Sleep | 0 | | |
| 21268117 | database_user | 192.168.1.2:57838 | database_db | Sleep | 0 | | |
| 21268118 | database_user | 192.168.1.2:57839 | database_db | Sleep | 1 | | |
| 21268119 | database_user | 192.168.1.2:57840 | database_db | Query | 0 | Writing to net | SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache |
| 21268120 | database_user | 192.168.1.2:57841 | database_db | Query | 0 | Writing to net | SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache |
| 21268121 | database_user | 192.168.1.2:57842 | database_db | Sleep | 0 | | |
| 21268122 | unauthenticated user | 192.168.1.2:57843 | | Connect | | Reading from net | |
| 21268123 | root | localhost | | Query | 0 | | show processlist|
| 21268124 | database_user | 192.168.1.2:57844 | montreal_photopost | Sleep | 0 | | |
| 21268125 | unauthenticated user | 192.168.1.2:57845 | | Connect | | Reading from net | |
| 21268126 | unauthenticated user | 192.168.1.2:57846 | | Connect | | Reading from net | |
+----------+----------------------+-------------------+--------------------+---------+------+------------------+-------------------+
focus
Mon 7th Jul '08, 11:07pm
#
# Beginning report, 0 0:0:0
#
MySQL 5.0.22 uptime 10 3:58:25 Mon Jul 7 18:13:13 2008

__ Key __________________________________________________ _______________
Buffer used 52.33M of 64.00M %Used: 81.76
Current 64.00M %Usage: 100.00
Write hit 69.55%
Read hit 99.34%

__ Questions __________________________________________________ _________
Total 189.71M 216.0/s
QC Hits 94.34M 107.4/s %Total: 49.73
DMS 41.49M 47.2/s 21.87
Com_ 32.80M 37.3/s 17.29
COM_QUIT 21.23M 24.2/s 11.19
-Unknown 157.23k 0.2/s 0.08
Slow 10 s 11.25k 0.0/s 0.01 %DMS: 0.03 Log: OFF
DMS 41.49M 47.2/s 21.87
SELECT 27.49M 31.3/s 14.49 66.26
UPDATE 9.50M 10.8/s 5.01 22.89
INSERT 4.26M 4.9/s 2.25 10.27
DELETE 119.62k 0.1/s 0.06 0.29
REPLACE 118.14k 0.1/s 0.06 0.28
Com_ 32.80M 37.3/s 17.29
change_db 28.47M 32.4/s 15.01
set_option 4.15M 4.7/s 2.19
execute_sql 69.67k 0.1/s 0.04

__ SELECT and Sort __________________________________________________ ___
Scan 13.26M 15.1/s %SELECT: 48.23
Range 2.53M 2.9/s 9.20
Full join 9.58k 0.0/s 0.03
Range check 0 0/s 0.00
Full rng join 224 0.0/s 0.00
Sort scan 5.60M 6.4/s
Sort range 6.54M 7.4/s
Sort mrg pass 2.78k 0.0/s

__ Query Cache __________________________________________________ _______
Memory usage 59.74M of 128.00M %Used: 46.67
Block Fragmnt 12.32%
Hits 94.34M 107.4/s
Inserts 25.66M 29.2/s
Insrt:Prune 26.42:1 28.1/s
Hit:Insert 3.68:1

__ Table Locks __________________________________________________ _______
Waited 2.02M 2.3/s %Total: 3.30
Immediate 59.22M 67.4/s

__ Tables __________________________________________________ ____________
Open 1022 of 1024 %Cache: 99.80
Opened 12.21k 0.0/s

__ Connections __________________________________________________ _______
Max used 546 of 3072 %Max: 17.77
Total 21.24M 24.2/s

__ Created Temp __________________________________________________ ______
Disk table 255.34k 0.3/s
Table 5.45M 6.2/s Size: 32.0M
File 5.57k 0.0/s

__ Threads __________________________________________________ ___________
Running 4 of 18
Cached 110 of 128 %Hit: 99.94
Created 12.83k 0.0/s
Slow 0 0/s

__ Aborted __________________________________________________ ___________
Clients 9.11k 0.0/s
Connects 1.82k 0.0/s

__ Bytes __________________________________________________ _____________
Sent 9.01T 10.3M/s
Received 43.99G 50.1k/s

__ InnoDB Buffer Pool __________________________________________________
Usage 0 of 0 %Used: 0.00
Read hit 0.00%
Pages
Free 0 %Total: 0.00
Data 0 0.00 %Drty: 0.00
Misc 0 0.00
Latched 0 0.00
Reads 0 0/s
From file 0 0/s 0.00
Ahead Rnd 0 0/s
Ahead Sql 0 0/s
Writes 0 0/s
Flushes 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 0 0/s
Writes 0 0/s
fsync 0 0/s
Pending
Reads 0
Writes 0
fsync 0

Pages
Created 0 0/s
Read 0 0/s
Written 0 0/s

Rows
Deleted 0 0/s
Inserted 0 0/s
Read 0 0/s
Updated 0 0/s

#
# Interval report 1, +0 0:0:10
#
MySQL 5.0.22 uptime 10 3:58:35 Mon Jul 7 18:13:23 2008

__ Key __________________________________________________ _______________
Buffer used 52.33M of 64.00M %Used: 81.76
Current 64.00M %Usage: 100.00
Write hit 0.00%
Read hit 99.96%

__ Questions __________________________________________________ _________
Total 2.49k 248.9/s
QC Hits 1.26k 125.7/s %Total: 50.50
DMS 531 53.1/s 21.33
Com_ 419 41.9/s 16.83
COM_QUIT 277 27.7/s 11.13
+Unknown 5 0.5/s 0.20
Slow 10 s 0 0/s 0.00 %DMS: 0.00 Log: OFF
DMS 531 53.1/s 21.33
SELECT 340 34.0/s 13.66 64.03
UPDATE 146 14.6/s 5.87 27.50
INSERT 44 4.4/s 1.77 8.29
REPLACE 1 0.1/s 0.04 0.19
DELETE 0 0/s 0.00 0.00
Com_ 419 41.9/s 16.83
change_db 383 38.3/s 15.39
set_option 34 3.4/s 1.37
show_status 1 0.1/s 0.04

__ SELECT and Sort __________________________________________________ ___
Scan 183 18.3/s %SELECT: 53.82
Range 39 3.9/s 11.47
Full join 0 0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 72 7.2/s
Sort range 31 3.1/s
Sort mrg pass 0 0/s

__ Query Cache __________________________________________________ _______
Memory usage 60.85M of 128.00M %Used: 47.54
Block Fragmnt 11.84%
Hits 1.26k 125.7/s
Inserts 331 33.1/s
Insrt:Prune 331:1 33.0/s
Hit:Insert 3.80:1

__ Table Locks __________________________________________________ _______
Waited 6 0.6/s %Total: 0.75
Immediate 796 79.6/s

__ Tables __________________________________________________ ____________
Open 1022 of 1024 %Cache: 99.80
Opened 0 0/s

__ Connections __________________________________________________ _______
Max used 546 of 3072 %Max: 17.77
Total 279 27.9/s

__ Created Temp __________________________________________________ ______
Disk table 1 0.1/s
Table 69 6.9/s Size: 32.0M
File 0 0/s

__ Threads __________________________________________________ ___________
Running 2 of 18
Cached 110 of 128 %Hit: 100
Created 0 0/s
Slow 0 0/s

__ Aborted __________________________________________________ ___________
Clients 0 0/s
Connects 0 0/s

__ Bytes __________________________________________________ _____________
Sent 130.99M 13.1M/s
Received 569.09k 56.9k/s

__ InnoDB Buffer Pool __________________________________________________
Usage 0 of 0 %Used: 0.00
Read hit 0.00%
Pages
Free 0 %Total: 0.00
Data 0 0.00 %Drty: 0.00
Misc 0 0.00
Latched 0 0.00
Reads 0 0/s
From file 0 0/s 0.00
Ahead Rnd 0 0/s
Ahead Sql 0 0/s
Writes 0 0/s
Flushes 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 0 0/s
Writes 0 0/s
fsync 0 0/s
Pending
Reads 0
Writes 0
fsync 0

Pages
Created 0 0/s
Read 0 0/s
Written 0 0/s

Rows
Deleted 0 0/s
Inserted 0 0/s
Read 0 0/s
Updated 0 0/s

9. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
VB and wordpress are running on the 1 site

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

15 minute timeout, and this is the results when I did the tests: Currently Active Users: 375 (204 members and 171 guests)
Threads: 489,995, Posts: 5,310,168, Members: 50,521

11. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
http://www.montrealracing.com/p3.php

12. if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following :

<IfModule mpm_prefork_module>

ServerLimit 514
StartServers 12
MinSpareServers 20
MaxSpareServers 40
MaxClients 345
MaxRequestsPerChild 1000
</IfModule>


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
No Files hitting 2GB

14. Post output from these 3 commands

Linux 2.6.18-53.1.21.el5 #1 SMP Tue May 20 09:35:07 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux


[root@web1 extra]# 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) 56000
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) 56000
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited



processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU L5310 @ 1.60GHz
stepping : 8
cpu MHz : 1595.759
cache size : 4096 KB
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 syscall nx lm constant_tsc pni ds_cpl cx16 lahf_lm
bogomips : 3198.29
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 L5310 @ 1.60GHz
stepping : 8
cpu MHz : 1595.759
cache size : 4096 KB
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 syscall nx lm constant_tsc pni ds_cpl cx16 lahf_lm
bogomips : 3192.48
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 L5310 @ 1.60GHz
stepping : 8
cpu MHz : 1595.759
cache size : 4096 KB
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 syscall nx lm constant_tsc pni ds_cpl cx16 lahf_lm
bogomips : 3192.56
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 L5310 @ 1.60GHz
stepping : 8
cpu MHz : 1595.759
cache size : 4096 KB
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 syscall nx lm constant_tsc pni ds_cpl cx16 lahf_lm
bogomips : 3192.56
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:
eva2000
Tue 8th Jul '08, 12:11pm
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]
skip-name-resolve
safe-show-database
#old_passwords
back_log = 50
skip-innodb
max_connections = 800
key_buffer_size = 512M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 3M
table_cache = 8000
thread_cache_size = 768
wait_timeout = 20
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 16
concurrent_insert = 2
table_lock_wait_timeout = 30
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 6M
query_cache_size = 144M
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

[mysqld_safe]
err-log=/var/log/mysqld.log
nice = -10
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
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 PL3 http://www.vbulletin.com/forum/showthread.php?t=277945.

But ultimately, the latest stable vB 3.7.2 PL1 is highly recommended http://www.vbulletin.com/forum/showthread.php?postid=1585047. 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. For web server, edit httpd.conf values to following and restart apachee for each change to take effect

<IfModule mpm_prefork_module>

ServerLimit 384
StartServers 20
MinSpareServers 20
MaxSpareServers 25
MaxClients 256
MaxRequestsPerChild 1000
</IfModule>

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

10. Also optimise (defrag) your databases using ssh telnet command on occassion especially if you've pruned/deleted alot of data from mysql databases.

mysqlcheck -u root -p -o --all-databases