How do setup my new server for vb?

[Male_LadyBug]

i have my vb now on a seperated server "deticated"

dual p4 2ghz
2gb ram
36 scsi hdd
cpanel 6.4.2

i only have vb on this massive server

this is my info files

http://63.247.69.140/phptest.php

http://63.247.69.140/phpinfo.php (http://hawaaworld.net/phpinfo.php)

http://63.247.69.140/admin/mysqlinfo.php (http://hawaaworld.net/admin/mysqlinfo.php)

i would like to configure my my.cnf and other things on the server

[eva2000]

moved to server config forum ;)

can you provide the full details requested here http://www.vbulletin.com/forum/showthread.php?t=70117

[Raz Meister]

load average: 0.00, 0.00, 0.00Are your forums even running??

[Male_LadyBug]

now they r
before the server was down
it just started

[Male_LadyBug]

when i try to run the extended-status command i get this

root@mynono [~]# mysqladmin -u root -p extended-status
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

[stanmxl]

now they r
before the server was down
it just started

So why is the uptime over 46 days?

[RichM]

Is that a home server? That is a top spec server and i bet even vBulletin.com don't even need one as good as that let alone ONE normal forum hehe.

http://69.57.138.52/~ho/sysinfo/ is one of mine, handles 200+ sites fine with no problems so your server hosting ONE forum? Must be a BIG forum!
(ram will always *appear* to be 95% used on RedHat Linux servers)

[TheForumHost.com]

when i try to run the extended-status command i get this

root@mynono [~]# mysqladmin -u root -p extended-status
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

Log into WHM and restart your MySQL under restart services, It is the last section all the way down in your left nav frame.

If that don't work do a reboot of the server by either clicking the graceful reboot in WHM or logging into ssh and type reboot

If that still does not bring back up SQL, then next would be to reinstall it

best of luck

[Male_LadyBug]

ok here it is

deticated server
dual xeon 2.4ghz
2g ram
36g scsi
cpanel 6.4.2
redhat 7.3
apache (1.3.27 (Unix))
PHP version4.3.1
MySQL version4.0.13


my.cnf is like this

