Question about server. Need some info/help plz

[Amavisca]

Hi guys, I running 2 busy boards (each has 300-400 + online same time at all time) with several small sites.

I have some questions about setup server. Right now I am having 2 server (1 for Database and 1 for webserver)

2 X DUAL CORE OPTERON 270
4 GB RAM
2 X 73 GB
RAID 1
PRIVATE SWITCH

I am thinking to add another Dual core server. Should I get another Dual core or 2 other server (plz suggest what server you think) that are less powerful then load balance them together ?

- Also what else should I get to make the best performance out of it ( ex: get SCSI, raid ? (raid 10???) adding more Ram ??? .....

I am expecting each of my board will increase to 500+ online each, so I would like to have a setup that can handle .Please give some details info ( I have no experience about these stuff whatsoever).

Thnx you very much.

[eva2000]

Woah 2x servers each dual opteron 270 dual cores! best to post info asked at http://www.vbulletin.com/forum/showthread.php?t=70117 first before forking out for another server

[Amavisca]

Eva, here is the info you need. Plz give me an optimazation and some suggest liek if I need another server, adding more ram, add raid etc..... :

Thnx

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

- Two Dedicated Server connected to a private switch. One as Web Server and the other as Database Server.

2. your server specs.

Note : 2 Servers have the same specs.

cpu speed/type single or dual cpus): AMD Dual Core Dual Processor Opteron 270
how much memory installed: 4GB
hard drive type/configuration: 2 x 73 GB SCSI RAID1
linux distributor or windows version: RedHat Enterprise 4
apache/IIS version: apache 1.3.34
PHP version: php 4.4.1
MySQL version: mysql 4.1.14

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

- Uses Mysql 4.1.14

4. if possible how mysql was compiled/installed

- Via Standard Cpanel RPM

5. your top stats


Web Server:

top - 20:52:03 up 3 days, 21:27, 1 user, load average: 1.57, 1.48, 1.44
Tasks: 408 total, 2 running, 403 sleeping, 0 stopped, 0 zombie
Cpu(s): 11.0% us, 6.8% sy, 0.0% ni, 81.9% id, 0.1% wa, 0.2% hi, 0.0% si
Mem: 4090600k total, 3487996k used, 602604k free, 19024k buffers
Swap: 1052248k total, 144k used, 1052104k free, 778656k cached


Database Server:

top - 20:52:45 up 3 days, 21:27, 1 user, load average: 1.81, 2.26, 1.89
Tasks: 252 total, 4 running, 248 sleeping, 0 stopped, 0 zombie
Cpu(s): 15.3% us, 8.1% sy, 0.0% ni, 75.9% id, 0.0% wa, 0.7% hi, 0.0% si
Mem: 4090600k total, 3183412k used, 907188k free, 146800k buffers
Swap: 1052248k total, 0k used, 1052248k free, 2315400k cached


6. 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).

[client]
port = 3306
#socket = /home/mysql/data/mysql.sock

[mysqld]
skip-innodb
max_connections = 650
key_buffer = 96M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1500
thread_cache_size = 128
wait_timeout = 900
connect_timeout = 10
tmp_table_size = 160M
max_allowed_packet = 16M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
thread_concurrency = 2
query_cache_limit = 2M
query_cache_size = 160M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384

7. MySQL stats from ssh telnet as root user type:

