Go Back   EN World D&D / RPG News > Meta - Forums About Forums > Meta

Meta Post comments and questions about the messageboards and other parts of EN World. If you have a problem, this is where to go. Moderator email addresses are posted here.

 
Share LinkBack Thread Tools Display Modes
Old 27th April 2002, 02:53 AM   #1 (permalink)
Registered User
 
Join Date: Jan 2002
Posts: 1,823
Psionicist Goblin Sharpshooter (Lvl 2)
Reducing Serverload 101

This will help a little...

1) Put downloadable files like asgard magazine on other, free server. This will reduce serverload.

2) Put images on other free server, a well as all other files not plain text.

3) Put the d20reviews database -or- the whole d20review thing on a separate server.

4) Force the number of posts viewed per page to 15 or 20.

5) DISABLE attachments!!!

6) Disable unnecessary sendmail services.

7) Disable "views" on forum indexes. Unnecessary db quries.

8) Disable forum access for unregistered users, "guests". This is not the best solution but it might be necessary in the future.

The optimal changes presented here are 1, 2, 3, 5 and 8. The other options are just details for a small ammount of extra bandwidth. Option 7 is also a good thing to disable. We have enough MySQL queries already.

And finally, go to the secret moderator panel and look for this line on the frontpage: Server Load Averages 0.69, 0.52, 0.50 94 users online (65 members & 29 guests).. The 3 numbers (0.69, 0.52, 0.50 in this case) should be below 3, preferable around 1-2.

Over and out.

Last edited by Psionicist; 27th April 2002 at 03:00 AM..
Psionicist is offline   Reply With Quote
Old 27th April 2002, 03:36 AM   #2 (permalink)
Community Supporter
 
CRGreathouse's Avatar
 
Join Date: Jan 2002
Location: Eastern US/GMT-5
Posts: 5,678
CRGreathouse Goblin Sharpshooter (Lvl 2)
Re: Reducing Serverload 101

Quote:
Originally posted by Psionicist
7) Disable "views" on forum indexes. Unnecessary db quries.
This one, especially, sounds quite painless.

As for the others, I'll say only this: I'm certain #8 will never happen.
CRGreathouse is offline   Reply With Quote
Old 27th April 2002, 04:23 AM   #3 (permalink)
Admiral o' th' High Seas
 
Morrus's Avatar
 
Join Date: Jan 2002
Location: Southampton, England
Posts: 15,908
Morrus Bugbear Strangler (Lvl 6)
Most of them don't apply.

1,2,6) are how things are set up anyway.

3) can't. they were on the other server originally and moved to the main server because the other server couldn't handle it.

4,7) Good ideas.
__________________
Morrus is offline   Reply With Quote
Old 27th April 2002, 04:59 AM   #4 (permalink)
Registered User
 
orbitalfreak's Avatar
 
Join Date: Jan 2002
Location: southeast Louisiana
Posts: 927
orbitalfreak Goblin Sharpshooter (Lvl 2)
Send a message via Yahoo to orbitalfreak
Posts per page?

I didn't realize this caused any problems on the server. I have mine currently set at the maximum allowed. Oh well, I'm off to set mine to the minimum, just to help out a little. Maybe some other users will do this, too.

And if y'all others do that, post here. Seeing more people helping out will encourage even more to do their part.
__________________
--Matthew B. Milton
orbitalfreak is offline   Reply With Quote
Old 27th April 2002, 09:31 PM   #5 (permalink)
Registered User
 
XCorvis's Avatar
 
Join Date: Jan 2002
Location: St. Paul, MN
Posts: 1,069
XCorvis Goblin Sharpshooter (Lvl 2)
Would pruning old threads help at all? You could arbitrarily remove all OT threads that are more than say, 30 days old. Or just delete everything over 3 months old? That would be unpopular, but since we can't search, people just ask their questions twice, and a lot of material is very time dependant so it's not even relevant a few days later.
__________________
Your sig should never be longer than your post.
XCorvis is offline   Reply With Quote
Old 27th April 2002, 11:35 PM   #6 (permalink)
Hand and Eye of Piratecat [Moderator]
 
Darkness's Avatar
 
Join Date: Jan 2002
Location: Vienna
Posts: 12,428
Darkness has disabled Experience Points
Would turning off thread ratings help? Threads are almost never rated anyway but does the program still check for ratings when displaying the threads in a forum?
__________________
"The best gnomes were in Dark Sun." --GRAOUH !!! (WotC boards)
Darkness is offline   Reply With Quote
Old 28th April 2002, 12:10 AM   #7 (permalink)
Registered User
 
XCorvis's Avatar
 
Join Date: Jan 2002
Location: St. Paul, MN
Posts: 1,069
XCorvis Goblin Sharpshooter (Lvl 2)
I went poking around vBulletin and found a couple things, they might be worth checking out.

First, this forum is absolutely huge, with over 1 million posts. He's running 2.2.5 and I notice we are at 2.2.1. An upgrade may help.

