rastacat
Sat 12th Mar '05, 5:17pm
This may be a bit different request as Vbulletin is not yet running.
I've installed and imported a test run of our current UBB Classic forum.
Threads: 83,564, Posts: 559,618, Members: 21,007
Import went fairly well and tests show no problems.
I was just about to dump the test import and do a real one but am concerned about the servers ability to handle the traffic after reading through your "optimization" forum.
Our UBB stats showed 400 online last week with the forum we wish to convert.
I'd hate to do the import and go live only to have refused connections and general mayhem.
---------------------------
1:
Dedicated Server - (although we have about 30 of our own domains on it) one with a forum using about half the traffic of the one being imported - but it's planned to bring it into VBulletin as well.
2:
Single 3.06 cpu, showing as a dual processor
1 gb of Ram
RedHat 7.3
80gb IDE drive
apache (1.3.33 (Unix))
php 4.3.10 - Turck MMCache v2.4.6
mysql (4.0.23-standard)
Zend Optimizer v2.5.7
3. innodb type databases/tables on your server ? Unknown
4. if possible how mysql was compiled/installed - Unknown
5. your top stats
3:39pm up 189 days, 30 min, 1 user, load average: 0.52, 0.56, 0.54
140 processes: 139 sleeping, 1 running, 0 zombie, 0 stopped
CPU0 states: 18.4% user, 3.2% system, 0.0% nice, 77.2% idle
CPU1 states: 18.2% user, 4.3% system, 0.0% nice, 76.3% idle
Mem: 1031236K av, 973964K used, 57272K free, 0K shrd, 156948K buff
Swap: 2096440K av, 75940K used, 2020500K free 364424K cached
This is with the current UBB Classic showing 230 in recent visitors
Second domain using ubb classic on this server shows:120
--------------------------
6. your mysql configuration variables located at /etc/my.cnf
This is all that shows up in /etc/my.cnf
[mysqld]
set-variable = max_connections=500
---------------------------
mysqladmin -u root -p variables?
link to text file (http://www.thirstyriver.com/info.txt)
----
7. your mysql extended-status output
mysqladmin -u root -p extended-status
+--------------------------+-----------+
| Variable_name | Value |
+--------------------------+-----------+
| Aborted_clients | 0 |
| Aborted_connects | 2 |
| Bytes_received | 3249658 |
| Bytes_sent | 396617652 |
| Com_admin_commands | 0 |
| Com_alter_table | 9 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 782 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 2 |
| Com_create_function | 0 |
| Com_create_index | 8 |
| Com_create_table | 10 |
| Com_delete | 943 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 4 |
| Com_grant | 9 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 1235 |
| Com_insert_select | 1 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 1226 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 429 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 9524 |
| Com_set_option | 111 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 1 |
| Com_show_create | 111 |
| Com_show_databases | 3 |
| Com_show_fields | 111 |
| 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 | 263 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 3 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 142 |
| Com_show_variables | 5 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 1226 |
| Com_update | 1199 |
| Connections | 1818 |
| Created_tmp_disk_tables | 7 |
| Created_tmp_tables | 704 |
| Created_tmp_files | 3 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 1349 |
| Handler_read_first | 3049 |
| Handler_read_key | 193243 |
| Handler_read_next | 280301 |
| Handler_read_prev | 656 |
| Handler_read_rnd | 15349 |
| Handler_read_rnd_next | 5587722 |
| Handler_rollback | 0 |
| Handler_update | 65204 |
| Handler_write | 6227 |
| Key_blocks_used | 4852 |
| Key_read_requests | 420745 |
| Key_reads | 4810 |
| Key_write_requests | 9143 |
| Key_writes | 5666 |
| Max_used_connections | 3 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 64 |
| Open_files | 126 |
| Open_streams | 0 |
| Opened_tables | 956 |
| Questions | 19323 |
| 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 | 19 |
| Select_full_range_join | 0 |
| Select_range | 1350 |
| Select_range_check | 0 |
| Select_scan | 2567 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 2 |
| Sort_merge_passes | 0 |
| Sort_range | 728 |
| Sort_rows | 17036 |
| Sort_scan | 1155 |
| Table_locks_immediate | 17342 |
| Table_locks_waited | 0 |
| Threads_cached | 0 |
| Threads_created | 1817 |
| Threads_connected | 2 |
| Threads_running | 1 |
| Uptime | 78502 |
+--------------------------+-----------+
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
Only other sites using php and mysql are not active yet. photoposts, photoclassifieds, reviewpost planned.
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
cookie timeout is 900, no other stats available yet.
10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
link to phpinfo.php (http://www.thirstyriver.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 :
KeepAlive
MaxKeepAliveRequests
KeepAliveTimeout
MinSpareServers
MaxSpareServers
StartServers
MaxClients
12. what version of vB are you running ?
3.07
13. check to see if any files i.e. apache log files are hitting 2GB or 4GB max file size limits
None listed.
Thank you for this service.
Regards... Al
I've installed and imported a test run of our current UBB Classic forum.
Threads: 83,564, Posts: 559,618, Members: 21,007
Import went fairly well and tests show no problems.
I was just about to dump the test import and do a real one but am concerned about the servers ability to handle the traffic after reading through your "optimization" forum.
Our UBB stats showed 400 online last week with the forum we wish to convert.
I'd hate to do the import and go live only to have refused connections and general mayhem.
---------------------------
1:
Dedicated Server - (although we have about 30 of our own domains on it) one with a forum using about half the traffic of the one being imported - but it's planned to bring it into VBulletin as well.
2:
Single 3.06 cpu, showing as a dual processor
1 gb of Ram
RedHat 7.3
80gb IDE drive
apache (1.3.33 (Unix))
php 4.3.10 - Turck MMCache v2.4.6
mysql (4.0.23-standard)
Zend Optimizer v2.5.7
3. innodb type databases/tables on your server ? Unknown
4. if possible how mysql was compiled/installed - Unknown
5. your top stats
3:39pm up 189 days, 30 min, 1 user, load average: 0.52, 0.56, 0.54
140 processes: 139 sleeping, 1 running, 0 zombie, 0 stopped
CPU0 states: 18.4% user, 3.2% system, 0.0% nice, 77.2% idle
CPU1 states: 18.2% user, 4.3% system, 0.0% nice, 76.3% idle
Mem: 1031236K av, 973964K used, 57272K free, 0K shrd, 156948K buff
Swap: 2096440K av, 75940K used, 2020500K free 364424K cached
This is with the current UBB Classic showing 230 in recent visitors
Second domain using ubb classic on this server shows:120
--------------------------
6. your mysql configuration variables located at /etc/my.cnf
This is all that shows up in /etc/my.cnf
[mysqld]
set-variable = max_connections=500
---------------------------
mysqladmin -u root -p variables?
link to text file (http://www.thirstyriver.com/info.txt)
----
7. your mysql extended-status output
mysqladmin -u root -p extended-status
+--------------------------+-----------+
| Variable_name | Value |
+--------------------------+-----------+
| Aborted_clients | 0 |
| Aborted_connects | 2 |
| Bytes_received | 3249658 |
| Bytes_sent | 396617652 |
| Com_admin_commands | 0 |
| Com_alter_table | 9 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 782 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 2 |
| Com_create_function | 0 |
| Com_create_index | 8 |
| Com_create_table | 10 |
| Com_delete | 943 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 4 |
| Com_grant | 9 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 1235 |
| Com_insert_select | 1 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 1226 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 429 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 9524 |
| Com_set_option | 111 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 1 |
| Com_show_create | 111 |
| Com_show_databases | 3 |
| Com_show_fields | 111 |
| 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 | 263 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 3 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 142 |
| Com_show_variables | 5 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 1226 |
| Com_update | 1199 |
| Connections | 1818 |
| Created_tmp_disk_tables | 7 |
| Created_tmp_tables | 704 |
| Created_tmp_files | 3 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 1349 |
| Handler_read_first | 3049 |
| Handler_read_key | 193243 |
| Handler_read_next | 280301 |
| Handler_read_prev | 656 |
| Handler_read_rnd | 15349 |
| Handler_read_rnd_next | 5587722 |
| Handler_rollback | 0 |
| Handler_update | 65204 |
| Handler_write | 6227 |
| Key_blocks_used | 4852 |
| Key_read_requests | 420745 |
| Key_reads | 4810 |
| Key_write_requests | 9143 |
| Key_writes | 5666 |
| Max_used_connections | 3 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 64 |
| Open_files | 126 |
| Open_streams | 0 |
| Opened_tables | 956 |
| Questions | 19323 |
| 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 | 19 |
| Select_full_range_join | 0 |
| Select_range | 1350 |
| Select_range_check | 0 |
| Select_scan | 2567 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 2 |
| Sort_merge_passes | 0 |
| Sort_range | 728 |
| Sort_rows | 17036 |
| Sort_scan | 1155 |
| Table_locks_immediate | 17342 |
| Table_locks_waited | 0 |
| Threads_cached | 0 |
| Threads_created | 1817 |
| Threads_connected | 2 |
| Threads_running | 1 |
| Uptime | 78502 |
+--------------------------+-----------+
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
Only other sites using php and mysql are not active yet. photoposts, photoclassifieds, reviewpost planned.
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
cookie timeout is 900, no other stats available yet.
10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
link to phpinfo.php (http://www.thirstyriver.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 :
KeepAlive
MaxKeepAliveRequests
KeepAliveTimeout
MinSpareServers
MaxSpareServers
StartServers
MaxClients
12. what version of vB are you running ?
3.07
13. check to see if any files i.e. apache log files are hitting 2GB or 4GB max file size limits
None listed.
Thank you for this service.
Regards... Al