1. Dedicated
2. Dual Opteron 242 1.6Ghz
2 GB Ram
Dual 120GB IDE (hardware Raid 1)
Fedora Core2
MySQL: 4.0.25
Apache: 1.3.34
PHP: 4.4.1
3. No innodb
4. with apache?
5. Top
root@server2 [/]# top
top - 19:31:31 up 1 day, 9:19, 1 user, load average: 0.41, 0.31, 0.29
Tasks: 128 total, 1 running, 126 sleeping, 0 stopped, 1 zombie
Cpu(s): 9.0% us, 1.3% sy, 0.0% ni, 86.0% id, 0.7% wa, 0.2% hi, 2.8% si
Mem: 2075092k total, 1706732k used, 368360k free, 222408k buffers
Swap: 2040244k total, 0k used, 2040244k free, 969952k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
13586 nobody 15 0 25456 12m 4940 S 10.0 0.6 0:00.30 httpd
10958 nobody 15 0 29064 16m 5064 S 4.3 0.8 0:10.65 httpd
13589 nobody 15 0 26060 12m 4900 S 2.0 0.6 0:00.06 httpd
4578 nobody 15 0 37436 24m 5496 S 0.3 1.2 21:47.02 httpd
11405 nobody 15 0 29420 17m 5228 S 0.3 0.8 0:08.88 httpd
13505 nobody 15 0 26368 14m 5132 S 0.3 0.7 0:00.31 httpd
1 root 16 0 1688 460 392 S 0.0 0.0 0:01.66 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.04 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.08 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.32 migration/1
5 root 34 19 0 0 0 S 0.0 0.0 0:00.08 ksoftirqd/1
6 root 5 -10 0 0 0 S 0.0 0.0 0:03.59 events/0
7 root 5 -10 0 0 0 S 0.0 0.0 0:02.75 events/1
8 root 9 -10 0 0 0 S 0.0 0.0 0:00.00 khelper
21 root 15 -10 0 0 0 S 0.0 0.0 0:00.00 kacpid
100 root 5 -10 0 0 0 S 0.0 0.0 0:02.15 kblockd/0
101 root 5 -10 0 0 0 S 0.0 0.0 0:01.86 kblockd/1
109 root 25 0 0 0 0 S 0.0 0.0 0:00.00 khubd
170 root 14 -10 0 0 0 S 0.0 0.0 0:00.00 aio/0
169 root 16 0 0 0 0 S 0.0 0.0 0:14.14 kswapd0
171 root 14 -10 0 0 0 S 0.0 0.0 0:00.00 aio/1
264 root 25 0 0 0 0 S 0.0 0.0 0:00.00 kseriod
454 root 21 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
470 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 ata/0
471 root 6 -10 0 0 0 S 0.0 0.0 0:00.00 ata/1
476 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1
477 root 21 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_2
478 root 21 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_3
479 root 21 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_4
494 root 15 0 0 0 0 S 0.0 0.0 0:01.21 kjournald
987 root 15 0 0 0 0 S 0.0 0.0 0:00.00 kjournald
988 root 15 0 0 0 0 S 0.0 0.0 0:03.31 kjournald
989 root 15 0 0 0 0 S 0.0 0.0 0:02.25 kjournald
990 root 15 0 0 0 0 S 0.0 0.0 0:03.42 kjournald
991 root 15 0 0 0 0 S 0.0 0.0 0:15.78 kjournald
992 root 16 0 0 0 0 S 0.0 0.0 0:15.73 kjournald
1944 root 16 0 2864 992 712 S 0.0 0.0 3:47.46 dhclient
6. my.cnf
[mysqld]
set-variable = max_connections=500
safe-show-database
7. mysql extended-status:
+--------------------------+------------+
Variable_name Value
+--------------------------+------------+
Aborted_clients 6
Aborted_connects 25
Bytes_received 632738555
Bytes_sent 3475090732
Com_admin_commands 3
Com_alter_table 27
Com_analyze 0
Com_backup_table 0
Com_begin 46
Com_change_db 176538
Com_change_master 0
Com_check 248
Com_commit 46
Com_create_db 1
Com_create_function 0
Com_create_index 36
Com_create_table 19
Com_delete 10592
Com_delete_multi 0
Com_drop_db 0
Com_drop_function 0
Com_drop_index 0
Com_drop_table 0
Com_flush 99
Com_grant 19
Com_ha_close 0
Com_ha_open 0
Com_ha_read 0
Com_insert 38472
Com_insert_select 148
Com_kill 0
Com_load 0
Com_load_master_data 0
Com_load_master_table 0
Com_lock_tables 7181
Com_optimize 247
Com_purge 0
Com_rename_table 0
Com_repair 1
Com_replace 36571
Com_replace_select 0
Com_reset 0
Com_restore_table 0
Com_revoke 0
Com_rollback 0
Com_savepoint 0
Com_select 1521685
Com_set_option 7062
Com_show_binlog_events 0
Com_show_binlogs 2
Com_show_create 2458
Com_show_databases 74
Com_show_fields 2803
Com_show_grants 149
Com_show_keys 8
Com_show_logs 0
Com_show_master_status 0
Com_show_new_master 0
Com_show_open_tables 0
Com_show_processlist 398
Com_show_slave_hosts 0
Com_show_slave_status 0
Com_show_status 1
Com_show_innodb_status 0
Com_show_tables 4088
Com_show_variables 101
Com_slave_start 0
Com_slave_stop 0
Com_truncate 0
Com_unlock_tables 4413
Com_update 177837
Com_update_multi 594
Connections 171669
Bullish on blades::
Out Blade Servers and a dual 2.6 GHz Opteron 285-based Scale Out Blade Server. we requested an AMD system based on a pair of dual-core Opteron processors, but
http://www.networkcomputing.in/Bullishonblades.aspxHOME |
Created_tmp_disk_tables 16370
Created_tmp_tables 58325
Created_tmp_files 5
Delayed_insert_threads 0
Delayed_writes 0
Delayed_errors 0
Flush_commands 1
Handler_commit 0
Handler_delete 43856
Handler_read_first 250990
Handler_read_key 55511436
Handler_read_next 23883837
Handler_read_prev 913692
Handler_read_rnd 19811304
Handler_read_rnd_next 671158789
Handler_rollback 0
Handler_update 427185
Handler_write 44067113
Key_blocks_used 7793
Key_read_requests 169155291
Key_reads 4887004
Key_write_requests 550408
Key_writes 150851
Max_used_connections 35
Not_flushed_key_blocks 0
Not_flushed_delayed_rows 0
Open_tables 64
Open_files 126
Open_streams 0
Opened_tables 325083
Questions 2163596
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 3990
Select_full_range_join 0
Select_range 413037
Select_range_check 0
Select_scan 206189
Slave_open_temp_tables 0
Slave_running OFF
Slow_launch_threads 0
Slow_queries 6
Sort_merge_passes 0
Sort_range 133272
Sort_rows 20196630
Sort_scan 86502
Table_locks_immediate 2864164
Table_locks_waited 278
Threads_cached 0
Threads_created 171668
Threads_connected 8
Threads_running 1
Uptime 115290
+--------------------------+------------+
8. Two vb sites with 100 concurrent users (20min)
three photopost galleries
two smaller vb sites (no more than 20 online)
20-30 static sites
9. avg. 100 online (max 150) for one forum. avg 80 for the other. Cookie timeout 20min
10. http://thedecostop.com/forums/vb/phpinfo.php
11.
KeepAlive: on
MaxKeepAliveRequests: 100
KeepAliveTimeout: 2
MinSpareServers: 5
MaxSpareServers: 10
StartServers: 5
MaxClients: 150
AND Maxrequestsperchild value = 0
12. 3.5.0 (patched to 3.5.2)
13. none over 2GB except for 2 backup files
Everything runs well...once in awhile (ie. once a month) things may slowdown. Just noticed I have nothing in my my.cnf and wanted the expert to look things over :)
thanks
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 = 500
key_buffer = 16M
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 = 64M
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 = 64M
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: 100
KeepAliveTimeout: 2
MinSpareServers: 5
MaxSpareServers: 10
StartServers: 5
MaxClients: 150
Maxrequestsperchild 0
to
KeepAlive: on
MaxKeepAliveRequests: 120
KeepAliveTimeout: 8
MinSpareServers: 10
MaxSpareServers: 15
StartServers: 10
MaxClients: 180
Maxrequestsperchild 250
restart apache
5. If still have issues try to 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
Everything seems good. I have not yet installed APC cache or upgraded to vb3.5.2(still patched) but did make the changes to my.cnf and httpd.conf.
here's extended status and top after 2 weeks if you could take a quick peek at them to make sure things look good.
thanks much.
+--------------------------+------------+
Variable_name Value
+--------------------------+------------+
Aborted_clients 3944
Aborted_connects 101
Bytes_received 1736143526
Bytes_sent 2237964898
Com_admin_commands 7
Com_alter_table 6
Com_analyze 0
Com_backup_table 0
Com_begin 496
Com_change_db 1965113
Com_change_master 0
Com_check 0
Com_commit 492
Com_create_db 1
Com_create_function 0
Com_create_index 1
Com_create_table 6
Com_delete 121513
Com_delete_multi 1
Com_drop_db 0
Com_drop_function 0
Com_drop_index 0
Com_drop_table 2
Com_flush 1381
Com_grant 49
Com_ha_close 0
Com_ha_open 0
Com_ha_read 0
Com_insert 356118
Com_insert_select 1238
Com_kill 0
Com_load 0
Com_load_master_data 0
Com_load_master_table 0
Com_lock_tables 58044
Com_optimize 0
Com_purge 0
Com_rename_table 0
Com_repair 0
Com_replace 330914
Com_replace_select 0
Com_reset 0
Com_restore_table 0
Com_revoke 0
Com_rollback 0
Com_savepoint 0
Com_select 6380136
Com_set_option 74601
Com_show_binlog_events 0
Com_show_binlogs 10
Com_show_create 34369
Com_show_databases 889
Com_show_fields 39367
Com_show_grants 2140
Com_show_keys 23
Com_show_logs 0
Com_show_master_status 0
Com_show_new_master 0
Com_show_open_tables 0
Com_show_processlist 3926
Com_show_slave_hosts 0
Com_show_slave_status 0
Com_show_status 4
Com_show_innodb_status 0
Com_show_tables 49998
Com_show_variables 1352
Com_slave_start 0
Com_slave_stop 0
Com_truncate 0
Com_unlock_tables 36892
Com_update 1691669
Com_update_multi 6015
Connections 1749328
Created_tmp_disk_tables 126495
Created_tmp_tables 494496
Created_tmp_files 0
Delayed_insert_threads 0
Delayed_writes 0
Delayed_errors 0
Flush_commands 1
Handler_commit 0
Handler_delete 315407
Handler_read_first 1192005
Handler_read_key 376526259
Handler_read_next 209959381
Handler_read_prev 16642321
Handler_read_rnd 173200084
Handler_read_rnd_next 1109721931
Handler_rollback 0
Handler_update 4007739
Handler_write 414742213
Key_blocks_used 15586
Key_read_requests 1184032346
Key_reads 762736
Key_write_requests 4262577
Key_writes 1291244
Max_used_connections 27
Not_flushed_key_blocks 0
Not_flushed_delayed_rows 0
Open_tables 1800
Open_files 3517
Open_streams 0
Opened_tables 32898
Questions 21512360
Qcache_queries_in_cache 13512
Qcache_inserts 6157828
Qcache_hits 8608326
Qcache_lowmem_prunes 397764
Qcache_not_cached 216263
Qcache_free_memory 22219888
Qcache_free_blocks 6584
Qcache_total_blocks 35251
Rpl_status NULL
Select_full_join 26686
Select_full_range_join 7
Select_range 1301390
Select_range_check 0
Select_scan 1206805
Slave_open_temp_tables 0
Slave_running OFF
Slow_launch_threads 0
Slow_queries 47
Sort_merge_passes 0
Sort_range 949554
Sort_rows 174429473
Sort_scan 593136
Table_locks_immediate 17116091
Table_locks_waited 2530
Threads_cached 26
Threads_created 28
Threads_connected 2
Threads_running 1
Uptime 1173704
+--------------------------+------------+
top - 07:18:59 up 16 days, 21:02, 1 user, load average: 0.22, 0.29, 0.28
Tasks: 138 total, 1 running, 137 sleeping, 0 stopped, 0 zombie
Cpu(s): 14.1% us, 1.2% sy, 0.0% ni, 83.7% id, 0.8% wa, 0.0% hi, 0.2% si
Mem: 2075092k total, 1477552k used, 597540k free, 130444k buffers
Swap: 2040244k total, 480k used, 2039764k free, 785856k cached
 Red Hat's Rough Recovery From CFO Exit
 Windows Live Finds a New, Pre-installed Home
|
