A Server that can handle vb 3 and 10,000 Members

[L-Mane]

Our server 100% sux and well I am making this thread for help on somehow finding a new server that will not crash every single day, not move slow, not send activation codes, and have 1000000z of other problems.

[L-Mane]

Oops sorry...move this

[eva2000]

what's your current server hardware. can you post the info requested at http://www.vbulletin.com/forum/showthread.php?t=70117 :)

[L-Mane]

1, Dedicated server

2. VB version 3 beta (5)

Dual 800 Mhz

1 GB Ram

Windows 2000 Sp4

1 18 gb

1 9 gb SCSI Hard drive non raid

php 4.2.3

MySQL version: mysql 4.13

3. N/A

4. installed with creation of server

5. Top stat? 252 members online

6. Config Variables |

| binlog_cache_size | 32768



|

| character_set | latin1



|

| character_sets | latin1 big5 czech euc_kr gb2312 gbk sjis tis

620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1

251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |

| concurrent_insert | ON



|

| connect_timeout | 5



|

| datadir | C:\mysql\data\



|

| delay_key_write | ON



|

| delayed_insert_limit | 100



|

| delayed_insert_timeout | 300



|

| delayed_queue_size | 1000



|

| flush | OFF



|

| flush_time | 1800



|

| have_bdb | NO



|

| have_gemini | NO



|

| have_innodb | DISABLED



|

| have_isam | YES



|

| have_raid | NO



|

| have_openssl | NO



|

| init_file |



|

| innodb_additional_mem_pool_size | 1048576



|

| 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 | 0



|

| 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



|

| interactive_timeout | 28800



|

| join_buffer_size | 131072



|

| key_buffer_size | 8388600



|

| language | C:\mysql\share\english\



|

| large_files_support | ON



|

| log | OFF



|

| log_update | OFF



|

| log_bin | OFF



|

| log_slave_updates | OFF



|

| log_long_queries | OFF



|

| long_query_time | 10



|

| low_priority_updates | OFF



|

| lower_case_table_names | 1



|

| max_allowed_packet | 1048576



|

| max_binlog_cache_size | 4294967295



|

| max_binlog_size | 1073741824



|

| max_connections | 100



|

| max_connect_errors | 10



|

| max_delayed_threads | 20



|

| max_heap_table_size | 16777216



|

| max_join_size | 4294967295



|

| max_sort_length | 1024



|

| max_user_connections | 0



|

| max_tmp_tables | 32



|

| max_write_lock_count | 4294967295



|

| myisam_max_extra_sort_file_size | 256



|

| myisam_max_sort_file_size | 2047



|

| myisam_recover_options | 0



|

| myisam_sort_buffer_size | 8388608



|

| named_pipe | OFF



|

| net_buffer_length | 16384



|

| net_read_timeout | 30



|

| net_retry_count | 10



|

| net_write_timeout | 60



|

| open_files_limit | 0



|

| pid_file | C:\mysql\data\allhiphop.pid



|

| port | 3306



|

| protocol_version | 10



|

| record_buffer | 131072



|

| record_rnd_buffer | 131072



|

| query_buffer_size | 0



|

| safe_show_database | OFF



|

| server_id | 0



|

| slave_net_timeout | 3600



|

| skip_locking | ON



|

| skip_networking | OFF



|

| skip_show_database | OFF



|

| slow_launch_time | 2



|

| socket | MySQL



|

| sort_buffer | 2097144



|

| sql_mode | 0



|

| table_cache | 64



|

| table_type | MYISAM



|

| thread_cache_size | 0



|

| thread_stack | 65536



|

| transaction_isolation | READ-COMMITTED



|

| timezone | Eastern Daylight Time



|

| tmp_table_size | 33554432



|

| tmpdir | C:\WINNT\TEMP\



|

| version | 3.23.53-max-nt



|

| wait_timeout | 28800

[L-Mane]

7. Extended:

+--------------------------+-----------+

| Variable_name | Value |

+--------------------------+-----------+

| Aborted_clients | 2879 |

| Aborted_connects | 1 |

| Bytes_received | 0 |

| Bytes_sent | 0 |

| Com_admin_commands | 0 |

| Com_alter_table | 0 |

| Com_analyze | 0 |

| Com_backup_table | 0 |

| Com_begin | 0 |

| Com_change_db | 2881 |

