I see all of these threads talking about the server being slow during peak times and that made me wonder what the specs of the server are (type, processor speed, RAM, hard drive size etc.) I work in IT so I was just curious.
It’s a Cray SV1, soon to be upgraded to a Cray SV1ex™.
Actually I was joking. I don’t know that the administration is keen on revealing the exact characteristics of the server. I do know that there are some websites that will attempt to determine which OS is being run by a web server.
Specs:
Dell PowerEdge 1300
Two Pentium III 450 MHz processors
512 MBs RAM
Two 9 GB SCSI hard drives w/mirroring via RAID controller
Purchased in Spring of 1999.
Could I do something about the speed of the web server? Sure. Would there be any return on that investment? Most definitely! Not to be flip about it but in almost all likelihood the return would be negative since we’d also then need to purchase additional bandwidth capacity to handle the increased traffic. Since banner ad sales aren’t setting the world on fire that seems like a losing proposition at the moment. Any excess capacity we have given to the web server in the past miraculously gets used up rather quickly placing us right back in a bogged down condition. I’d expect a replay of that exact same phenomenon in the future. It’s that “free resource” thing. You keep giving it away and people not only take it but also seem to want more…
C’est la guerre!
jdavis, can you answer the following things as well?
-
What bandwidth (upload/download) does the SDMB server have available to it?
-
How large are post.myd and post.myi at the present time? How large is the entire data directory? (I’m curious because I am wondering how much space I may need for the UnaBoard in the future).
And here I thought it was an underfed hamster running in a rusty wheel.
Guess I was wrong. :o
Hmm Interesting.
Is it possible someone could look at my questions, or if they are deemed a security risk to discuss openly (I’m pretty certain they are not), mail me instead?
I don’t think J gets to the boards very often, Anth (at least not this here visible part!). You might do better dropping him an email.
-
Two T-1s configured to look like a single communication channel from the LAN side our network. 384 Kbytes/sec upload/download shared capacity. The SDMB probably consumes 40% of this bandwidth at peak capacity with the remainder being utilized by our other web sites, corporate usage, etc.
-
Using an older version of MySQL so the file names are different from yours but the complete post file and post index file are both approximately 825 MBs. Of course, that’s a problem when you only have 512 MBs of RAM. The performance of the SDMB ends up being constrained by the performance of our disk subsystem…and of course MySQL’s table wide locking mechanisms which don’t do much for concurrency.
Oh my. This is a lot less than I thought. 40% of 384Kbytes is about 1.536 MBit (assuming 10 bits/actual data byte). That is about 12 times my bandwidth upload, and about equal to my bandwidth download. I guess I’m not doing too bad then…but why does my connection get saturated sometimes, I wonder? (Don’t answer - rhetorical question. 
)
Yipe - I didn’t make this connection. So, we have 825 MB each for 1,340,000 posts is about…615 Bytes per post for each file, on average.
On the UnaBoard, my post file is about 1.5 MB, but my index file only about 200 KB. I had about…4800 total posts as of today. I don’t know why my index file is so much smaller, proportionately speaking.
Anyhow…that helps me a lot, thank you. It also tells me I ought to think about a RAM upgrade in the future as well (I only have 64 MB, although task manager shows I rarely break 40 MB used - for now).
jdavis has said in the past that he added some additional indexes to the default vBulletin/mySQL set-up for performance. And anyway, as we all know, it’s not the size of the index …