[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


+---------------------------------+------------------------------------------------+
| Variable_name | Value |
+---------------------------------+------------------------------------------------+
| back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| 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 |
| concurrent_insert | ON |
| connect_timeout | 10 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| 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 | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | DISABLED |
| have_isam | NO |
| have_ndbcluster | NO |
| have_openssl | NO |
| 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_data_file_path | |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| 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_table_locks | ON |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 28800 |
| join_buffer_size | 1044480 |
| key_buffer_size | 100663296 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_error | |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 16776192 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 650 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| max_length_for_sort_data | 1024 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 67108864 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 3660 |
| pid_file | /var/lib/mysql/s80758-server2.cafebuon.net.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| protocol_version | 10 |
| query_alloc_block_size | 16384 |
| query_cache_limit | 2097152 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 167772160 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 16384 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 520192 |
| 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_net_timeout | 3600 |
| slave_transaction_retries | 0 |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | |
| storage_engine | MyISAM |
| sql_notes | OFF |
| sql_warnings | OFF |
| sync_binlog | 0 |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| sync_frm | ON |
| system_time_zone | CST |
| table_cache | 1500 |
| table_type | MyISAM |
| thread_cache_size | 128 |
| thread_stack | 126976 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 167772160 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.14-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 900 |
+---------------------------------+------------------------------------------------+
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 14655 |
| Aborted_connects | 1572 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 1435190280 |
| Bytes_sent | 206094313 |
| Com_admin_commands | 5801 |
| Com_alter_db | 0 |
| Com_alter_table | 45 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 3 |
| Com_change_db | 4620302 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 3 |
| Com_create_db | 1 |
| Com_create_function | 0 |
| Com_create_index | 36 |
| Com_create_table | 34 |
| Com_dealloc_sql | 0 |
| Com_delete | 209736 |
| 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 | 213 |
| Com_grant | 108 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 495200 |
| Com_insert_select | 3112 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 152 |
| Com_optimize | 144 |
| 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 | 47246 |
| 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 | 10964304 |
| Com_set_option | 6346 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 4 |
| Com_show_charsets | 34 |
| Com_show_collations | 34 |
| Com_show_column_types | 0 |
| Com_show_create_db | 183 |
| Com_show_create_table | 5970 |
| Com_show_databases | 76 |
| Com_show_errors | 0 |
| Com_show_fields | 5988 |
| Com_show_grants | 24 |
| Com_show_innodb_status | 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_privileges | 0 |
| Com_show_processlist | 1130 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 10 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 7161 |
| Com_show_variables | 988 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_send_long_data | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_close | 0 |
| Com_truncate | 2 |
| Com_unlock_tables | 180 |
| Com_update | 5137688 |
| Com_update_multi | 0 |
| Connections | 2365058 |
| Created_tmp_disk_tables | 39601 |
| Created_tmp_files | 776928 |
| Created_tmp_tables | 474712 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 364269 |
| Handler_discover | 0 |
| Handler_read_first | 1557300 |
| Handler_read_key | 601228646 |
| Handler_read_next | 556727545 |
| Handler_read_prev | 25673561 |
| Handler_read_rnd | 3935199630 |
| Handler_read_rnd_next | 1722606569 |
| Handler_rollback | 0 |
| Handler_update | 4530946 |
| Handler_write | 148745938 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 2625 |
| Key_blocks_used | 87225 |
| Key_read_requests | 1310528984 |
| Key_reads | 635530 |
| Key_write_requests | 28616818 |
| Key_writes | 792857 |
| Max_used_connections | 246 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 2453 |
| Open_streams | 0 |
| Open_tables | 1500 |
| Opened_tables | 9881 |
| Qcache_free_blocks | 20484 |
| Qcache_free_memory | 81643608 |
| Qcache_hits | 26117060 |
| Qcache_inserts | 9963004 |
| Qcache_lowmem_prunes | 99291 |
| Qcache_not_cached | 995326 |
| Qcache_queries_in_cache | 35596 |
| Qcache_total_blocks | 93621 |
| Questions | 49981260 |
| Rpl_status | NULL |
| Select_full_join | 12703 |
| Select_full_range_join | 0 |
| Select_range | 1255703 |
| Select_range_check | 0 |
| Select_scan | 3037089 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slave_retried_transactions | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 62500 |
| Sort_merge_passes | 388464 |
| Sort_range | 1396855 |
| Sort_rows | 66641151 |
| Sort_scan | 1882861 |
| Table_locks_immediate | 27560753 |
| Table_locks_waited | 848305 |
| Threads_cached | 87 |
| Threads_connected | 47 |
| Threads_created | 1555 |
| Threads_running | 27 |
| Uptime | 338008 |
+----------------------------+------------+
Uptime: 338008 Threads: 47 Questions: 49981261 Slow queries: 62500 Opens: 9881 Flush tables: 1 Open tables: 1500 Queri$
mysqladmin Ver 8.41 Distrib 4.1.14, for pc-linux-gnu on i686
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 4.1.14-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 3 days 21 hours 53 min 28 sec

Threads: 47 Questions: 49981261 Slow queries: 62500 Opens: 9881 Flush tables: 1 Open tables: 1500 Queries per second av$


root@s80758-server2 [/home/cnulud]# ./mysqlreport --all -tab /statistics.txt
MySQL 4.1.14-standard uptime 3 22:17:14 Mon Feb 27 21:43:17 2006

__ Key __________________________________________________ _______________
Buffer usage 85.18M of 96.00M %Used: 88.73
Write ratio 0.03
Read ratio 0.00

__ Questions __________________________________________________ _________
Total 50.23M 147.99/s
QC Hits 26.25M 77.34/s %Total: 52.26
DMS 16.94M 49.91/s 33.73
Com_ 4.67M 13.77/s 9.31
COM_QUIT 2.37M 6.98/s 4.72
-Unknown 5.79k 0.02/s 0.01
Slow 62.64k 0.18/s 0.12 %DMS: 0.37
DMS 16.94M 49.91/s 33.73
SELECT 11.02M 32.47/s 21.94 65.04
UPDATE 5.16M 15.21/s 10.28 30.47
INSERT 500.89k 1.48/s 1.00 2.96
DELETE 210.84k 0.62/s 0.42 1.24
REPLACE 47.44k 0.14/s 0.09 0.28
Com_ 4.67M 13.77/s 9.31
change_db 4.64M 13.67/s 9.24
show_tables 7.16k 0.02/s 0.01
set_option 6.35k 0.02/s 0.01

__ SELECT and Sort __________________________________________________ ___
Scan 3.05M 8.99/s %SELECT: 27.70
Range 1.26M 3.72/s 11.45
Full join 12.76k 0.04/s 0.12
Range check 0 0.00/s 0.00
Full rng join 0 0.00/s 0.00
Sort scan 1.89M 5.57/s
Sort range 1.40M 4.14/s
Sort mrg pass 390.41k 1.15/s

__ Query Cache __________________________________________________ _______
Memory usage 82.69M of 160.00M %Used: 51.68
Block Fragmnt 21.68%
Hits 26.25M 77.34/s
Inserts 10.01M 29.50/s
Prunes 100.24k 0.30/s
Insrt:Prune 99.90:1 29.21/s
Hit:Insert 2.62:1

__ Table Locks __________________________________________________ _______
Waited 853.51k 2.51/s %Total: 2.99
Immediate 27.70M 81.61/s

__ Tables __________________________________________________ ____________
Open 1.50k of 1500 %Cache: 100.00
Opened 9.89k 0.03/s

__ Connections __________________________________________________ _______
Max used 246 of 650 %Max: 37.85
Total 2.38M 7.00/s

__ Created Temp __________________________________________________ ______
Disk table 39.80k 0.12/s
Table 476.97k 1.41/s
File 780.81k 2.30/s

__ Threads __________________________________________________ ___________
Running 4 of 19
Cache 111 %Hit: 99.93
Created 1.55k 0.00/s
Slow 0 0.00/s

__ Aborted __________________________________________________ ___________
Clients 14.68k 0.04/s
Connects 1.58k 0.00/s

__ Bytes __________________________________________________ _____________
Sent 2.99G 8.82k/s
Received 1.49G 4.38k/s

8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?

I am running 2 busy vbulletin and serveral small sites

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

- Max on board a: 450 - 500
- Max on board b: 300 - 350

cookie timeout both site : 900


10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site

phpinfo (http://www.cafebanbe.net/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 Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 8
MaxSpareServers 13
StartServers 5
MaxClients 512

AND Maxrequestsperchild value = 50

12. what version of vB are you running ?
1 board vbulletin 3.5.4, other 3.06


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

-none

14. Post output from these 3 commands

uname -a:

Linux s80757-server.cafebuon.net 2.6.9-22.0.2.ELsmp #1 SMP Thu Jan 5 17:13:01 EST 2006 i686 athlon i386 GNU/Linux


ulimit -aH:

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

cat /proc/cpuinfo:

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

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

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

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

[Amavisca]

just add that I also have Eaccelerator installed.

[eva2000]

k before you do any tweaking RHE 4 is basically same as CentOS 4.2 and CentOS 4.2 has a high load bug with 2.6.9-22 kernel as explained at http://www.vbulletin.com/forum/showthread.php?t=171071 you could be suffering from same bug as your server stats should be able to handle your current mysql/traffic loads easily!

My suggestion first is to upgrade to latest stable 2.6.15 smp kernel for both web/db servers first and then repost the top stats and mysqlreport after 24-48hrs of run time with forums open

[Amavisca]

oki thnx eva, I will repost the info after upgrade.

[Amavisca]

Hi eva,
Yesterday I request my host to upgrade the kernel but here is there reply

"I'd strongly advise against upgrading your Kernel for the following reasons:

1. We will only be able to provide best effort support on a kernel update. Further, you will need to ensure that when you build your kernel, you will either need to match all kernel options and modules or go with the kitchen sink approch otherwise your box will not boot into that kernel and/or some devices will not work.

2. We will only be able to provide best effort support for all applications (even though previously fully supported) on your box.

3. You will need to be removed from redhats up2date automatic updates as any package upgrades will need to be installed with a significant amount of caution.

4. As the kernel itself has only been out for 18 days, it may have adverse affects on some of your applications (redhat or otherwise) purely as it hasnt gone though the testing that redhat kernels go though.

Again, I strongly advise not upgrading your kernel.

If you proceed, please make sure you do not remove the kernel, kernel source and ram disks for the redhat kernels on your box as otherwise you will not be able to boot your box at all."

What should I do???

Thx

Ama

[eva2000]

Definitely, get web host to do kernel updates don't do them yourselves.

I'd point your host to the kernel issue at http://www.vbulletin.com/forum/showthread.php?t=171071 alot of folks upgraded their kernels with reduction in cpu loads.