we need a new server QUICK

[Robertus]

Hi,

I am in trouble. We ran a very successfull vB-Forum, but our ISP shut us down because we totally blocked one of his Sun-Servers.

Now, I don't understand too much about this hardware, but we need a new server as fast as I could.

What do I need?

Last time it ran it was 6063 threads, 102018 posts and 2325 members - growing by 800 pots per day.

Do I need a Sun dual prcessor unit, or is a pentium / Linux system enough?

Is somewhere here offering hosting for vB-Servers and knows his trade and will help me setting up an optmized vB-Server?


Thanks.

[Robertus]

OK, board, what do I need on a new (dedicated) server so that you can help me get it ready for vB2. This is what I found browsing this forum:

mysql 3.23.32
Apache 1.3.17
Upgrade to PHP 4.0.4
Install PHP with zLib support or better mod_gzip
option to run command "top"
stat.php

what else?


Our ISP tells me I need to buy a Sparc-10 for $7,500 at least to run vB (the same ISP that banned us fro his virtual server). What Pentium machine do you think is enough.
Please help me if I don't get experts (you!) opions on this my ISP will not let me put vB back on.


Thanks for your help.


btw: this is the stat.php output from the virutal host - does this tell you anything? vB has not been running on this for about 2 days, but maybe it show some mis-configuration (?)


Wed Feb 14 16:55:49 MET 2001
+--------------------------+-----------+
| Variable_name | Value |
+--------------------------+-----------+
| Aborted_clients | 43 |
| Aborted_connects | 0 |
| Created_tmp_tables | 5599 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 4 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 7221 |
| Handler_read_first | 5700 |
| Handler_read_key | 4028040 |
| Handler_read_next | 1929287 |
| Handler_read_rnd | 143241987 |
| Handler_update | 92599 |
| Handler_write | 302828 |
| Key_blocks_used | 5656 |
| Key_read_requests | 7535255 |
| Key_reads | 5352 |
| Key_write_requests | 39506 |
| Key_writes | 31560 |
| Max_used_connections | 18 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 63 |
| Open_files | 108 |
| Open_streams | 0 |
| Opened_tables | 1632 |
| Questions | 227176 |
| Running_threads | 15 |
| Slow_queries | 686 |
| Uptime | 16120 |
+--------------------------+-----------+

Key Reads/Key Read Requests = 0.000710 (Cache hit = 99.99929%)
Key Writes/Key Write Requests = 0.798866
Temporary Tables Created/second = 0.347 (/hour = 1250.397)
Slow Queries/second = 0.043 (/hour = 153.201)
% of slow queries = 0.302%
Queries/second = 14.093 (/hour = 50734.094)
Uptime = 4 hrs 28 mins 40 secs

[eva2000]

first off you don't need a Sun server at all...

from your stat.php output, i can see your table_cache setting is inadequate - your isp probably hasn't optimised mysql on his server

I have similar stats

155,000 posts, 1700 members and 1,000 - 1,500 posts/day and run my vB on a dedicated P3 733, 256MB, 9gb sci with 100GB/month and it never goes over 0.50 load average and at most eats 3 - 4mb into my swap file.

from that stat.php out on your virtual host account, the mysql has been running for 4 1/2 hrs

[Robertus]

Hi,

thanks for your answer Eva. Please tread me like a newborn when it comes to server-tweaking.

"your table_cache setting is inadequate"... what should we change?

what infos else would be helpfull if I post them here?


Thanks!!

[eva2000]

I'd suggest you read my links in my sig ;)http://vbulletin.com/forum/showthread.php?threadid=3452

[Robertus]

Hi Eva,

I already read that. My biggest problem is, I don't have telnet-access to the server. So I cannot run mysqladmin extended-status or top or vmstat.

I hoped to get some out-of-the-box settings I can hand to my ISP so he can set them.

[version2]

But...your ISP should be responsible for setting up and tweaking mySQL to its optimum. Otherwise...what are you paying for?

[Robertus]

it's real cheap : about $150 flatrate.

[version2]

Originally posted by Robertus
it's real cheap : about $150 flatrate.

What?? A year?

Too much.