activa
Mon 27th Feb '06, 12:16pm
1. Is this on dedicated or shared virual server. If shared, how many sites share this server (ask web host if needed)
VPS ( 1 Vbulletin + 3 Site only Html Page)
2. your server specs. :
cpu speed/type dual cpus : Intel(R) Xeon(TM) CPU 2.80GHz , speed: 2800.218 MHz , cache size: 1024 KB
how much memory installed: 256 ram boostable to 1 Gb
hard drive type/configuration: 20GB EIDE non raid
linux distributor or windows version: redhat linux 7.3
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 ?
Any idea , i just use mysql for vbulletin
4. if possible how mysql was compiled/installed
No idea !!!
5. your top stats
15:34:26 up 52 days, 16:14, 1 user, load average: 4.78, 4.15, 3.93
141 processes: 109 sleeping, 7 running, 25 zombie, 0 stopped
CPU0 states: 41.0% user 30.0% system 0.0% nice 0.0% iowait 27.0% idle
CPU1 states: 47.0% user 22.0% system 0.0% nice 0.0% iowait 29.0% idle
Mem: 8266708k av, 8237696k used, 29012k free, 0k shrd, 1814404k buff
4848000k active, 2881028k inactive
Swap: 16386292k av, 5795608k used, 10590684k free 2564716k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
30946 root 17 0 3708 1656 1656 R 99.9 0.0 153:34 1 httpd
10657 nobody 10 0 0 0 0 Z 9.0 0.0 0:00 0 httpd <defunct>
10240 nobody 9 0 0 0 0 Z 3.7 0.0 0:00 0 httpd <defunct>
9090 root 11 0 1144 1144 748 R 3.1 0.0 0:00 1 top
25888 mysql 9 0 92256 78M 37804 S 1.8 0.9 33:39 0 mysqld
8608 root 9 0 3164 3160 2644 D 1.2 0.0 0:00 1 rpm
7618 nobody 9 0 0 0 0 Z 0.9 0.0 0:00 1 httpd <defunct>
7937 nobody 9 0 0 0 0 Z 0.9 0.0 0:00 1 httpd <defunct>
8675 nobody 9 0 0 0 0 Z 0.9 0.0 0:00 0 httpd <defunct>
3802 root 9 0 1244 1104 1060 S 0.3 0.0 2:13 1 sshd
11648 nobody 9 0 0 0 0 Z 0.3 0.0 0:00 0 httpd <defunct>
11905 nobody 9 0 0 0 0 Z 0.3 0.0 0:00 0 httpd <defunct>
12160 nobody 9 0 0 0 0 Z 0.3 0.0 0:00 0 httpd <defunct>
12325 nobody 9 0 0 0 0 Z 0.3 0.0 0:00 0 httpd <defunct>
12352 nobody 9 0 0 0 0 Z 0.3 0.0 0:00 0 httpd <defunct>
13025 nobody 11 0 0 0 0 Z 0.3 0.0 0:00 0 httpd <defunct>
1 root 8 0 468 440 420 S 0.0 0.0 1:04 0 init
3766 root 9 0 548 516 480 S 0.0 0.0 0:34 0 syslogd
3777 nobody 8 0 1668 1200 1100 S 0.0 0.0 0:36 1 proftpd
3995 root 8 0 576 548 512 S 0.0 0.0 0:19 1 crond
4492 root 9 0 612 528 528 S 0.0 0.0 0:00 1 portsentry
2603 root 9 0 3108 1476 1376 S 0.0 0.0 3:48 1 upcp
2605 root 9 0 3244 1476 1476 S 0.0 0.0 0:00 0 upcp
3164 root 9 0 880 780 780 S 0.0 0.0 0:00 1 sh
3165 root 9 0 1156 984 984 S 0.0 0.0 0:00 0 checkperlmodule
3175 root 9 0 3884 1260 1260 S 0.0 0.0 0:06 1 perlinstaller
3179 root 9 0 8268 1308 1308 S 0.0 0.0 0:00 1 realperlinstall
6. your mysql configuration variables located
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-networking
port = 3306
skip-locking
safe-show-database
back_log = 50
skip-innodb
max_connections = 650
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 =64
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
[mysqlhotcopy]
interactive-timeout
7. MySQL stats from ssh :
+---------------------------------+------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------+
| 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 | 10
|
| 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_min_word_len | 4
|
| ft_max_word_len | 254
|
| ft_max_word_len_for_sort | 20
|
| ft_stopword_file | (built-in)
|
| have_bdb | NO
|
| have_crypt | YES
|
| have_innodb | DISABLED
|
| have_isam | YES
|
| have_raid | NO
|
| have_symlink | YES
|
| have_openssl | NO
|
| have_query_cache | 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_file_io_threads | 4
|
| innodb_force_recovery | 0
| innodb_thread_concurrency | 8
|
| innodb_flush_log_at_trx_commit | 1
|
| innodb_fast_shutdown | ON
|
| innodb_flush_method |
|
| 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_mirrored_log_groups | 1
|
| innodb_max_dirty_pages_pct | 90
|
| innodb_max_purge_lag | 0
|
| innodb_table_locks | ON
|
| 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_update | OFF
|
| log_bin | OFF
|
| 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 | 4294967295
|
| max_binlog_size | 1073741824
|
| max_connections | 650
|
| max_connect_errors | 10
|
| max_delayed_threads | 20
|
| max_insert_delayed_threads | 20
|
| max_heap_table_size | 16777216
|
| max_join_size | 4294967295
|
| max_relay_log_size | 0
| max_seeks_for_key | 4294967295
|
| max_sort_length | 1024
|
| max_user_connections | 0
|
| max_tmp_tables | 32
|
| max_write_lock_count | 4294967295
|
| myisam_max_extra_sort_file_size | 268435456
|
| myisam_max_sort_file_size | 2147483647
|
| myisam_repair_threads | 1
|
| myisam_recover_options | OFF
|
| 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 | 4260 |
| pid_file | /var/lib/mysql/server.all-patch.org.pid |
| log_error | |
| 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 | 520192 |
| rpl_recovery_rank | 0 |
| server_id | 0 |
| slave_net_timeout | 3600 |
| skip_external_locking | ON |
| skip_networking | ON |
| skip_show_database | OFF |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | 0 |
| table_cache | 1800 |
| table_type | MYISAM |
| thread_cache_size | 64 |
| thread_stack | 126976 |
| tx_isolation | REPEATABLE-READ |
| timezone | WET |
| tmp_table_size | 67108864 |
| tmpdir | /tmp/ |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| version | 4.0.25-standard |
| version_comment | Official MySQL RPM |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 180 |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+--------------------------+-----------+
| Variable_name | Value |
+--------------------------+-----------+
| Aborted_clients | 22 |
| Aborted_connects | 3 |
| Bytes_received | 883197741 |
| Bytes_sent | 418011975 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 229599 |
| 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 | 0 |
| Com_delete | 57455 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 109405 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 6415 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 904273 |
| Com_set_option | 65 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 792 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 45 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 3 |
| Com_show_variables | 12 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 262362 |
| Com_update_multi | 0 |
| Connections | 230434 |
| Created_tmp_disk_tables | 9573 |
| Created_tmp_tables | 39632 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 41819 |
| Handler_read_first | 82152 |
| Handler_read_key | 13198711 |
| Handler_read_next | 10475375 |
| Handler_read_prev | 1354067 |
| Handler_read_rnd | 4579143 |
| Handler_read_rnd_next | 115724012 |
| Handler_rollback | 0 |
| Handler_update | 337510 |
| Handler_write | 2002023 |
| Key_blocks_used | 15586 |
| Key_read_requests | 51498034 |
| Key_reads | 43276 |
| Key_write_requests | 220037 |
| Key_writes | 161261 |
| Max_used_connections | 31 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 351 |
| Open_files | 456 |
| Open_streams | 0 |
| Opened_tables | 357 |
| Questions | 4465995 |
| Qcache_queries_in_cache | 11187 |
| Qcache_inserts | 889803 |
| Qcache_hits | 2665149 |
| Qcache_lowmem_prunes | 23579 |
| Qcache_not_cached | 14470 |
| Qcache_free_memory | 14427136 |
| Qcache_free_blocks | 5153 |
| Qcache_total_blocks | 29411 |
| Rpl_status | NULL |
| Select_full_join | 201 |
| Select_full_range_join | 0 |
| Select_range | 165676 |
| Select_range_check | 0 |
| Select_scan | 230823 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 11 |
| Sort_merge_passes | 0 |
| Sort_range | 178016 |
| Sort_rows | 4575330 |
| Sort_scan | 91475 |
| Table_locks_immediate | 2385868 |
| Table_locks_waited | 3306 |
| Threads_cached | 30 |
| Threads_created | 32 |
| Threads_connected | 2 |
| Threads_running | 1 |
| Uptime | 228223 |
+--------------------------+-----------+
Uptime: 228223 Threads: 2 Questions: 4465996 Slow queries: 11 Opens: 357 Flush tables: 1 Open tables: 351 Queries per second avg: 19.569
mysqladmin Ver 8.40 Distrib 4.0.25, 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.25-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 2 days 15 hours 23 min 43 sec
Threads: 2 Questions: 4465996 Slow queries: 11 Opens: 357 Flush tables: 1 Open tables: 351 Queries per second avg: 19.569
8. is your vB the only thing on the server?
another php/mysql script , usage 10 %(e107.org)
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
Now 150 To 200 , Kokies Timeout 900 .
But i suggest that the max users online well be 300 .
10. create a file named phpinfo.php
http://all-patch.org/phpinfo.php
11.
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 8
MinSpareServers 5
MaxSpareServers 15
StartServers 5
MaxClients 350
Maxrequestsperchild value = 5000
12. what version of vB are you running ?
VB 3.5.4
13. no files ,
14.
Linux server.all-patch.org 2.4.20-021stab028.17.777-enterprise #1 SMP Tue Jul 19 19:31:27 MSD 2005 i686 i686 i386 GNU/Linux
core file size (blocks, -c) 1000000
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 4096
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimited
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 1
cpu MHz : 2800.218
cache size : 1024 KB
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 lm
bogomips : 5583.66
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 1
cpu MHz : 2800.218
cache size : 1024 KB
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 lm
bogomips : 5596.77
VPS ( 1 Vbulletin + 3 Site only Html Page)
2. your server specs. :
cpu speed/type dual cpus : Intel(R) Xeon(TM) CPU 2.80GHz , speed: 2800.218 MHz , cache size: 1024 KB
how much memory installed: 256 ram boostable to 1 Gb
hard drive type/configuration: 20GB EIDE non raid
linux distributor or windows version: redhat linux 7.3
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 ?
Any idea , i just use mysql for vbulletin
4. if possible how mysql was compiled/installed
No idea !!!
5. your top stats
15:34:26 up 52 days, 16:14, 1 user, load average: 4.78, 4.15, 3.93
141 processes: 109 sleeping, 7 running, 25 zombie, 0 stopped
CPU0 states: 41.0% user 30.0% system 0.0% nice 0.0% iowait 27.0% idle
CPU1 states: 47.0% user 22.0% system 0.0% nice 0.0% iowait 29.0% idle
Mem: 8266708k av, 8237696k used, 29012k free, 0k shrd, 1814404k buff
4848000k active, 2881028k inactive
Swap: 16386292k av, 5795608k used, 10590684k free 2564716k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
30946 root 17 0 3708 1656 1656 R 99.9 0.0 153:34 1 httpd
10657 nobody 10 0 0 0 0 Z 9.0 0.0 0:00 0 httpd <defunct>
10240 nobody 9 0 0 0 0 Z 3.7 0.0 0:00 0 httpd <defunct>
9090 root 11 0 1144 1144 748 R 3.1 0.0 0:00 1 top
25888 mysql 9 0 92256 78M 37804 S 1.8 0.9 33:39 0 mysqld
8608 root 9 0 3164 3160 2644 D 1.2 0.0 0:00 1 rpm
7618 nobody 9 0 0 0 0 Z 0.9 0.0 0:00 1 httpd <defunct>
7937 nobody 9 0 0 0 0 Z 0.9 0.0 0:00 1 httpd <defunct>
8675 nobody 9 0 0 0 0 Z 0.9 0.0 0:00 0 httpd <defunct>
3802 root 9 0 1244 1104 1060 S 0.3 0.0 2:13 1 sshd
11648 nobody 9 0 0 0 0 Z 0.3 0.0 0:00 0 httpd <defunct>
11905 nobody 9 0 0 0 0 Z 0.3 0.0 0:00 0 httpd <defunct>
12160 nobody 9 0 0 0 0 Z 0.3 0.0 0:00 0 httpd <defunct>
12325 nobody 9 0 0 0 0 Z 0.3 0.0 0:00 0 httpd <defunct>
12352 nobody 9 0 0 0 0 Z 0.3 0.0 0:00 0 httpd <defunct>
13025 nobody 11 0 0 0 0 Z 0.3 0.0 0:00 0 httpd <defunct>
1 root 8 0 468 440 420 S 0.0 0.0 1:04 0 init
3766 root 9 0 548 516 480 S 0.0 0.0 0:34 0 syslogd
3777 nobody 8 0 1668 1200 1100 S 0.0 0.0 0:36 1 proftpd
3995 root 8 0 576 548 512 S 0.0 0.0 0:19 1 crond
4492 root 9 0 612 528 528 S 0.0 0.0 0:00 1 portsentry
2603 root 9 0 3108 1476 1376 S 0.0 0.0 3:48 1 upcp
2605 root 9 0 3244 1476 1476 S 0.0 0.0 0:00 0 upcp
3164 root 9 0 880 780 780 S 0.0 0.0 0:00 1 sh
3165 root 9 0 1156 984 984 S 0.0 0.0 0:00 0 checkperlmodule
3175 root 9 0 3884 1260 1260 S 0.0 0.0 0:06 1 perlinstaller
3179 root 9 0 8268 1308 1308 S 0.0 0.0 0:00 1 realperlinstall
6. your mysql configuration variables located
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-networking
port = 3306
skip-locking
safe-show-database
back_log = 50
skip-innodb
max_connections = 650
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 =64
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
[mysqlhotcopy]
interactive-timeout
7. MySQL stats from ssh :
+---------------------------------+------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------+
| 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 | 10
|
| 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_min_word_len | 4
|
| ft_max_word_len | 254
|
| ft_max_word_len_for_sort | 20
|
| ft_stopword_file | (built-in)
|
| have_bdb | NO
|
| have_crypt | YES
|
| have_innodb | DISABLED
|
| have_isam | YES
|
| have_raid | NO
|
| have_symlink | YES
|
| have_openssl | NO
|
| have_query_cache | 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_file_io_threads | 4
|
| innodb_force_recovery | 0
| innodb_thread_concurrency | 8
|
| innodb_flush_log_at_trx_commit | 1
|
| innodb_fast_shutdown | ON
|
| innodb_flush_method |
|
| 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_mirrored_log_groups | 1
|
| innodb_max_dirty_pages_pct | 90
|
| innodb_max_purge_lag | 0
|
| innodb_table_locks | ON
|
| 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_update | OFF
|
| log_bin | OFF
|
| 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 | 4294967295
|
| max_binlog_size | 1073741824
|
| max_connections | 650
|
| max_connect_errors | 10
|
| max_delayed_threads | 20
|
| max_insert_delayed_threads | 20
|
| max_heap_table_size | 16777216
|
| max_join_size | 4294967295
|
| max_relay_log_size | 0
| max_seeks_for_key | 4294967295
|
| max_sort_length | 1024
|
| max_user_connections | 0
|
| max_tmp_tables | 32
|
| max_write_lock_count | 4294967295
|
| myisam_max_extra_sort_file_size | 268435456
|
| myisam_max_sort_file_size | 2147483647
|
| myisam_repair_threads | 1
|
| myisam_recover_options | OFF
|
| 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 | 4260 |
| pid_file | /var/lib/mysql/server.all-patch.org.pid |
| log_error | |
| 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 | 520192 |
| rpl_recovery_rank | 0 |
| server_id | 0 |
| slave_net_timeout | 3600 |
| skip_external_locking | ON |
| skip_networking | ON |
| skip_show_database | OFF |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | 0 |
| table_cache | 1800 |
| table_type | MYISAM |
| thread_cache_size | 64 |
| thread_stack | 126976 |
| tx_isolation | REPEATABLE-READ |
| timezone | WET |
| tmp_table_size | 67108864 |
| tmpdir | /tmp/ |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| version | 4.0.25-standard |
| version_comment | Official MySQL RPM |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 180 |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+--------------------------+-----------+
| Variable_name | Value |
+--------------------------+-----------+
| Aborted_clients | 22 |
| Aborted_connects | 3 |
| Bytes_received | 883197741 |
| Bytes_sent | 418011975 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 229599 |
| 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 | 0 |
| Com_delete | 57455 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 109405 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 6415 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 904273 |
| Com_set_option | 65 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 792 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 45 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 3 |
| Com_show_variables | 12 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 262362 |
| Com_update_multi | 0 |
| Connections | 230434 |
| Created_tmp_disk_tables | 9573 |
| Created_tmp_tables | 39632 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 41819 |
| Handler_read_first | 82152 |
| Handler_read_key | 13198711 |
| Handler_read_next | 10475375 |
| Handler_read_prev | 1354067 |
| Handler_read_rnd | 4579143 |
| Handler_read_rnd_next | 115724012 |
| Handler_rollback | 0 |
| Handler_update | 337510 |
| Handler_write | 2002023 |
| Key_blocks_used | 15586 |
| Key_read_requests | 51498034 |
| Key_reads | 43276 |
| Key_write_requests | 220037 |
| Key_writes | 161261 |
| Max_used_connections | 31 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 351 |
| Open_files | 456 |
| Open_streams | 0 |
| Opened_tables | 357 |
| Questions | 4465995 |
| Qcache_queries_in_cache | 11187 |
| Qcache_inserts | 889803 |
| Qcache_hits | 2665149 |
| Qcache_lowmem_prunes | 23579 |
| Qcache_not_cached | 14470 |
| Qcache_free_memory | 14427136 |
| Qcache_free_blocks | 5153 |
| Qcache_total_blocks | 29411 |
| Rpl_status | NULL |
| Select_full_join | 201 |
| Select_full_range_join | 0 |
| Select_range | 165676 |
| Select_range_check | 0 |
| Select_scan | 230823 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 11 |
| Sort_merge_passes | 0 |
| Sort_range | 178016 |
| Sort_rows | 4575330 |
| Sort_scan | 91475 |
| Table_locks_immediate | 2385868 |
| Table_locks_waited | 3306 |
| Threads_cached | 30 |
| Threads_created | 32 |
| Threads_connected | 2 |
| Threads_running | 1 |
| Uptime | 228223 |
+--------------------------+-----------+
Uptime: 228223 Threads: 2 Questions: 4465996 Slow queries: 11 Opens: 357 Flush tables: 1 Open tables: 351 Queries per second avg: 19.569
mysqladmin Ver 8.40 Distrib 4.0.25, 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.25-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 2 days 15 hours 23 min 43 sec
Threads: 2 Questions: 4465996 Slow queries: 11 Opens: 357 Flush tables: 1 Open tables: 351 Queries per second avg: 19.569
8. is your vB the only thing on the server?
another php/mysql script , usage 10 %(e107.org)
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
Now 150 To 200 , Kokies Timeout 900 .
But i suggest that the max users online well be 300 .
10. create a file named phpinfo.php
http://all-patch.org/phpinfo.php
11.
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 8
MinSpareServers 5
MaxSpareServers 15
StartServers 5
MaxClients 350
Maxrequestsperchild value = 5000
12. what version of vB are you running ?
VB 3.5.4
13. no files ,
14.
Linux server.all-patch.org 2.4.20-021stab028.17.777-enterprise #1 SMP Tue Jul 19 19:31:27 MSD 2005 i686 i686 i386 GNU/Linux
core file size (blocks, -c) 1000000
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 4096
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimited
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 1
cpu MHz : 2800.218
cache size : 1024 KB
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 lm
bogomips : 5583.66
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 1
cpu MHz : 2800.218
cache size : 1024 KB
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 lm
bogomips : 5596.77