I am VERY desperate - please help!

[Susanweb1]

Hey guys, I have a question. I host a large forum site that gets a lot of traffic and posts. The vBulletin is constantly going down. Now my tech support hosting people say it is the software - they didn't recommend vBulletin because it is buggy and a HUGE resource hog, which will cause the CONSTANT downtime.

Now, the site I have is on 2 dedicated servers. One to host the site and the forum, the other to host the database.

Does anyone know if there should be a problem with a large forum site to use Vbulletin due to the resource issues and/or bugs...or does this sound like a database/mySQL/server issue?

The forum is down right now as a matter of fact, and here is an error:

------------------------------------------------

Warning: Host is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /usr/home/public_html/board/admin/db_mysql.php on line 40

Warning: MySQL Connection Failed: Host is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /usr/home/public_html/board/admin/db_mysql.php on line 40

------------------------------------------------



Any idea's? I am desperate. I spend a fortune on hosting this forum, and it is getting worse.

Thanks!
~Susan

[filburt1]

What's your URL? On a dedicated server vBulletin can easily handle a huge number of users online at once, but on a shared acccount it can be killed pretty quickly. And shoot them for saying vB is buggy. ;)

[Susanweb1]

It's an adult forum, so I would rather not say the URL, but it is not a on a shared server, in fact, it is on two dedicated servers. Just this one site.

~Susan

[eva2000]

Originally posted by Susanweb1
Hey guys, I have a question. I host a large forum site that gets a lot of traffic and posts. The vBulletin is constantly going down. Now my tech support hosting people say it is the software - they didn't recommend vBulletin because it is buggy and a HUGE resource hog, which will cause the CONSTANT downtime.

Now, the site I have is on 2 dedicated servers. One to host the site and the forum, the other to host the database.

Does anyone know if there should be a problem with a large forum site to use Vbulletin due to the resource issues and/or bugs...or does this sound like a database/mySQL/server issue?

The forum is down right now as a matter of fact, and here is an error:

------------------------------------------------

Warning: Host is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /usr/home/public_html/board/admin/db_mysql.php on line 40

Warning: MySQL Connection Failed: Host is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /usr/home/public_html/board/admin/db_mysql.php on line 40

------------------------------------------------



Any idea's? I am desperate. I spend a fortune on hosting this forum, and it is getting worse.

Thanks!
~Susan looks like you might have some TCP/IP connection problems between your web server and mysql database server

mysql defaults to 10 max_connect_errors or failed requests from your host hostname before blocking the site from connecting to your mysql database until you execute the command

mysqladmin flush-hosts

how are connecting your web and database servers ?

it seems your web host has not optimally setup and configured your servers and mysql

you can try in your database server's /etc/my.cnf file add under

[mysqld] section add

set-variable = max_connect_errors=5000
and restart mysql

max_connect_errors
If there is more than this number of interrupted connections from a host this host will be blocked from further connections. You can unblock a host with the command FLUSH HOSTS.

[Susanweb1]

Ok, here is what my host replied with as far as the stats on the server and MYSQL. Please let me know if anything could be the problem with this setup.

-----------

The machine is a Dual 1GHz Machine, Ultra160SCSI, RUNNING ONLY MYSQL,
with
2GB of ram.

Running MySQL with this config:
cd /usr/local/mysql; ./bin/safe_mysqld -O key_buffer=384M -O
max_connections=3000 -O myisam_sort_buffer_size=64M -O
max_allowed_packet=1M -O max_connect_errors=200 -O table_cache=512 -O
sort_buffer=2M -O record_buffer=2M -O connect_timeout=60 -O
thread_cache=8 -O thread_concurrency=12 -O tmp_table_size=50M -O
wait_timeout=500 --big-tables --user=mysql &

And here are the MySQL stats:
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 2659 |
| Aborted_connects | 1 |
| Bytes_received | 3518033967 |
| Bytes_sent | 3444674488 |
| Connections | 1134650 |
| Created_tmp_disk_tables | 248489 |
| Created_tmp_tables | 248489 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 85094 |
| Handler_read_first | 2877292 |
| Handler_read_key | 122598739 |
| Handler_read_next | 444528289 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 128490719 |
| Handler_read_rnd_next | 172686899 |
| Handler_update | 1650174 |
| Handler_write | 1551919 |
| Key_blocks_used | 375048 |
| Key_read_requests | 572022638 |
| Key_reads | 3150574 |
| Key_write_requests | 443265 |
| Key_writes | 37824 |
| Max_used_connections | 418 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 85 |
| Open_files | 151 |
| Open_streams | 0 |
| Opened_tables | 122347 |
| Questions | 21094071 |
| Select_full_join | 4038 |
| Select_full_range_join | 8 |
| Select_range | 2222607 |
| Select_range_check | 0 |
| Select_scan | 2524028 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 18593 |
| Sort_merge_passes | 0 |
| Sort_range | 2356234 |
| Sort_rows | 129859264 |
| Sort_scan | 1498598 |
| Table_locks_immediate | 22946076 |
| Table_locks_waited | 4927 |
| Threads_cached | 6 |
| Threads_created | 47414 |
| Threads_connected | 5 |
| Threads_running | 1 |
| Uptime | 642433 |
+--------------------------+------------+

[eva2000]

you mysql settings are set too high causing part of the problem

my suggestion is

1. stop and restart mysql without passing any mysql command line options which means removing all this from the start up command

-O key_buffer=384M -O
max_connections=3000 -O myisam_sort_buffer_size=64M -O
max_allowed_packet=1M -O max_connect_errors=200 -O table_cache=512 -O sort_buffer=2M -O record_buffer=2M -O connect_timeout=60 -O thread_cache=8 -O thread_concurrency=12 -O tmp_table_size=50M -O wait_timeout=500 --big-tables


2. create or replace a my.cnf file in /etc/my.cnf with the below and restart mysql (you may need to change the path to mysql.sock file on your server)


[client]
port = 3306
socket = /var/lib/mysql/mysql.sock

[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = max_connections=800
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=256
set-variable = wait_timeout=7200
set-variable = connect_timeout=10
set-variable = max_allowed_packet=8M
set-variable = max_connect_errors=600

[safe_mysqld]
open_files_limit=8192

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysqlcheck]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=32M
set-variable = write_buffer=32M

[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=16M
set-variable = write_buffer=16M