Zi5
Mon 18th Dec '06, 3:15pm
1. Dedicted Server
2. your server specs. For example:
cpu speed/type single or dual cpus): Dual Xeon 3.20GHz
how much memory installed: 2GB DDR RAM
hard drive type/configuration: Dual 180GB SATA
linux distributor or windows version: CentOS release 4.4
apache/IIS version: Apache 1.3.37
PHP version: PHP 4.4.4 with Zend Optimizer v3.0.1 and Zend Extension Manager v1.0.10
MySQL version: MySQL 4.0.27
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 ? By Cpanel
5. Your top stats
top - 10:28:17 up 2 days, 23:01, 1 user, load average: 1.01, 1.33, 1.12
Tasks: 389 total, 1 running, 387 sleeping, 1 stopped, 0 zombie
Cpu(s): 23.1% us, 2.8% sy, 0.0% ni, 61.2% id, 12.8% wa, 0.1% hi, 0.0% si
Mem: 2074736k total, 2059212k used, 15524k free, 14940k buffers
Swap: 2048248k total, 28436k used, 2019812k free, 1137504k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
23468 nobody 15 0 22428 12m 2608 S 13 0.6 0:08.35 /usr/local/apache/bin/httpd -DSSL
25944 nobody 15 0 21116 10m 2256 S 13 0.5 0:07.56 /usr/local/apache/bin/httpd -DSSL
27060 nobody 16 0 22228 11m 2160 S 13 0.6 0:00.38 /usr/local/apache/bin/httpd -DSSL
27068 nobody 15 0 19964 9960 2052 S 12 0.5 0:00.37 /usr/local/apache/bin/httpd -DSSL
27059 nobody 15 0 19988 9.8m 2088 S 11 0.5 0:00.32 /usr/local/apache/bin/httpd -DSSL
27049 nobody 16 0 22172 11m 2096 S 10 0.6 0:00.63 /usr/local/apache/bin/httpd -DSSL
25480 nobody 17 0 24368 14m 2640 S 5 0.7 0:08.71 /usr/local/apache/bin/httpd -DSSL
26716 nobody 15 0 20796 10m 2196 S 4 0.5 0:02.09 /usr/local/apache/bin/httpd -DSSL
11043 mysql 16 0 170m 116m 1820 S 3 5.7 1:10.18 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysq
1993 mysql 16 0 170m 116m 1820 S 3 5.7 1:45.25 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysq
24110 nobody 15 0 21432 11m 2200 S 2 0.6 0:01.82 /usr/local/apache/bin/httpd -DSSL
11019 mysql 15 0 170m 116m 1820 S 2 5.7 1:18.32 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysq
27046 nobody 16 0 17040 6888 2004 S 2 0.3 0:00.05 /usr/local/apache/bin/httpd -DSSL
1992 mysql 16 0 170m 116m 1820 S 1 5.7 1:48.58 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysq
26301 nobody 15 0 21260 11m 2528 S 1 0.6 0:01.36 /usr/local/apache/bin/httpd -DSSL
27047 nobody 15 0 15736 5948 2312 S 1 0.3 0:00.06 /usr/local/apache/bin/httpd -DSSL
27057 nobody 15 0 20624 10m 2104 S 1 0.5 0:00.33 /usr/local/apache/bin/httpd -DSSL
11055 mysql 15 0 170m 116m 1820 S 1 5.7 1:20.66 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysq
27067 root 16 0 2560 1152 760 R 1 0.1 0:00.07 top -c
60 root 15 0 0 0 0 S 0 0.0 2:57.59 [kswapd0]
23962 mysql 16 0 170m 116m 1820 S 0 5.7 1:05.95 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysq
26139 mysql 16 0 170m 116m 1820 S 0 5.7 0:35.52 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysq
26143 mysql 15 0 170m 116m 1820 S 0 5.7 0:35.43 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysq
24913 nobody 15 0 20940 10m 2324 S 0 0.5 0:06.66 /usr/local/apache/bin/httpd -DSSL
26358 nobody 15 0 15532 5100 1720 S 0 0.2 0:01.33 /usr/local/apache/bin/httpd -DSSL
26854 nobody 15 0 21548 11m 2160 S 0 0.6 0:00.68 /usr/local/apache/bin/httpd -DSSL
27055 nobody 16 0 20072 9.9m 2088 S 0 0.5 0:00.18 /usr/local/apache/bin/httpd -DSSL
1 root 16 0 2604 552 472 S 0 0.0 0:01.24 init [3]
2 root RT 0 0 0 0 S 0 0.0 0:01.66 [migration/0]
3 root 34 19 0 0 0 S 0 0.0 0:00.01 [ksoftirqd/0]
4 root RT 0 0 0 0 S 0 0.0 0:00.46 [migration/1]
5 root 34 19 0 0 0 S 0 0.0 0:00.01 [ksoftirqd/1]
6 root RT 0 0 0 0 S 0 0.0 0:00.30 [migration/2]
7 root 34 19 0 0 0 S 0 0.0 0:00.02 [ksoftirqd/2]
8 root RT 0 0 0 0 S 0 0.0 0:00.15 [migration/3]
9 root 34 19 0 0 0 S 0 0.0 0:00.00 [ksoftirqd/3]
6. My.cnf
[mysqld]
safe-show-database
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 = 1200
thread_cache_size = 256
wait_timeout = 8
connect_timeout = 8
tmp_table_size = 32M
max_allowed_packet = 64M
max_connect_errors = 8
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
[mysqlhotcopy]
interactive-timeout
7. MySQL stats from ssh telnet as root user type:
mysqladmin -u root -p var ext stat ver
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set | latin1 |
| character_sets | latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert | ON |
| connect_timeout | 8 |
| convert_character_set | |
| datadir | /var/lib/mysql/ |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 254 |
| ft_max_word_len_for_sort | 20 |
| ft_min_word_len | 4 |
| ft_stopword_file | (built-in) |
| have_bdb | NO |
| have_crypt | YES |
| have_innodb | DISABLED |
| have_isam | YES |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| have_symlink | YES |
| init_file | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| 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_table_locks | ON |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 28800 |
| join_buffer_size | 1044480 |
| key_buffer_size | 16777216 |
| 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 | 67107840 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 8 |
| max_connections | 500 |
| max_delayed_threads | 20 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| 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_max_extra_sort_file_size | 268435456 |
| 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 |
| open_files_limit | 10000 |
| pid_file | /var/lib/mysql/server.aradv.com.pid |
| port | 3306 |
| protocol_version | 10 |
| query_alloc_block_size | 16384 |
| query_cache_limit | 1048576 |
| query_cache_size | 67108864 |
| 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 | 262144 |
| rpl_recovery_rank | 0 |
| server_id | 0 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | 0 |
| table_cache | 1200 |
| table_type | MYISAM |
| thread_cache_size | 256 |
| thread_stack | 196608 |
| timezone | PST |
| tmp_table_size | 33554432 |
| tmpdir | /tmp/ |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.0.27-standard |
| version_comment | Official MySQL RPM |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 8 |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 3896 |
| Aborted_connects | 2 |
| Bytes_received | 2371844116 |
| Bytes_sent | 2203552608 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 678694 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 13 |
| Com_delete | 74743 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 9 |
| Com_flush | 112 |
| Com_grant | 10 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 204974 |
| Com_insert_select | 1187 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 469 |
| Com_optimize | 133 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 27464 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 3886530 |
| Com_set_option | 5357 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 2 |
| Com_show_create | 3955 |
| Com_show_databases | 65 |
| Com_show_fields | 4189 |
| Com_show_grants | 219 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 191 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 855 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_tables | 4423 |
| Com_show_variables | 86 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 469 |
| Com_update | 737048 |
| Com_update_multi | 213 |
| Connections | 630914 |
| Created_tmp_disk_tables | 1024 |
| Created_tmp_files | 64 |
| Created_tmp_tables | 393246 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 80916 |
| Handler_read_first | 730779 |
| Handler_read_key | 162519347 |
| Handler_read_next | 507169543 |
| Handler_read_prev | 23355028 |
| Handler_read_rnd | 143452243 |
| Handler_read_rnd_next | 2337474824 |
| Handler_rollback | 0 |
| Handler_update | 1472448 |
| Handler_write | 21054429 |
| Key_blocks_used | 15586 |
| Key_read_requests | 547219110 |
| Key_reads | 2696642 |
| Key_write_requests | 741744 |
| Key_writes | 643635 |
| Max_used_connections | 178 |
| Not_flushed_delayed_rows | 0 |
| Not_flushed_key_blocks | 0 |
| Open_files | 2062 |
| Open_streams | 0 |
| Open_tables | 1200 |
| Opened_tables | 6153 |
| Qcache_free_blocks | 4357 |
| Qcache_free_memory | 17001384 |
| Qcache_hits | 5970627 |
| Qcache_inserts | 3625100 |
| Qcache_lowmem_prunes | 523145 |
| Qcache_not_cached | 261283 |
| Qcache_queries_in_cache | 14892 |
| Qcache_total_blocks | 35957 |
| Questions | 12230368 |
| Rpl_status | NULL |
| Select_full_join | 380 |
| Select_full_range_join | 0 |
| Select_range | 644791 |
| Select_range_check | 0 |
| Select_scan | 687170 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 694 |
| Sort_merge_passes | 32 |
| Sort_range | 1602705 |
| Sort_rows | 144005316 |
| Sort_scan | 249658 |
| Table_locks_immediate | 7700085 |
| Table_locks_waited | 64384 |
| Threads_cached | 174 |
| Threads_connected | 5 |
| Threads_created | 179 |
| Threads_running | 4 |
| Uptime | 255693 |
+--------------------------+------------+
Uptime: 255693 Threads: 5 Questions: 12230369 Slow queries: 694 Opens: 6153 Flush tables: 1 Open tables: 1200 Queries per second avg: 47.832
mysqladmin Ver 8.40 Distrib 4.0.27, 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.0.27-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 2 days 23 hours 1 min 33 sec
Threads: 5 Questions: 12230369 Slow queries: 694 Opens: 6153 Flush tables: 1 Open tables: 1200 Queries per second avg: 47.832
7/.Mysql Report Result
MySQL 4.0.27-standard uptime 2 23:5:28 Mon Dec 18 10:33:50 2006
__ Key __________________________________________________ _______________
Buffer used 15.22M of 16.00M %Used: 95.13
Write ratio 0.868
Read ratio 0.005
__ Questions __________________________________________________ _________
Total 12.25M 47.9/s
QC Hits 5.98M 23.4/s %Total: 48.82
DMS 4.94M 19.3/s 40.33
Com_ 700.10k 2.7/s 5.72
COM_QUIT 629.76k 2.5/s 5.14
-Unknown 633 0.0/s 0.01
Slow 697 0.0/s 0.01 %DMS: 0.01
DMS 4.94M 19.3/s 40.33
SELECT 3.89M 15.2/s 31.78 78.80
UPDATE 738.12k 2.9/s 6.03 14.95
INSERT 206.40k 0.8/s 1.69 4.18
DELETE 74.85k 0.3/s 0.61 1.52
REPLACE 27.49k 0.1/s 0.22 0.56
Com_ 700.10k 2.7/s 5.72
change_db 679.53k 2.7/s 5.55
set_option 5.36k 0.0/s 0.04
show_tables 4.42k 0.0/s 0.04
__ SELECT and Sort __________________________________________________ ___
Scan 688.05k 2.7/s %SELECT: 17.68
Range 645.49k 2.5/s 16.59
Full join 382 0.0/s 0.01
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 250.03k 1.0/s
Sort range 1.61M 6.3/s
Sort mrg pass 32 0.0/s
__ Query Cache __________________________________________________ _______
Memory usage 48.78M of 64.00M %Used: 76.21
Block Fragmnt 11.68%
Hits 5.98M 23.4/s
Inserts 3.63M 14.2/s
Insrt:Prune 6.93:1 12.1/s
Hit:Insert 1.65:1
__ Table Locks __________________________________________________ _______
Waited 64.47k 0.3/s %Total: 0.83
Immediate 7.71M 30.1/s
__ Tables __________________________________________________ ____________
Open 1.20k of 1200 %Cache: 100.00
Opened 6.15k 0.0/s
__ Connections __________________________________________________ _______
Max used 178 of 500 %Max: 35.60
Total 631.72k 2.5/s
__ Created Temp __________________________________________________ ______
Disk table 1.03k 0.0/s
Table 393.67k 1.5/s
File 64 0.0/s
__ Threads __________________________________________________ ___________
Running 1 of 3
Cached 176 of 256 %Hit: 99.97
Created 179 0.0/s
Slow 0 0/s
__ Aborted __________________________________________________ ___________
Clients 3.90k 0.0/s
Connects 2 0.0/s
__ Bytes __________________________________________________ _____________
Sent 2.46G 9.6k/s
Received 2.37G 9.3k/s
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql? Their are about 3 sites that using mysql and php
9. how many average and max concurrent users on your vB forum ?800 to 1000 and what your cookie timeout is ?9000
10.PHP Info
Address: http://www.nokiagate.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 :
Timeout 30
KeepAlive Off
MaxKeepAliveRequests 120
KeepAliveTimeout 8
MinSpareServers 15
MaxSpareServers 20
StartServers 15
MaxClients 256
AND Maxrequestsperchild value =500
12. what version of vB are you running ? vBulletin 3.6.4
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
You can use this command to find such files
nothing ........
14. Post output from these 3 commands
uname -a
Linux server.aradv.com 2.6.9-42.0.3.ELsmp #1 SMP Fri Oct 6 06:21:39 CDT 2006 i686 i686 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) 32764
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 1
cpu MHz : 3200.444
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 nx lm pni monitor ds_cpl cid xtpr
bogomips : 6403.90
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 1
cpu MHz : 3200.444
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 nx lm pni monitor ds_cpl cid xtpr
bogomips : 6400.21
processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 1
cpu MHz : 3200.444
cache size : 1024 KB
physical id : 3
siblings : 2
core id : 3
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 nx lm pni monitor ds_cpl cid xtpr
bogomips : 6400.25
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 1
cpu MHz : 3200.444
cache size : 1024 KB
physical id : 3
siblings : 2
core id : 3
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 nx lm pni monitor ds_cpl cid xtpr
bogomips : 6400.37
Thanks for your best helping vBulletin Team and special thanks to eva2000 for her best solutions ..
I hope to get your reply very soon
Kinds Of Best Regards,
xNokia
2. your server specs. For example:
cpu speed/type single or dual cpus): Dual Xeon 3.20GHz
how much memory installed: 2GB DDR RAM
hard drive type/configuration: Dual 180GB SATA
linux distributor or windows version: CentOS release 4.4
apache/IIS version: Apache 1.3.37
PHP version: PHP 4.4.4 with Zend Optimizer v3.0.1 and Zend Extension Manager v1.0.10
MySQL version: MySQL 4.0.27
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 ? By Cpanel
5. Your top stats
top - 10:28:17 up 2 days, 23:01, 1 user, load average: 1.01, 1.33, 1.12
Tasks: 389 total, 1 running, 387 sleeping, 1 stopped, 0 zombie
Cpu(s): 23.1% us, 2.8% sy, 0.0% ni, 61.2% id, 12.8% wa, 0.1% hi, 0.0% si
Mem: 2074736k total, 2059212k used, 15524k free, 14940k buffers
Swap: 2048248k total, 28436k used, 2019812k free, 1137504k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
23468 nobody 15 0 22428 12m 2608 S 13 0.6 0:08.35 /usr/local/apache/bin/httpd -DSSL
25944 nobody 15 0 21116 10m 2256 S 13 0.5 0:07.56 /usr/local/apache/bin/httpd -DSSL
27060 nobody 16 0 22228 11m 2160 S 13 0.6 0:00.38 /usr/local/apache/bin/httpd -DSSL
27068 nobody 15 0 19964 9960 2052 S 12 0.5 0:00.37 /usr/local/apache/bin/httpd -DSSL
27059 nobody 15 0 19988 9.8m 2088 S 11 0.5 0:00.32 /usr/local/apache/bin/httpd -DSSL
27049 nobody 16 0 22172 11m 2096 S 10 0.6 0:00.63 /usr/local/apache/bin/httpd -DSSL
25480 nobody 17 0 24368 14m 2640 S 5 0.7 0:08.71 /usr/local/apache/bin/httpd -DSSL
26716 nobody 15 0 20796 10m 2196 S 4 0.5 0:02.09 /usr/local/apache/bin/httpd -DSSL
11043 mysql 16 0 170m 116m 1820 S 3 5.7 1:10.18 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysq
1993 mysql 16 0 170m 116m 1820 S 3 5.7 1:45.25 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysq
24110 nobody 15 0 21432 11m 2200 S 2 0.6 0:01.82 /usr/local/apache/bin/httpd -DSSL
11019 mysql 15 0 170m 116m 1820 S 2 5.7 1:18.32 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysq
27046 nobody 16 0 17040 6888 2004 S 2 0.3 0:00.05 /usr/local/apache/bin/httpd -DSSL
1992 mysql 16 0 170m 116m 1820 S 1 5.7 1:48.58 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysq
26301 nobody 15 0 21260 11m 2528 S 1 0.6 0:01.36 /usr/local/apache/bin/httpd -DSSL
27047 nobody 15 0 15736 5948 2312 S 1 0.3 0:00.06 /usr/local/apache/bin/httpd -DSSL
27057 nobody 15 0 20624 10m 2104 S 1 0.5 0:00.33 /usr/local/apache/bin/httpd -DSSL
11055 mysql 15 0 170m 116m 1820 S 1 5.7 1:20.66 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysq
27067 root 16 0 2560 1152 760 R 1 0.1 0:00.07 top -c
60 root 15 0 0 0 0 S 0 0.0 2:57.59 [kswapd0]
23962 mysql 16 0 170m 116m 1820 S 0 5.7 1:05.95 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysq
26139 mysql 16 0 170m 116m 1820 S 0 5.7 0:35.52 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysq
26143 mysql 15 0 170m 116m 1820 S 0 5.7 0:35.43 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysq
24913 nobody 15 0 20940 10m 2324 S 0 0.5 0:06.66 /usr/local/apache/bin/httpd -DSSL
26358 nobody 15 0 15532 5100 1720 S 0 0.2 0:01.33 /usr/local/apache/bin/httpd -DSSL
26854 nobody 15 0 21548 11m 2160 S 0 0.6 0:00.68 /usr/local/apache/bin/httpd -DSSL
27055 nobody 16 0 20072 9.9m 2088 S 0 0.5 0:00.18 /usr/local/apache/bin/httpd -DSSL
1 root 16 0 2604 552 472 S 0 0.0 0:01.24 init [3]
2 root RT 0 0 0 0 S 0 0.0 0:01.66 [migration/0]
3 root 34 19 0 0 0 S 0 0.0 0:00.01 [ksoftirqd/0]
4 root RT 0 0 0 0 S 0 0.0 0:00.46 [migration/1]
5 root 34 19 0 0 0 S 0 0.0 0:00.01 [ksoftirqd/1]
6 root RT 0 0 0 0 S 0 0.0 0:00.30 [migration/2]
7 root 34 19 0 0 0 S 0 0.0 0:00.02 [ksoftirqd/2]
8 root RT 0 0 0 0 S 0 0.0 0:00.15 [migration/3]
9 root 34 19 0 0 0 S 0 0.0 0:00.00 [ksoftirqd/3]
6. My.cnf
[mysqld]
safe-show-database
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 = 1200
thread_cache_size = 256
wait_timeout = 8
connect_timeout = 8
tmp_table_size = 32M
max_allowed_packet = 64M
max_connect_errors = 8
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
[mysqlhotcopy]
interactive-timeout
7. MySQL stats from ssh telnet as root user type:
mysqladmin -u root -p var ext stat ver
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set | latin1 |
| character_sets | latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert | ON |
| connect_timeout | 8 |
| convert_character_set | |
| datadir | /var/lib/mysql/ |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 254 |
| ft_max_word_len_for_sort | 20 |
| ft_min_word_len | 4 |
| ft_stopword_file | (built-in) |
| have_bdb | NO |
| have_crypt | YES |
| have_innodb | DISABLED |
| have_isam | YES |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| have_symlink | YES |
| init_file | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| 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_table_locks | ON |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 28800 |
| join_buffer_size | 1044480 |
| key_buffer_size | 16777216 |
| 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 | 67107840 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 8 |
| max_connections | 500 |
| max_delayed_threads | 20 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| 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_max_extra_sort_file_size | 268435456 |
| 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 |
| open_files_limit | 10000 |
| pid_file | /var/lib/mysql/server.aradv.com.pid |
| port | 3306 |
| protocol_version | 10 |
| query_alloc_block_size | 16384 |
| query_cache_limit | 1048576 |
| query_cache_size | 67108864 |
| 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 | 262144 |
| rpl_recovery_rank | 0 |
| server_id | 0 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | 0 |
| table_cache | 1200 |
| table_type | MYISAM |
| thread_cache_size | 256 |
| thread_stack | 196608 |
| timezone | PST |
| tmp_table_size | 33554432 |
| tmpdir | /tmp/ |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.0.27-standard |
| version_comment | Official MySQL RPM |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 8 |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 3896 |
| Aborted_connects | 2 |
| Bytes_received | 2371844116 |
| Bytes_sent | 2203552608 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 678694 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 13 |
| Com_delete | 74743 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 9 |
| Com_flush | 112 |
| Com_grant | 10 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 204974 |
| Com_insert_select | 1187 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 469 |
| Com_optimize | 133 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 27464 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 3886530 |
| Com_set_option | 5357 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 2 |
| Com_show_create | 3955 |
| Com_show_databases | 65 |
| Com_show_fields | 4189 |
| Com_show_grants | 219 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 191 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 855 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_tables | 4423 |
| Com_show_variables | 86 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 469 |
| Com_update | 737048 |
| Com_update_multi | 213 |
| Connections | 630914 |
| Created_tmp_disk_tables | 1024 |
| Created_tmp_files | 64 |
| Created_tmp_tables | 393246 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 80916 |
| Handler_read_first | 730779 |
| Handler_read_key | 162519347 |
| Handler_read_next | 507169543 |
| Handler_read_prev | 23355028 |
| Handler_read_rnd | 143452243 |
| Handler_read_rnd_next | 2337474824 |
| Handler_rollback | 0 |
| Handler_update | 1472448 |
| Handler_write | 21054429 |
| Key_blocks_used | 15586 |
| Key_read_requests | 547219110 |
| Key_reads | 2696642 |
| Key_write_requests | 741744 |
| Key_writes | 643635 |
| Max_used_connections | 178 |
| Not_flushed_delayed_rows | 0 |
| Not_flushed_key_blocks | 0 |
| Open_files | 2062 |
| Open_streams | 0 |
| Open_tables | 1200 |
| Opened_tables | 6153 |
| Qcache_free_blocks | 4357 |
| Qcache_free_memory | 17001384 |
| Qcache_hits | 5970627 |
| Qcache_inserts | 3625100 |
| Qcache_lowmem_prunes | 523145 |
| Qcache_not_cached | 261283 |
| Qcache_queries_in_cache | 14892 |
| Qcache_total_blocks | 35957 |
| Questions | 12230368 |
| Rpl_status | NULL |
| Select_full_join | 380 |
| Select_full_range_join | 0 |
| Select_range | 644791 |
| Select_range_check | 0 |
| Select_scan | 687170 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 694 |
| Sort_merge_passes | 32 |
| Sort_range | 1602705 |
| Sort_rows | 144005316 |
| Sort_scan | 249658 |
| Table_locks_immediate | 7700085 |
| Table_locks_waited | 64384 |
| Threads_cached | 174 |
| Threads_connected | 5 |
| Threads_created | 179 |
| Threads_running | 4 |
| Uptime | 255693 |
+--------------------------+------------+
Uptime: 255693 Threads: 5 Questions: 12230369 Slow queries: 694 Opens: 6153 Flush tables: 1 Open tables: 1200 Queries per second avg: 47.832
mysqladmin Ver 8.40 Distrib 4.0.27, 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.0.27-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 2 days 23 hours 1 min 33 sec
Threads: 5 Questions: 12230369 Slow queries: 694 Opens: 6153 Flush tables: 1 Open tables: 1200 Queries per second avg: 47.832
7/.Mysql Report Result
MySQL 4.0.27-standard uptime 2 23:5:28 Mon Dec 18 10:33:50 2006
__ Key __________________________________________________ _______________
Buffer used 15.22M of 16.00M %Used: 95.13
Write ratio 0.868
Read ratio 0.005
__ Questions __________________________________________________ _________
Total 12.25M 47.9/s
QC Hits 5.98M 23.4/s %Total: 48.82
DMS 4.94M 19.3/s 40.33
Com_ 700.10k 2.7/s 5.72
COM_QUIT 629.76k 2.5/s 5.14
-Unknown 633 0.0/s 0.01
Slow 697 0.0/s 0.01 %DMS: 0.01
DMS 4.94M 19.3/s 40.33
SELECT 3.89M 15.2/s 31.78 78.80
UPDATE 738.12k 2.9/s 6.03 14.95
INSERT 206.40k 0.8/s 1.69 4.18
DELETE 74.85k 0.3/s 0.61 1.52
REPLACE 27.49k 0.1/s 0.22 0.56
Com_ 700.10k 2.7/s 5.72
change_db 679.53k 2.7/s 5.55
set_option 5.36k 0.0/s 0.04
show_tables 4.42k 0.0/s 0.04
__ SELECT and Sort __________________________________________________ ___
Scan 688.05k 2.7/s %SELECT: 17.68
Range 645.49k 2.5/s 16.59
Full join 382 0.0/s 0.01
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 250.03k 1.0/s
Sort range 1.61M 6.3/s
Sort mrg pass 32 0.0/s
__ Query Cache __________________________________________________ _______
Memory usage 48.78M of 64.00M %Used: 76.21
Block Fragmnt 11.68%
Hits 5.98M 23.4/s
Inserts 3.63M 14.2/s
Insrt:Prune 6.93:1 12.1/s
Hit:Insert 1.65:1
__ Table Locks __________________________________________________ _______
Waited 64.47k 0.3/s %Total: 0.83
Immediate 7.71M 30.1/s
__ Tables __________________________________________________ ____________
Open 1.20k of 1200 %Cache: 100.00
Opened 6.15k 0.0/s
__ Connections __________________________________________________ _______
Max used 178 of 500 %Max: 35.60
Total 631.72k 2.5/s
__ Created Temp __________________________________________________ ______
Disk table 1.03k 0.0/s
Table 393.67k 1.5/s
File 64 0.0/s
__ Threads __________________________________________________ ___________
Running 1 of 3
Cached 176 of 256 %Hit: 99.97
Created 179 0.0/s
Slow 0 0/s
__ Aborted __________________________________________________ ___________
Clients 3.90k 0.0/s
Connects 2 0.0/s
__ Bytes __________________________________________________ _____________
Sent 2.46G 9.6k/s
Received 2.37G 9.3k/s
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql? Their are about 3 sites that using mysql and php
9. how many average and max concurrent users on your vB forum ?800 to 1000 and what your cookie timeout is ?9000
10.PHP Info
Address: http://www.nokiagate.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 :
Timeout 30
KeepAlive Off
MaxKeepAliveRequests 120
KeepAliveTimeout 8
MinSpareServers 15
MaxSpareServers 20
StartServers 15
MaxClients 256
AND Maxrequestsperchild value =500
12. what version of vB are you running ? vBulletin 3.6.4
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
You can use this command to find such files
nothing ........
14. Post output from these 3 commands
uname -a
Linux server.aradv.com 2.6.9-42.0.3.ELsmp #1 SMP Fri Oct 6 06:21:39 CDT 2006 i686 i686 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) 32764
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 1
cpu MHz : 3200.444
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 nx lm pni monitor ds_cpl cid xtpr
bogomips : 6403.90
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 1
cpu MHz : 3200.444
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 nx lm pni monitor ds_cpl cid xtpr
bogomips : 6400.21
processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 1
cpu MHz : 3200.444
cache size : 1024 KB
physical id : 3
siblings : 2
core id : 3
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 nx lm pni monitor ds_cpl cid xtpr
bogomips : 6400.25
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.20GHz
stepping : 1
cpu MHz : 3200.444
cache size : 1024 KB
physical id : 3
siblings : 2
core id : 3
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 nx lm pni monitor ds_cpl cid xtpr
bogomips : 6400.37
Thanks for your best helping vBulletin Team and special thanks to eva2000 for her best solutions ..
I hope to get your reply very soon
Kinds Of Best Regards,
xNokia