Second, this guy's sig has a lot of optimization/help links. Some seem worth checking out.

Third, I've seen a gzip (file compression) setting mentioned in several places. You should have it set to 1. If it is higher, it will use too many resources compressing files. It's supposed to help reduce bandwidth. You might also try setting it to 0 (disable) to see if that speeds anything up. It will take more bandwidth, tho.

Fourth, it might not be vBulletin. It could be some other program causing a problem, which, combined with vBulletin, is crashing everything. I'd disable everything on the server that isn't absolutely necessary. Maybe upgrade your web hosting software as well.

Fifth, (I assume you're using linux or unix), recompile everything with optimization tags. Default installs of many operating systems (Red Hat, in particular) are set for 386 compatability and are not optimized. I think you are using a PIII, right? So you should have things set for 686 compatability. If the box runs better, the boards run better.

I'm sure you've done or looked at some of these, but I thought I'd throw them in just in case.
__________________
Your sig should never be longer than your post.
XCorvis is offline   Reply With Quote
Old 28th April 2002, 12:44 AM   #8 (permalink)
Admiral o' th' High Seas
 
Morrus's Avatar
 
Join Date: Jan 2002
Location: Southampton, England
Posts: 15,908
Morrus Bugbear Strangler (Lvl 6)
Quote:
Originally posted by XCorvis
I went poking around vBulletin and found a couple things, they might be worth checking out.

First, this forum is absolutely huge, with over 1 million posts. He's running 2.2.5 and I notice we are at 2.2.1. An upgrade may help.

Second, this guy's sig has a lot of optimization/help links. Some seem worth checking out.

Third, I've seen a gzip (file compression) setting mentioned in several places. You should have it set to 1. If it is higher, it will use too many resources compressing files. It's supposed to help reduce bandwidth. You might also try setting it to 0 (disable) to see if that speeds anything up. It will take more bandwidth, tho.

Fourth, it might not be vBulletin. It could be some other program causing a problem, which, combined with vBulletin, is crashing everything. I'd disable everything on the server that isn't absolutely necessary. Maybe upgrade your web hosting software as well.

Fifth, (I assume you're using linux or unix), recompile everything with optimization tags. Default installs of many operating systems (Red Hat, in particular) are set for 386 compatability and are not optimized. I think you are using a PIII, right? So you should have things set for 686 compatability. If the box runs better, the boards run better.

I'm sure you've done or looked at some of these, but I thought I'd throw them in just in case.
vBulletin is not causing the problem. A woefully underpowered server is. The server itself needs upgrading.

I'll check out those links - thanks.

Not using linux or unix, btw.
__________________

Last edited by Morrus; 28th April 2002 at 12:52 AM..
Morrus is offline   Reply With Quote
Old 28th April 2002, 01:46 AM   #9 (permalink)
Vengeance Bunny
 
Join Date: Jan 2002
Location: Sudbury, Canada
Posts: 909
Ashtal has disabled Experience Points
Curious...don't know if it's me, or the boards, but I've noticed the little black dots indicated whether or not I've posted to a thread are no longer showing up.

Has this feature been turned off, if it can be?


Ashtal - I don't trust my browser, either, though.
__________________
NUTKINLAND!
*Do not go in.
*Not for the faint of heart!
*Don't say I didn't warn ya!

http://www.nutkinland.com
Ashtal is offline   Reply With Quote
Old 28th April 2002, 02:50 AM   #10 (permalink)
Registered User
 
Holy Bovine's Avatar
 
Join Date: Jan 2002
Posts: 1,977
Holy Bovine Goblin Sharpshooter (Lvl 2)
Those black dot things are gone from my view too Ashtal. Daggnabitt!
Holy Bovine is offline   Reply With Quote
Old 28th April 2002, 03:00 AM   #11 (permalink)
Silver Flame Archivist
 
drothgery's Avatar
 
Join Date: Jan 2002
Location: San Diego, CA
Posts: 8,097
drothgery Goblin Sharpshooter (Lvl 2)
Quote:
Originally posted by Morrus
Not using linux or unix, btw.
Which, as much as it pains an unrellenting Windows advocate like me to admit, is probably not a good thing if you're running a PHP/MySQL based message board like vBulletin. Neither PHP nor MySQL are very well optimized on Windows.
__________________
Dave Rothgery

PBP
Spoiler:

My EnWorld Blog
Republic and Empire
Buffverse M&M game

Characters
Active
Sanne Bacher d'Lyrandar in S@squ@tch's Against the Giants - Team Black

Inactive
Istara Kandorian in Ankh-Morpork Guard's Star Wars: Rebels with Style
Eric Hassel (Quarterback) in Jemal's Mutant High
Sariel in Rumspringa's Keep on the Shadowfell
Khalia ir'Indari in DEFCON1's Eye of the Lich Queen
Serrana Vao in Karl Green's Knights of the Old Republic (with 213 things Serrana can't do in the Jedi Order)
Italimelk in Living ENWorld
Daellin ir'Ayellan in stonegod's Expedition to Castle Ravenloft
drothgery's Victorian Eberron game
Star Wars/KotOR Era - The Second K'ril Incursion
drothgery is online now   Reply With Quote
Old 28th April 2002, 04:05 AM   #12 (permalink)
Admiral o' th' High Seas
 
Morrus's Avatar
 
Join Date: Jan 2002
Location: Southampton, England
Posts: 15,908
Morrus Bugbear Strangler (Lvl 6)
Yeah, but the asp areas of the site won't work *at all* on linux/unix.
__________________
Morrus is offline   Reply With Quote
Old 28th April 2002, 04:16 AM   #13 (permalink)
Registered User
 
XCorvis's Avatar
 
Join Date: Jan 2002
Location: St. Paul, MN
Posts: 1,069
XCorvis Goblin Sharpshooter (Lvl 2)
Ah, Windows. That explains it.

There are some SQL optimization links in #2, I think. Don't know if they do Windows, tho.
__________________
Your sig should never be longer than your post.
XCorvis is offline   Reply With Quote
Old 28th April 2002, 04:51 AM   #14 (permalink)
Silver Flame Archivist
 
drothgery's Avatar
 
Join Date: Jan 2002
Location: San Diego, CA
Posts: 8,097
drothgery Goblin Sharpshooter (Lvl 2)
Quote:
Originally posted by Morrus
Yeah, but the asp areas of the site won't work *at all* on linux/unix.
Anyone know if there's a good ASP or ASP.NET-based message board system out there?
__________________
Dave Rothgery

PBP
Spoiler:

My EnWorld Blog
Republic and Empire
Buffverse M&M game

Characters
Active
Sanne Bacher d'Lyrandar in S@squ@tch's Against the Giants - Team Black

Inactive
Istara Kandorian in Ankh-Morpork Guard's Star Wars: Rebels with Style
Eric Hassel (Quarterback) in Jemal's Mutant High
Sariel in Rumspringa's Keep on the Shadowfell
Khalia ir'Indari in DEFCON1's Eye of the Lich Queen
Serrana Vao in Karl Green's Knights of the Old Republic (with 213 things Serrana can't do in the Jedi Order)
Italimelk in Living ENWorld
Daellin ir'Ayellan in stonegod's Expedition to Castle Ravenloft
drothgery's Victorian Eberron game
Star Wars/KotOR Era - The Second K'ril Incursion
drothgery is online now   Reply With Quote
Old 28th April 2002, 10:06 PM   #15 (permalink)
Registered User
 