[mysqld]
set-variable = max_connections=550
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=128
set-variable = wait_timeout=14400
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
[safe_mysqld]
open_files_limit=8192
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[myisamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M

[Male_LadyBug]

mysql variables:
| 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/ |
| 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 | YES |
| 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_buffer_pool_size | 8388608 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| 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 |
| interactive_timeout | 28800 |
| join_buffer_size | 1044480 |
| key_buffer_size | 16777216 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| 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 | OFF |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_table_names | OFF |
| max_allowed_packet | 16776192 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connections | 550 |
| 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 | 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 | 0 |
| pid_file | /var/lib/mysql/hawaaworld.hawaaworld.net.pid |
| log_error | |
| port | 3306 |
| protocol_version | 10 |
| read_buffer_size | 1044480 |
| read_rnd_buffer_size | 262144 |
| rpl_recovery_rank | 0 |
| query_cache_limit | 1048576 |
| query_cache_size | 0 |
| query_cache_type | ON |
| server_id | 0 |
| slave_net_timeout | 3600 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | 0 |
| table_cache | 1024 |
| table_type | MYISAM |
| thread_cache_size | 128 |
| thread_stack | 126976 |
| tx_isolation | REPEATABLE-READ |
| timezone | EDT |
| tmp_table_size | 33554432 |
| tmpdir | /tmp/ |
| version | 4.0.13 |
| wait_timeout | 14400 |

[Male_LadyBug]

mysql extended-status:
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 0 |
| Aborted_connects | 1 |
| Bytes_received | 169268741 |
| Bytes_sent | 2587511706 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 27004 |
| 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 | 3219 |
| 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 | 4450 |
| Com_insert_select | 219 |
| 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 | 226 |
| Com_replace_select | 27 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 1520527 |
| Com_set_option | 0 |
| 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 | 30 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 8 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 0 |
| Com_show_variables | 7 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 54040 |
| Connections | 27044 |
| Created_tmp_disk_tables | 79 |
| Created_tmp_tables | 14278 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 6051 |
| Handler_read_first | 62988 |
| Handler_read_key | 7264225 |
| Handler_read_next | 33831991 |
| Handler_read_prev | 1320273 |
| Handler_read_rnd | 8913692 |
| Handler_read_rnd_next | 247718203 |
| Handler_rollback | 0 |
| Handler_update | 44397 |
| Handler_write | 1599713 |
| Key_blocks_used | 15586 |
| Key_read_requests | 32016943 |
| Key_reads | 15699 |
| Key_write_requests | 32657 |
| Key_writes | 17493 |
| Max_used_connections | 67 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 90 |
| Open_files | 107 |
| Open_streams | 0 |
| Opened_tables | 96 |
| Questions | 1636749 |
| Qcache_queries_in_cache | 0 |
| Qcache_inserts | 0 |
| Qcache_hits | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_free_memory | 0 |
| Qcache_free_blocks | 0 |
| Qcache_total_blocks | 0 |
| Rpl_status | NULL |
| Select_full_join | 4 |
| Select_full_range_join | 421 |
| Select_range | 132337 |
| Select_range_check | 0 |
| Select_scan | 120562 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 93204 |
| Sort_rows | 8989693 |
| Sort_scan | 66064 |
| Table_locks_immediate | 1719946 |
| Table_locks_waited | 2158 |
| Threads_cached | 18 |
| Threads_created | 68 |
| Threads_connected | 50 |
| Threads_running | 1 |
| Uptime | 8877 |
+--------------------------+------------+

vb is the only thing on this server
vb version is 2.2.8
average online on old server 700

[eva2000]

okay change you my.cnf to below and restart mysql


[mysqld]
max_connections = 550
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 = 128
wait_timeout = 3600
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

[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

[Male_LadyBug]

now i have 400 members now and load is 1.13 is it ok

[eva2000]

now i have 400 members now and load is 1.13 is it ok
for dual cpu server a 1 to 5 min load between 0 - 6 should be fine

my dual AthlonMP 2000+ gets average of 0.50 - 8 loads and 16.0+ loads when i do my 5+GB database backups every 12hrs

[Male_LadyBug]

now it's down :(

server load 211.00

[eva2000]

now it's down :(

server load 211.00
:eek:

it's probably time for 2 servers for your forum, 1 dedicated web server and 1 dedicated mysql server connected via a 100mbps or Gigabit nic to the web server

[Male_LadyBug]

i've got three servers i just dunno how to connect em :(

[eva2000]

you need to talk to your web host provider about this

[Male_LadyBug]

in the other dual p3 1 ghz 2 ram 36 scsi server i had this forum running and was able to handle 700 members online without problem

now with this dual xeon 2 ghz 2 ram 36 scsi it reaches 500 then i get 400 cpu load?? y??

it is very strange?

[eva2000]

in the other dual p3 1 ghz 2 ram 36 scsi server i had this forum running and was able to handle 700 members online without problem

now with this dual xeon 2 ghz 2 ram 36 scsi it reaches 500 then i get 400 cpu load?? y??

it is very strange?
vB users online doesn't tell the whole story as to your server load and mysql usage

you can have 700 vB users online

300 could be members + 400 guests which can use between 150 - 400 mysql concurrent connections (an estimate)

or you could have

650 members + 50 guests which would probably use 200 - 600+ mysql concurrent connections (estimate)

in both instances 700 vB users are displayed but the 2nd instance will take 50 - 400% mysql concurrent connections and more server resources

or the composition of your members + guests could have changed and hence the overall mysql concurrent connections/resources

btw, what's your vB time out cookie set to ?

[Male_LadyBug]

1800

[Male_LadyBug]

now it's like it's reading off the cache ALWAYS 513 users online for 3 days :(