Any suggestions on our config are greatly appreciated. :D
Thanks!
-------------------
1. Dedicated
2. cpu speed/type single or dual cpus): Dual P4 Xeon 2.8Ghz
how much memory installed: 4GB RAM
hard drive type/configuration: 2X 73GB SCSI Non-RAID
linux distributor or windows version: Red Hat Enterprise Linux ES release 3 (Taroon Update 6)
apache/IIS version: Apache 1.3.34
PHP version: PHP 4.4.1
MySQL version: MySQL 4.0.25
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
NO
4. if possible how mysql was compiled/installed
Hosting company installed - apparently from RPM
5. your top stats
01:43:54 up 21 days, 14:08, 1 user, load average: 0.20, 0.20, 0.33
106 processes: 105 sleeping, 1 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 0.0% 0.0% 0.1% 0.0% 0.0% 0.6% 99.1%
cpu00 0.0% 0.0% 0.1% 0.0% 0.0% 0.0% 99.8%
cpu01 0.0% 0.0% 0.1% 0.0% 0.0% 0.0% 99.8%
cpu02 0.0% 0.0% 0.1% 0.0% 0.0% 1.1% 98.6%
cpu03 0.3% 0.0% 0.0% 0.0% 0.0% 1.3% 98.2%
Mem: 1025320k av, 989812k used, 35508k free, 0k shrd, 7248k buff
730484k actv, 141796k in_d, 16268k in_c
Swap: 2040244k av, 300840k used, 1739404k free 624272k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
1 root 15 0 116 80 56 S 0.0 0.0 0:19 1 init
2 root RT 0 0 0 0 SW 0.0 0.0 0:00 0 migration/0
3 root RT 0 0 0 0 SW 0.0 0.0 0:00 1 migration/1
4 root RT 0 0 0 0 SW 0.0 0.0 0:00 2 migration/2
5 root RT 0 0 0 0 SW 0.0 0.0 0:00 3 migration/3
6 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 keventd
7 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0 ksoftirqd/0
8 root 34 19 0 0 0 SWN 0.0 0.0 0:00 1 ksoftirqd/1
9 root 34 19 0 0 0 SWN 0.0 0.0 0:00 2 ksoftirqd/2
10 root 34 19 0 0 0 SWN 0.0 0.0 0:00 3 ksoftirqd/3
13 root 15 0 0 0 0 SW 0.0 0.0 0:00 1 bdflush
6. your mysql configuration variables located at /etc/my.cnf or c:my.cnf so post the contents inside of my.cnf (minus any passwords of course). If on Windows server if you don't have that file you need to log into telnet and as root user type
[mysqld]
set-variable = max_connections=1000
safe-show-database
7. your mysql extended-status output which shows entire server's mysql activity status
+--------------------------+------------+
Variable_name Value
+--------------------------+------------+
Aborted_clients 4678
Aborted_connects 151
Bytes_received 1967224455
Bytes_sent 277683360
Com_admin_commands 0
Com_alter_table 0
Com_analyze 0
Com_backup_table 0
Com_begin 0
Com_change_db 1307415
Com_change_master 0
Web Site Data Collection with Single Methodologies - Stratigent Web ::
web analytics and marketing optimization by reading our other newsletters In the case of large websites with multiple-server configurations, the costs are
http://www.stratigent.com/web-sight-newsletter/web-analytiction-single/default.htmlHOME |
WebGecko - APGen Frequently Asked Questions::
small sites hosted on a shared Web server, all the way up to large sites using Web farms. sites can be good candidates for APGen optimization, provided
http://www.webgecko.com/products/apgen/faq.htmHOME |
Com_check 0
Com_commit 0
Com_create_db 0
Com_create_function 0
Com_create_index 0
Com_create_table 1
Com_delete 47002
Com_delete_multi 0
Com_drop_db 0
Com_drop_function 0
Com_drop_index 0
Com_drop_table 1
Com_flush 2
Com_grant 0
Com_ha_close 0
Com_ha_open 0
Com_ha_read 0
Com_insert 203971
Com_insert_select 1831
Com_kill 0
Com_load 0
Com_load_master_data 0
Com_load_master_table 0
Com_lock_tables 478
Com_optimize 0
Com_purge 0
Com_rename_table 0
Com_repair 0
Com_replace 30586
Com_replace_select 0
Com_reset 0
Com_restore_table 0
Com_revoke 0
Com_rollback 0
Com_savepoint 0
Design for Performance: Analysis of Download Times for Page Elements ::
the design advice here, gleaned from optimizing efforts at high-volume sites. The server also refers to the socket to accept the request and return the
http://www-128.ibm.com/developerworks/websphere/library/teicles/hipods/perform.htmlHOME |
Com_select 5062089
Com_set_option 580
Com_show_binlog_events 0
Com_show_binlogs 5
Com_show_create 2
Com_show_databases 12
Com_show_fields 17
Com_show_grants 0
Com_show_keys 15
Com_show_logs 0
Com_show_master_status 0
Com_show_new_master 0
Com_show_open_tables 0
Com_show_processlist 1268
Com_show_slave_hosts 0
Com_show_slave_status 0
Com_show_status 3
Com_show_innodb_status 0
Com_show_tables 91
Com_show_variables 132
Com_slave_start 0
Com_slave_stop 0
Com_truncate 0
Com_unlock_tables 478
Com_update 1041677
Com_update_multi 100
Connections 1309404
Created_tmp_disk_tables 8328
Created_tmp_tables 47054
Created_tmp_files 61
Delayed_insert_threads 0
Delayed_writes 0
Delayed_errors 0
Flush_commands 1
Handler_commit 0
Handler_delete 173348
Handler_read_first 984698
Handler_read_key 112739475
Handler_read_next 87359990
Handler_read_prev 1855044
Handler_read_rnd 8952487
Handler_read_rnd_next 166481598
Handler_rollback 0
Handler_update 2096467
Handler_write 2463604
Key_blocks_used 7793
Key_read_requests 342772793
Key_reads 4412200
Key_write_requests 895548
Key_writes 706408
Max_used_connections 617
Not_flushed_key_blocks 0
Not_flushed_delayed_rows 0
Open_tables 64
Open_files 109
Open_streams 0
Opened_tables 244566
Questions 9002360
Qcache_queries_in_cache 0
Qcache_inserts 0
Qcache_hits 0
Qcache_lowmem_prunes 0
Qcache_not_cached 0
Qcache_free_memory 0
Qcache_free_blocks 0
Qcache_total_blocks 0
Rpl_status NULL
Select_full_join 10741
Select_full_range_join 0
Select_range 1412103
Select_range_check 0
Select_scan 341323
Slave_open_temp_tables 0
Slave_running OFF
Slow_launch_threads 8
Slow_queries 4944
Sort_merge_passes 29
Sort_range 501971
Sort_rows 9156203
Sort_scan 63317
Table_locks_immediate 8984861
Table_locks_waited 36605
Threads_cached 0
Threads_created 1309403
Threads_connected 1
Threads_running 1
Uptime 379325
+--------------------------+------------+
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
Currently, yes.
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
timeout=900
max and average users is around 1000
10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
http://forums.focaljet.com/phpinfo.php
11. 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 :
KeepAlive On
MaxKeepAliveRequests 150
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 150
Maxrequestsperchild 0
12. what version of vB are you running ?
3.5.1
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
Nope, largest log file is 669MB
Thank you! Will implement these asap.
eva wouldn't you recommend a higher min and max spare value since they have so much ram - ?
More ram in your box means less seek time on drives. Having a higher value of spare servers means they're always up and running expecting traffic - having a low value means apache needs to launch a new process and use the drives move slowing performance.
Correct me if I may be wrong but I'd suggest this
MinSpareServers 35
MaxSpareServers 50
MaxClients 300
well i'd start with recommended values and see how that goes for them wrcfan first..
1. Edit /etc/my.cnf and place the following mysql server settings in /etc/my.cnf and restart mysql server afterwards
[mysqld]
back_log = 50
skip-innodb
max_connections = 900
key_buffer = 32M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 180
connect_timeout = 10
tmp_table_size = 128M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
thread_concurrency = 4
query_cache_limit = 1M
query_cache_size = 128M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
2. 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
3. Upgrade to vB 3.5.2 http://www.vbulletin.com/forum/showthread.php?t=166391 if you're on vB 3.5.x
4. edit httpd.conf values from
KeepAlive On
MaxKeepAliveRequests 150
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 150
Maxrequestsperchild 0
to
KeepAlive On
MaxKeepAliveRequests 150
KeepAliveTimeout 8
MinSpareServers 10
MaxSpareServers 15
StartServers 10
MaxClients 150
Maxrequestsperchild 250
restart apache
5. Disable these 4 options - try these later after seeing how recommendations 1 to 4 do first:
Admin CP -> vBulletin Options -> Server Settings and Optimization 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
 Red Hat's Rough Recovery From CFO Exit
 Windows Live Finds a New, Pre-installed Home
|