Join Date: Jan 2002
Location: Syracuse, New York
Posts: 4,382
LightPhoenix has disabled Experience Points
Quote:
Originally posted by Morrus
Yeah, but the asp areas of the site won't work *at all* on linux/unix.
Which area would these be? Is there other possible ways besides asp to implement these areas?

A server upgrade is badly needed, but I too would recommend some sort of unix/linux system for the server, it's a lot more stable.
__________________

LightPhoenix is offline   Reply With Quote
Old 28th April 2002, 10:45 PM   #16 (permalink)
Admiral o' th' High Seas
 
Morrus's Avatar
 
Join Date: Jan 2002
Location: Southampton, England
Posts: 15,908
Morrus Bugbear Strangler (Lvl 6)
Quote:
Originally posted by LightPhoenix
[b]

Which area would these be?
Reviews page, ad rotation etc.

Quote:
Is there other possible ways besides asp to implement these areas?
No, because the know-how isn't available. Liquide knows ASP.
__________________
Morrus is offline   Reply With Quote
Old 29th April 2002, 01:58 AM   #17 (permalink)
A2Z
Registered User
 
A2Z's Avatar
 
Join Date: Jan 2002
Location: Windsor, Ontario, Canada
Posts: 982
A2Z Goblin Sharpshooter (Lvl 2)
Quote:
Originally posted by Ashtal
Curious...don't know if it's me, or the boards, but I've noticed the little black dots indicated whether or not I've posted to a thread are no longer showing up.

Has this feature been turned off, if it can be?


Ashtal - I don't trust my browser, either, though.
No black dots for me either. I was confused for a bit. I'm just glad I'm not alone.
__________________
"Everyone's always in favour of saving Hitler's brain. But when you put it in the body of a great white shark, ooohh! Suddenly you've gone too far!"

- Futurama
A2Z is offline   Reply With Quote


Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


And yet another word from our sponsors
Visit Our Sponsors
Visit Our Sponsors... Again
Powered by vBadvanced CMPS v3.0.1

All times are GMT +1. The time now is 06:01 PM.


Site Contents © 2008 ENWorld
PHP Ajax Multimedia Web Framework © 2008 Digital Media Graphix
Powered by vBulletin® Version 3.8.0 Beta 1
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0

"Vault Data" powered by VaultWiki v2.5.1.
Copyright © 2008 - 2009, Cracked Egg Studios.