| 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 | 305 |

| Com_drop_db | 0 |

| Com_drop_function | 0 |

| Com_drop_index | 0 |

| Com_drop_table | 0 |

| Com_flush | 0 |

| Com_grant | 0 |

| Com_insert | 1027 |

| Com_insert_select | 9 |

| Com_kill | 0 |

| Com_load | 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 | 31 |

| Com_replace_select | 2 |

| Com_reset | 0 |

| Com_restore_table | 0 |

| Com_revoke | 0 |

| Com_rollback | 2878 |

| Com_select | 58260 |

| Com_set_option | 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_open_tables | 0 |

| Com_show_processlist | 0 |

| Com_show_slave_status | 0 |

| Com_show_status | 219 |

| Com_show_innodb_status | 0 |

| Com_show_tables | 0 |

| Com_show_variables | 1 |

| Com_slave_start | 0 |

| Com_slave_stop | 0 |

| Com_truncate | 0 |

| Com_unlock_tables | 0 |

| Com_update | 4537 |

| Connections | 2887 |

| Created_tmp_disk_tables | 308 |

| Created_tmp_tables | 1903 |

| Created_tmp_files | 0 |

| Delayed_insert_threads | 0 |

| Delayed_writes | 0 |

| Delayed_errors | 0 |

| Flush_commands | 1 |

| Handler_delete | 1069 |

| Handler_read_first | 1206 |

| Handler_read_key | 6199936 |

| Handler_read_next | 10542927 |

| Handler_read_prev | 0 |

| Handler_read_rnd | 461822 |

| Handler_read_rnd_next | 147970034 |

| Handler_update | 3973689 |

| Handler_write | 78833 |

| Key_blocks_used | 7764 |

| Key_read_requests | 5084666 |

| Key_reads | 16575 |

| Key_write_requests | 12122 |

| Key_writes | 2780 |

| Max_used_connections | 67 |

| Not_flushed_key_blocks | 0 |

| Not_flushed_delayed_rows | 0 |

| Open_tables | 64 |

| Open_files | 92 |

| Open_streams | 0 |

| Opened_tables | 7987 |

| Questions | 70151 |

| Select_full_join | 0 |

| Select_full_range_join | 0 |

| Select_range | 15963 |

| Select_range_check | 0 |

| Select_scan | 12032 |

| Slave_running | OFF |

| Slave_open_temp_tables | 0 |

| Slow_launch_threads | 114 |

| Slow_queries | 11 |

| Sort_merge_passes | 0 |

| Sort_range | 14851 |

| Sort_rows | 463226 |

| Sort_scan | 6532 |

| Table_locks_immediate | 80033 |

| Table_locks_waited | 287 |

| Threads_cached | 0 |

| Threads_created | 2886 |

| Threads_connected | 5 |

| Threads_running | 2 |

| Uptime | 2189 |

+--------------------------+-----------+

Uptime: 2190 Threads: 5 Questions: 70159 Slow queries: 11 Opens: 7987 Flush

tables: 1 Open tables: 64 Queries per second avg: 32.036


8. VB is on its own server

9. we average about 120 during our peak hours of 12pm - 7pm non peak average is about 40 - 80

10. http://community.allhiphop.com/admincp/phpinfo.php

11. not running Appache Win 2000

12 VB Version 3 beta

[eva2000]

sorry for the delay having ADSL internet access/ISP outages and dropouts right now

i can't seem to access your phpinfo.php url ?

Apache is your web server not Operating system. Win2000 is your Operating system.

can you post the contents of your existing my.ini or my.cnf file

[L-Mane]

the phpinfo now works sorry about that and I will get the my.ini ASAP.

[L-Mane]

my.ini

[mysqld]
basedir=C:/mysql
#bind-address=192.168.0.9
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=XX
password=XXXXXXX

[eva2000]

Okay things to do which MAY help

1. upgrade to MySQL 4.0.15
2. upgrade to PHP 4.3.3 and use ISAPI rather than run PHP as CGI mode
3. change my.ini to the below one (remember to add back your user/password) and restart mysql

[mysqld]
basedir=C:/mysql
datadir=C:/mysql/data
max_connections = 350
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 64
wait_timeout = 1800
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
skip-innodb


[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=XX
password=XXXXXXX

see if that helps

[L-Mane]

Thank you very much I will do all of this and see how things run ok.