Configuration ... 2 server set up

[toastyalbus]

Thanks! Brand new two server set up, needs config. :)

APACHE SERVER:
1. Dedicated
2.
1 Dell \ 1600SC Dual Xeon MB \ DAT54AMB8C2
2 Intel \ 2.4 GHz \ P4 Xeon
1 Transcend \ 2GB \ DDR266 ECC Registered
1 3Ware \ 2 channel SATA RAID \ Escalade 8006-2LP
3. Don't know
4. rpm
5.
10:46:06 up 12:07, 1 user, load average: 1.21, 1.20, 1.18
239 processes: 235 sleeping, 4 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 28.9% 0.0% 2.1% 0.1% 0.5% 0.0% 68.2%
cpu00 35.8% 0.0% 2.2% 0.4% 0.8% 0.0% 60.5%
cpu01 34.5% 0.0% 1.7% 0.0% 0.0% 0.0% 63.6%
cpu02 17.4% 0.0% 0.8% 0.0% 0.0% 0.0% 81.6%
cpu03 27.8% 0.0% 3.5% 0.0% 1.3% 0.0% 67.2%
Mem: 2055376k av, 2011392k used, 43984k free, 0k shrd, 176120k buff
959180k actv, 568200k in_d, 31528k in_c
Swap: 2040244k av, 0k used, 2040244k free 902672k cached
6. [mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
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 = 1500
thread_cache_size = 384
wait_timeout = 180
connect_timeout = 10
tmp_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 128M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384
[mysql.server]
user=mysql
basedir=/var/lib
[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
7.
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 8 |
| Aborted_connects | 3 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 7598360 |
| Bytes_sent | 1216929864 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 4554 |
| Com_change_db | 2304 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 4554 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 112 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 115 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 1 |
| Com_optimize | 0 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 3 |
| Com_replace_select | 1 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 19381 |
| Com_set_option | 1 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 1 |
| Com_show_create_table | 0 |
| Com_show_databases | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 1 |
| Com_show_variables | 0 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 5719 |
| Com_update_multi | 0 |
| Connections | 2483 |
| Created_tmp_disk_tables | 652 |
| Created_tmp_files | 0 |
| Created_tmp_tables | 1436 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 104 |
| Handler_discover | 0 |
| Handler_read_first | 665 |
| Handler_read_key | 23450 |
| Handler_read_next | 19059 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 49089 |
| Handler_read_rnd_next | 7156178 |
| Handler_rollback | 0 |
| Handler_update | 6603 |
| Handler_write | 41762 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 14351 |
| Key_blocks_used | 149 |
| Key_read_requests | 107025 |
| Key_reads | 969 |
| Key_write_requests | 25424 |
| Key_writes | 967 |
| Max_used_connections | 4 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 123 |
| Open_streams | 0 |
| Open_tables | 64 |
| Opened_tables | 70 |
| Qcache_free_blocks | 209 |
| Qcache_free_memory | 131542296 |
| Qcache_hits | 39255 |
| Qcache_inserts | 19358 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 25 |
| Qcache_queries_in_cache | 1153 |
| Qcache_total_blocks | 2589 |
| Questions | 78479 |
| Rpl_status | NULL |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 46 |
| Select_range_check | 0 |
| Select_scan | 13984 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 23 |
| Sort_rows | 49344 |
| Sort_scan | 8058 |
| Table_locks_immediate | 26228 |
| Table_locks_waited | 0 |
| Threads_cached | 3 |
| Threads_connected | 1 |
| Threads_created | 4 |
| Threads_running | 1 |
| Uptime | 43687 |
+----------------------------+------------+
8. VB is the only thing on the server.
9. Cookie timeout is 15.
10. http://www.archerytalk.com/phpinfo.php
11.
KeepAlive On
MaxKeepAliveRequests 500
KeepAliveTimeout 5
MinSpareServers 32
MaxSpareServers 64
StartServers 5
MaxClients 256
MaxRequestsPerChild 0
12. 3.5.3
13. None

[toastyalbus]

MYSQL SERVER:
1. Dedicated
2.
2 Intel \ 2.8 GHz 533FSB \ P4 Xeon
1 Hynix \ DDR 266 ECC \ 2GB
1 Dell \ RAID:2 \ PERC - TC 1600SC
2 Fujitsu \ 73GB:SCSI:Ultra320 TotalControl \ map3735nc
1 Dell \ DRAC \ III
1 Dell \ 1600SC Dual Xeon MB \ DAT54AMB8C2
3. Don't know
4. rpm
5.
13:14:27 up 22:02, 1 user, load average: 0.13, 0.13, 0.09
362 processes: 361 sleeping, 1 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 2.8% 0.0% 2.1% 0.0% 0.9% 6.0% 87.9%
cpu00 1.9% 0.0% 0.9% 0.0% 1.9% 11.5% 83.6%
cpu01 2.8% 0.0% 1.9% 0.0% 0.9% 10.5% 83.6%
cpu02 6.7% 0.0% 3.8% 0.0% 0.0% 0.9% 88.3%
cpu03 0.0% 0.0% 1.9% 0.0% 0.9% 0.9% 96.1%
Mem: 2055376k av, 2031516k used, 23860k free, 0k shrd, 14476k buff
1528840k actv, 289660k in_d, 31564k in_c
Swap: 2040244k av, 0k used, 2040244k free 1703172k cached
6.
[mysqld]
default-character-set = latin1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords
back_log = 75
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 = 384
wait_timeout = 180
connect_timeout = 10
tmp_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
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
7.
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 274 |
| Aborted_connects | 23 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 1292298040 |
| Bytes_sent | 3336182108 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 11 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 1 |
| Com_change_db | 440591 |
| Com_change_master | 0 |
| Com_check | 94 |
| Com_checksum | 0 |
| Com_commit | 1 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 1072 |
| Com_dealloc_sql | 0 |
| Com_delete | 15451 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 171686 |
| Com_insert_select | 672 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 94 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 16219 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 1 |
| Com_savepoint | 0 |
| Com_select | 1317842 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 0 |
| Com_show_databases | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 1 |
| Com_show_variables | 21 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 1072 |
| Com_unlock_tables | 0 |
| Com_update | 359578 |
| Com_update_multi | 0 |
| Connections | 440496 |
| Created_tmp_disk_tables | 5017 |
| Created_tmp_files | 1248 |
| Created_tmp_tables | 41217 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 59720 |
| Handler_discover | 0 |
| Handler_read_first | 348101 |
| Handler_read_key | 82672004 |
| Handler_read_next | 257978018 |
| Handler_read_prev | 4162738 |
| Handler_read_rnd | 12255806 |
| Handler_read_rnd_next | 143727499 |
| Handler_rollback | 0 |
| Handler_update | 429848 |
| Handler_write | 12299112 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 0 |
| Key_blocks_used | 14497 |
| Key_read_requests | 316442459 |
| Key_reads | 7372661 |
| Key_write_requests | 567741 |
| Key_writes | 332048 |
| Max_used_connections | 285 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 278 |
| Open_streams | 0 |
| Open_tables | 317 |
| Opened_tables | 3182 |
| Qcache_free_blocks | 4708 |
| Qcache_free_memory | 35030816 |
| Qcache_hits | 1575685 |
| Qcache_inserts | 1305033 |
| Qcache_lowmem_prunes | 7984 |
| Qcache_not_cached | 11941 |
| Qcache_queries_in_cache | 8733 |
| Qcache_total_blocks | 22929 |
| Questions | 4340782 |
| Rpl_status | NULL |
| Select_full_join | 1557 |
| Select_full_range_join | 9 |
| Select_range | 373084 |
| Select_range_check | 0 |
| Select_scan | 159496 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 1007 |
| Sort_merge_passes | 1547 |
| Sort_range | 222274 |
| Sort_rows | 56708352 |
| Sort_scan | 97764 |
| Table_locks_immediate | 3518047 |
| Table_locks_waited | 44202 |
| Threads_cached | 281 |
| Threads_connected | 4 |
| Threads_created | 285 |
| Threads_running | 1 |
| Uptime | 69116 |
+----------------------------+------------+
8. Just the mysql server
9. 15 minute cookie.
10. http://70.87.98.194/index.php
11.
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 5
StartServers 20
MaxClients 150
Maxrequestsperchild value 1000
12. 3.5.3
13. Nope

[eva2000]

mysql server looks fine maybe just in my.cnf increase

query_cache_size = 64M

to

query_cache_size = 96M

restart mysql

as to web server do you really need to compile all those options in php and load all those apache modules ?

[toastyalbus]

I suppose not - it's just running vbulletin with and 1 index page. What do you suggest removing or turning off, etc.

[eva2000]

something like http://www.sportscardforum.com/phpinfo.php would be basic of course paths to certain items would be different for you

[toastyalbus]

Growth is killing us already. It's been less than a month. *sigh*

Working with our server company, we were advised to change maxclients to 400 and set serverlimit to 400 - also, to set the php memory_limit to 64mb. This is resulting in DB errors to this effect:

Database error in vBulletin :

mysql_connect(): Can't connect to MySQL server on '70.87.98.194' (4)
/home/httpd/vhosts/archerytalk.com/httpdocs/vb/includes/class_core.php on line 279

MySQL Error :
Error Number :
Date : Wednesday, February 15th 2006 @ 06:13:08 PM
Script : http://www.archerytalk.com/vb/attachment.php?attachmentid=89811&stc=1&d=1122916129 (http://mail2web.com/cgi-bin/redir.asp?lid=0&newsite=http://www.archerytalk.com/vb/attachment.php?attachmentid=89811&stc=1&d=1122916129)
Referrer : http://www.archerytalk.com/vb/showthread.php?t=210724 (http://mail2web.com/cgi-bin/redir.asp?lid=0&newsite=http://www.archerytalk.com/vb/showthread.php?t=210724)
IP Address : 198.77.40.99
Username :
Classname : vb_database

What is going on? What do I even do anymore?

At any given time there over 300 apache services running. My clientle is getting really tired of their favorite website not working, and we can't seem to get this straight.

Do you have any advice? The above information is all accurate still (I changed settings back to match this sheet). Please help!

[eva2000]

i need up to date stats on mysql and your servers... i revised the questions needed answering at http://www.vbulletin.com/forum/showthread.php?t=70117 including mysqlreport script output - very useful to know for mysql server tuning.

Can you repost the most upto date info asked at http://www.vbulletin.com/forum/showthread.php?t=70117

[toastyalbus]

Alright, here we go.

Web Server

1. Dedicated
2. 1Dell \ 1600SC Dual Xeon MB \ DAT54AMB8C22Intel \ 2.4 GHz \ P4 Xeon1Transcend \ 2GB \ DDR266 ECC Registered13Ware \ 2 channel SATA RAID \ Escalade 8006-2LP2Maxtor \ 200GB:SATA:7200RPM \ 200gb sata

3. No
4. Redhat
5. 14:32:10 up 19:47, 1 user, load average: 2.44, 2.31, 2.71
299 processes: 295 sleeping, 1 running, 0 zombie, 3 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 1.4% 0.0% 0.7% 0.0% 0.0% 0.0% 97.8%
cpu00 1.9% 0.0% 0.0% 0.0% 0.0% 0.0% 98.0%
cpu01 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 100.0%
cpu02 0.9% 0.0% 2.8% 0.0% 0.0% 0.0% 96.1%
cpu03 2.9% 0.0% 0.0% 0.0% 0.0% 0.0% 97.0%
Mem: 2055376k av, 1533948k used, 521428k free, 0k shrd, 42776k buff
1144784k actv, 184496k in_d, 24576k in_c
Swap: 2040244k av, 108264k used, 1931980k free 360484k cached


6. See mysql server
7. See mysql server
8. Yes
9. Cookie 15. Concurrent users seems to average around 300. Max is 320.
10. http://www.archerytalk.com/phpinfo.php
11. ServerLimit 350
StartServers 5
MinSpareServers 32
MaxSpareServers 64
MaxClients 350
MaxRequestsPerChild 0

StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0


12. 3.5.3
13. No

[toastyalbus]

And

MySQL server

1. Dedicated
2. 2Intel \ 2.8 GHz 533FSB \ P4 Xeon1Hynix \ DDR 266 ECC \ 2GB1Dell \ RAID:2 \ PERC - TC 1600SC2Fujitsu \ 73GB:SCSI:Ultra320 TotalControl \ map3735nc1Dell \ DRAC \ III1Dell \ 1600SC Dual Xeon MB \ DAT54AMB8C2
3. No
4. Redhat
5. 16:56:13 up 19:09, 1 user, load average: 0.09, 0.06, 0.05
411 processes: 390 sleeping, 1 running, 0 zombie, 20 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 8.8% 0.0% 6.1% 0.0% 0.0% 2.6% 82.3%
cpu00 35.2% 0.0% 20.9% 0.0% 0.0% 5.7% 38.0%
cpu01 0.0% 0.0% 3.8% 0.0% 0.0% 4.7% 91.4%
cpu02 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 100.0%
cpu03 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 100.0%
Mem: 2055376k av, 2017520k used, 37856k free, 0k shrd, 15820k buff
1527700k actv, 294308k in_d, 30664k in_c
Swap: 2040244k av, 0k used, 2040244k free 1817524k cached

6. [mysqld]
default-character-set = latin1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords
back_log = 75
skip-innodb
max_connections = 4000
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 = 384
wait_timeout = 180
connect_timeout = 10
tmp_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
thread_concurrency = 4
query_cache_limit = 1M
query_cache_size = 96M
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

7. +---------------------------------+------------------------------------------+
| Variable_name | Value |
+---------------------------------+------------------------------------------+
| back_log | 75 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 10 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | YES |
| have_bdb | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | DISABLED |
| have_isam | NO |
| have_ndbcluster | NO |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| 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_open_files | 300 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 28800 |
| join_buffer_size | 1044480 |
| key_buffer_size | 16777216 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| 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 | 10 |
| max_connections | 4000 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 18446744073709551615 |
| max_length_for_sort_data | 1024 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_length_for_sort_data | 1024 |
| 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_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 67108864 |
| myisam_stats_method | nulls_unequal |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | ON |
| open_files_limit | 20010 |
| pid_file | /var/lib/mysql/archerytalk.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| protocol_version | 10 |
| query_alloc_block_size | 16384 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 100663296 |
| 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 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 0 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slave_transaction_retries | 0 |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | ON |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| system_time_zone | CST |
| table_cache | 1800 |
| table_type | MyISAM |
| thread_cache_size | 384 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 67108864 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.16-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 180 |
+---------------------------------+------------------------------------------+
+----------------------------+-----------+
| Variable_name | Value |
+----------------------------+-----------+
| Aborted_clients | 8 |
| Aborted_connects | 630 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 7351709 |
| Bytes_sent | 408985335 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 1992 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 10 |
| Com_dealloc_sql | 0 |
| Com_delete | 80 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 870 |
| Com_insert_select | 3 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 170 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 8189 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 0 |
| Com_show_databases | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 4 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 0 |
| Com_show_variables | 8 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 10 |
| Com_unlock_tables | 0 |
| Com_update | 1835 |
| Com_update_multi | 0 |
| Connections | 2685 |
| Created_tmp_disk_tables | 35 |
| Created_tmp_files | 8 |
| Created_tmp_tables | 450 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 140 |
| Handler_discover | 0 |
| Handler_read_first | 1775 |
| Handler_read_key | 1656751 |
| Handler_read_next | 3602967 |
| Handler_read_prev | 14042 |
| Handler_read_rnd | 105007 |
| Handler_read_rnd_next | 468381 |
| Handler_rollback | 0 |
| Handler_update | 1966 |
| Handler_write | 73861 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 0 |
| Key_blocks_used | 14497 |
| Key_read_requests | 6430693 |
| Key_reads | 80617 |
| Key_write_requests | 1251 |
| Key_writes | 919 |
| Max_used_connections | 338 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 262 |
| Open_streams | 0 |
| Open_tables | 208 |
| Opened_tables | 224 |
| Qcache_free_blocks | 379 |
| Qcache_free_memory | 90477360 |
| Qcache_hits | 7693 |
| Qcache_inserts | 8007 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 182 |
| Qcache_queries_in_cache | 831 |
| Qcache_total_blocks | 2269 |
| Questions | 22854 |
| Rpl_status | NULL |
| Select_full_join | 13 |
| Select_full_range_join | 0 |
| Select_range | 2486 |
| Select_range_check | 0 |
| Select_scan | 1618 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 4 |
| Sort_range | 947 |
| Sort_rows | 231855 |
| Sort_scan | 1198 |
| Table_locks_immediate | 19466 |
| Table_locks_waited | 211 |
| Threads_cached | 278 |
| Threads_connected | 60 |
| Threads_created | 338 |
| Threads_running | 1 |
| Uptime | 721 |
+----------------------------+-----------+
Uptime: 721 Threads: 60 Questions: 22855 Slow queries: 0 Opens: 224 Flush tables: 1 Open tables: 208 Queries per second avg: 31.699
mysqladmin Ver 8.41 Distrib 4.1.16, 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.1.16-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 12 min 1 sec
Threads: 60 Questions: 22855 Slow queries: 0 Opens: 224 Flush tables: 1 Open tables: 208 Queries per second avg: 31.699

8. Yes. See web server.
9. See web server.
10. http://70.87.98.194/index.php
11. See web server.
12. 3.5.3
13. None

[toastyalbus]

The rest of the situation. It's slow - and when it does connect, we get MySQL errors (cannot connect). I upped the connects on the mysql to 4000 in the hopes that that would alleviate any problems with running out of connection room. It behaves the same with max_connections set between 1200-4000. :(

Watching top, the mysql processes never seem to leave the list and their size just collectively grows, yet all have a time of 0.

What's going on? Will you also please explain any changes you suggest?

If we follow your configs and it's still slow, what should we be looking at to fix it. ddos attacks? new servers? monkeys with calculators?

Thank you. :)

[eva2000]

That's how mysql works - grows in size over time :)

You're web host was incorrect, max_connections don't need to be that high and maxclients in httpd.conf doesn't need to be that high unless your apache error log suggest maxclients exceeded at lower values ?

If you can post the output from mysqlreport script http://www.vbulletin.com/forum/showthread.php?t=175177 before doing below changes it would help :)

1. Upgrade MySQL server to 4.1.18 http://www.vbulletin.com/forum/showthread.php?t=175163
2. Upgrade PHP to 4.4.2 if you use phpadsnew make sure to update to phpadsnew 2.0.7 to work with PHP 4.4.1/4.4.2
3. Edit /etc/my.cnf and place the following mysql server settings in /etc/my.cnf and restart mysql server afterwards


[mysqld]
default-character-set = latin1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords
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 = 384
wait_timeout = 180
connect_timeout = 10
tmp_table_size = 256M
max_heap_table_size = 128M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 16M
thread_concurrency = 4
query_cache_limit = 8M
query_cache_size = 80M
query_cache_type = 1
query_prealloc_size = 65536
query_alloc_block_size = 32768
default-storage-engine = MyISAM

[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


4. Install APC Cache lastest version from http://pecl.php.net/package/APC. Read install guide at http://www.vbulletin.com/forum/showthread.php?t=165367

5. If you just upgraded to vB 3.5.x try to disable these 4 options:

Admin CP -> vBulletin Options -> Forums Home Page Options -> Display Logged in Users?

Admin CP -> vBulletin Options -> Forum Display Options (forumdisplay) -> Show Users Browsing Forums

Admin CP -> vBulletin Options -> Thread Display Options -> Show Users Browsing Thread

Admin CP -> vBulletin Options -> Message Searching Options -> Automatic Similar Thread search

6. Edit httpd.conf value for this

ServerLimit 350
StartServers 5
MinSpareServers 32
MaxSpareServers 64
MaxClients 350
MaxRequestsPerChild 0

to

ServerLimit 350
StartServers 10
MinSpareServers 10
MaxSpareServers 15
MaxClients 200
MaxRequestsPerChild 10000

restart apache

[toastyalbus]

The system is operating worse that it has ever before.

First, and sadly, I cannot get mysql report installed. I had perl installed on our mysql server, but it is missing some libraries that mysqlreport needs. I am going to repost the info you always ask for.

Please say there is someone to help with this. We don't know what to do anymore, and we've configured this so many times without success. I 've worked with the server company to try to figure out any cross server latency, and if there is any, it's minimal. There appear to be no signs of malicious use. We can't figure this out.

Thanks.

Web Server

1. Dedicated
2. 1Dell \ 1600SC Dual Xeon MB \ DAT54AMB8C22Intel \ 2.4 GHz \ P4 Xeon1Transcend \ 2GB \ DDR266 ECC Registered13Ware \ 2 channel SATA RAID \ Escalade 8006-2LP2Maxtor \ 200GB:SATA:7200RPM \ 200gb sata

3. No
4. Redhat
5.

17:34:22 up 1:27, 1 user, load average: 1.11, 0.29, 0.25
391 processes: 386 sleeping, 1 running, 0 zombie, 4 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 0.7% 0.0% 0.4% 0.0% 0.0% 0.4% 98.3%
cpu00 0.0% 0.0% 0.0% 0.0% 0.0% 0.9% 99.0%
cpu01 1.9% 0.0% 1.9% 0.0% 0.0% 0.9% 95.1%
cpu02 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 100.0%
cpu03 0.9% 0.0% 0.0% 0.0% 0.0% 0.0% 99.0%
Mem: 2055376k av, 959848k used, 1095528k free, 0k shrd, 64648k buff
649428k active, 120836k inactive
Swap: 2040244k av, 8236k used, 2032008k free 394484k cached

6. See mysql server
7. See mysql server
8. Yes
9. Cookie 15. Concurrent users seems to average around 300. Max is 320.
10. http://www.archerytalk.com/phpinfo.php
11.

<IfModule prefork.c>
ServerLimit 350
StartServers 10
MinSpareServers 10
MaxSpareServers 15
MaxClients 250
MaxRequestsPerChild 10000
</IfModule>
12. 3.5.3
13. No

[/code]

[toastyalbus]

MySQL server

1. Dedicated
2. 2Intel \ 2.8 GHz 533FSB \ P4 Xeon1Hynix \ DDR 266 ECC \ 2GB1Dell \ RAID:2 \ PERC - TC 1600SC2Fujitsu \ 73GB:SCSI:Ultra320 TotalControl \ map3735nc1Dell \ DRAC \ III1Dell \ 1600SC Dual Xeon MB \ DAT54AMB8C2
3. No
4. Redhat
5.



CPU states: cpu user nice system irq softirq iowait idle
total 0.0% 0.0% 0.0% 0.0% 0.0% 0.2% 99.6%
cpu00 0.0% 0.0% 0.2% 0.0% 0.0% 0.5% 99.1%
cpu01 0.0% 0.0% 0.0% 0.0% 0.0% 0.5% 99.4%
cpu02 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 100.0%
cpu03 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 100.0%
Mem: 2055376k av, 1477232k used, 578144k free, 0k shrd, 15324k buff
828816k active, 447152k inactive
Swap: 2040244k av, 0k used, 2040244k free 1309240k cached


6.

[mysqld]
default-character-set = latin1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords
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 = 384
wait_timeout = 180
connect_timeout = 10
tmp_table_size = 256M
max_heap_table_size = 128M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 16M
thread_concurrency = 4
query_cache_limit = 8M
query_cache_size = 80M
query_cache_type = 1
query_prealloc_size = 65536
query_alloc_block_size = 32768
default-storage-engine = MyISAM
[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



Server version 4.1.18-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 13 min 24 sec
Threads: 120 Questions: 1396 Slow queries: 0 Opens: 97 Flush tables: 1 Open tables: 91 Queries per second avg: 1.736
[root@archerytalk /]# mysqladmin -u root -p var ext stat ver
Enter password:
+---------------------------------+------------------------------------------+
| Variable_name | Value |
+---------------------------------+------------------------------------------+
| back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 16777216 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 10 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | NO |
| have_bdb | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | DISABLED |
| have_isam | NO |
| have_ndbcluster | NO |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| 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_open_files | 300 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 28800 |
| join_buffer_size | 1044480 |
| key_buffer_size | 16777216 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| 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_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 67108864 |
| myisam_stats_method | nulls_unequal |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | ON |
| open_files_limit | 4260 |
| pid_file | /var/lib/mysql/archerytalk.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| protocol_version | 10 |
| query_alloc_block_size | 32768 |
| query_cache_limit | 8388608 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 83886080 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 65536 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 520192 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 0 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slave_transaction_retries | 0 |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | ON |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| system_time_zone | CST |
| table_cache | 1800 |
| table_type | MyISAM |
| thread_cache_size | 384 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 268435456 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.18-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 180 |
+---------------------------------+------------------------------------------+
+----------------------------+----------+
| Variable_name | Value |
+----------------------------+----------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 10201 |
| Bytes_sent | 468099 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 2 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 0 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 2 |
| 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_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 0 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 21 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 0 |
| Com_show_databases | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 0 |
| Com_show_variables | 1 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 2 |
| Com_update_multi | 0 |
| Connections | 4 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_files | 0 |
| Created_tmp_tables | 0 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 0 |
| Handler_discover | 0 |
| Handler_read_first | 8 |
| Handler_read_key | 323 |
| Handler_read_next | 7424 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 0 |
| Handler_read_rnd_next | 120 |
| Handler_rollback | 0 |
| Handler_update | 2 |
| Handler_write | 2 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 14270 |
| Key_blocks_used | 227 |
| Key_read_requests | 1975 |
| Key_reads | 227 |
| Key_write_requests | 0 |
| Key_writes | 0 |
| Max_used_connections | 1 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 42 |
| Open_streams | 0 |
| Open_tables | 22 |
| Opened_tables | 28 |
| Qcache_free_blocks | 4 |
| Qcache_free_memory | 83505096 |
| Qcache_hits | 2 |
| Qcache_inserts | 21 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_queries_in_cache | 12 |
| Qcache_total_blocks | 39 |
| Questions | 33 |
| Rpl_status | NULL |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 10 |
| Select_range_check | 0 |
| Select_scan | 4 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 2 |
| Sort_rows | 71 |
| Sort_scan | 2 |
| Table_locks_immediate | 51 |
| Table_locks_waited | 0 |
| Threads_cached | 0 |
| Threads_connected | 1 |
| Threads_created | 1 |
| Threads_running | 1 |
| Uptime | 24 |
+----------------------------+----------+
Uptime: 25 Threads: 1 Questions: 34 Slow queries: 0 Opens: 28 Flush tables: 1 Open tables: 22 Queries per second avg: 1.360
mysqladmin Ver 8.41 Distrib 4.1.18, 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.1.18-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 25 sec



8. Yes. See web server.
9. See web server.
10. http://70.87.98.194/index.php
11. See web server.
12. 3.5.3
13. None

[eva2000]

can you explain worse more specifically ? what are the problems ? load issues on web server ? notice you have 3ware controllers on your server, some are know to have driver compatibility issues etc, has your web host looked into such hardware yet ?

mysqladmin status output had only 24 seconds uptime no where long enough to be indicative of your server's stats for me to guage your loads - need to wait for mysql longer run time and retype output from

mysqladmin -u root -p var ext stat

[toastyalbus]

Worse means that it is CONSTANTLY slow now, ther eis not a moment, no matter the amount of users, in which it is taking 5 minutes or more to load each page. If I shut of the vb and move it's directory so that no one can hit it, it's STILL SLOW. This is basically going to lose our entire user body that we've worked on for 4 years.

We're going back to a 1 server config today to buy time but that will buy us a week, if it even works. What is possibly up here?


mysqladmin -u root -p var ext stat
Enter password:
+---------------------------------+------------------------------------------+
| Variable_name | Value |
+---------------------------------+------------------------------------------+
| back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 16777216 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 10 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | NO |
| have_bdb | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | DISABLED |
| have_isam | NO |
| have_ndbcluster | NO |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| 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_open_files | 300 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 28800 |
| join_buffer_size | 1044480 |
| key_buffer_size | 16777216 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| 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 | 10 |
| max_connections | 650 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 134216704 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| max_length_for_sort_data | 1024 |
| 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_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 67108864 |
| myisam_stats_method | nulls_unequal |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | ON |
| open_files_limit | 4260 |
| pid_file | /var/lib/mysql/archerytalk.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| protocol_version | 10 |
| query_alloc_block_size | 32768 |
| query_cache_limit | 8388608 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 83886080 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 65536 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 520192 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 0 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slave_transaction_retries | 0 |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | ON |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| system_time_zone | CST |
| table_cache | 1800 |
| table_type | MyISAM |
| thread_cache_size | 384 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 268435456 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.18-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 180 |
+---------------------------------+------------------------------------------+
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 60 |
| Aborted_connects | 28 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 268017266 |
| Bytes_sent | 2515849419 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 77677 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 2560 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 36689 |
| Com_insert_select | 44 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 5112 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 270242 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 0 |
| Com_show_databases | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 22 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 0 |
| Com_show_variables | 11 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 63092 |
| Com_update_multi | 0 |
| Connections | 77903 |
| Created_tmp_disk_tables | 818 |
| Created_tmp_files | 337 |
| Created_tmp_tables | 17696 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 21418 |
| Handler_discover | 0 |
| Handler_read_first | 64643 |
| Handler_read_key | 37839800 |
| Handler_read_next | 60425783 |
| Handler_read_prev | 709013 |
| Handler_read_rnd | 6394616 |
| Handler_read_rnd_next | 73657264 |
| Handler_rollback | 0 |
| Handler_update | 77001 |
| Handler_write | 6109936 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 0 |
| Key_blocks_used | 14497 |
| Key_read_requests | 139348393 |
| Key_reads | 1333601 |
| Key_write_requests | 41951 |
| Key_writes | 35482 |
| Max_used_connections | 241 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 342 |
| Open_streams | 0 |
| Open_tables | 300 |
| Opened_tables | 306 |
| Qcache_free_blocks | 1883 |
| Qcache_free_memory | 47751752 |
| Qcache_hits | 326134 |
| Qcache_inserts | 266975 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 3176 |
| Qcache_queries_in_cache | 6055 |
| Qcache_total_blocks | 14783 |
| Questions | 859220 |
| Rpl_status | NULL |
| Select_full_join | 303 |
| Select_full_range_join | 4 |
| Select_range | 75323 |
| Select_range_check | 0 |
| Select_scan | 65556 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 3 |
| Sort_merge_passes | 186 |
| Sort_range | 33360 |
| Sort_rows | 13845809 |
| Sort_scan | 41378 |
| Table_locks_immediate | 685701 |
| Table_locks_waited | 3811 |
| Threads_cached | 36 |
| Threads_connected | 205 |
| Threads_created | 241 |
| Threads_running | 1 |
| Uptime | 54665 |
+----------------------------+------------+
Uptime: 54665 Threads: 205 Questions: 859221 Slow queries: 3 Opens: 306 Flush tables: 1 Open tables: 300 Queries per second avg: 15.718

[Zachery]

Going back to one server could possibly be worse.

Two servers should be faster overall :/

Are you sure that there is not a conneciton issue ?

The load on your servers apear to be mininal at best, can you repost them as they are now? (top stats)

[toastyalbus]

The top load stats are not available - we are moving back to one server. The top stats were always less than .5. I cannot get our hosting company to even consider that the three hops between server is an issue, or that there might be some hardware problems. At the least, this will buy us time until we have a new host with two servers that can be connected.

[Zachery]

I'm going to have to say this had to be a connection issue problem, if the loads on the servers were always under 1, something else was an issue, I would highly suggest looking into a new host.

[toastyalbus]

I think I have to agree with you.

Do you have any recommendations? If not a host, then of exactly what we need to set up to keep us safe for a while? We need, clearly, to have a good connection between the two servers. What else?

Mike

[Zachery]

Servers should be cross connected directly, what was the old machine you were on? What were the new machines?

What sort of trafic do you get? How many online and the cookie timeout?

[toastyalbus]

All of the info you asked is in the above in more specifics. I'm sorry to be brief.

The web server, which is the machine that seems to be fine, we've had for about a year. The sql server we've had for about a month. I wrote another email to the host asking why one server can connect to it's gate way in less than a ms, and the sql server takes about 20ms to ping. So, given the amount of packets, that would seem to be the issue.


Before these last two weeks we were averaging over 700 users at peak hours with a 15 minute cookie timeout. We anticipated heavy growth to 2007 (upwards of a 1000). Thank you for your speedy responses.

[toastyalbus]

Back on 1 server, with 800 users, zipping along. It is at the breaking point, but will get us by until we get a suitable host. There is a hardware issue involved. If you have any recommendations of hosts, they would be apprecaited.

Thankyou.

[Zachery]

I've personally had decent expirences with theplanet.com and some of thier servers, recently I've been hearing good things about liquidweb.

[toastyalbus]

Thanks for your response. I'll check out liquidweb. Theplanet is the company with whom we are having the troubles.

[Zachery]

I've had mixed luck with theplanet, cross connecting servers is usally easy as long as you order them at the same time.

[eva2000]

Back on 1 server, with 800 users, zipping along. It is at the breaking point, but will get us by until we get a suitable host. There is a hardware issue involved. If you have any recommendations of hosts, they would be apprecaited.

Thankyou.
definitely something up with your old server config then!

what was the hardware issue ?