Maybe what's slowing down the server..

[Nimrod's Son]

Is the fact that I get spammed with these:
Hello Nimrod's Son,

SomeJackass has just replied to a thread you have subscribed to entitled - Hey, let's all blather on about nothing - in the General Chat Message Board forum of Netphoria Message Board.

This thread is located at:
http://www.netphoria.org/forums/show...6&goto=newpost

There may be other replies also, but you will not receive any more notifications until you visit the board again.

Yours,
Netphoria Message Board team

Whats particular here is that it says

There may be other replies also, but you will not receive any more notifications until you visit the board again.

which is total bullshit, since I get 7 or 8 of them if God forbid, I go to take a piss before checking my mail again.

[funnygeezus]

turn off email notification.

[Nimrod's Son]

Originally posted by funnygeezus
turn off email notification.

Thanks for the advice Einstein, but I if you'll notice the subject is "Maybe what's slowing down the server.." you'll realize I'm not bitching about the mails, I'm saying that the fact that it's generating more than it's supposed to is slowing down the server.

[funnygeezus]

Originally posted by Nimrod's Son


Thanks for the advice Einstein, but I if you'll notice the subject is "Maybe what's slowing down the server.." you'll realize I'm not bitching about the mails, I'm saying that the fact that it's generating more than it's supposed to is slowing down the server.

so you like the email notification?

woah.

[Nimrod's Son]

Originally posted by funnygeezus


so you like the email notification?

woah.

No, since it doesn't work properly, it sucks.. but that's besides the point.

[Travis Meekz]

wow, what a horrible thread

[dusty]

Originally posted by Travis Meeks
wow, what a horrible thread

i kinda liked it :erm

[MonteLDS]

Originally posted by Travis Meeks
wow, what a horrible thread

this thread is painfully stupid. their tons of factor and the main factor is CPU and RAM power, i doubt that it has bandwidth issue. but i am sure its CPU isn't dual xexon, like it should be for this kind of site, with this kind of attention. If the o-board didn't die we be better off. Also if we ban guest. and make it so u have to be a user it would help as well

[neopryn]

Originally posted by MonteLDS


this thread is painfully stupid. their tons of factor and the main factor is CPU and RAM power, i doubt that it has bandwidth issue. but i am sure its CPU isn't dual xexon, like it should be for this kind of site, with this kind of attention. If the o-board didn't die we be better off. Also if we ban guest. and make it so u have to be a user it would help as well

watch it, dude. Nimrod's Son tore you apart in that other thread.

[MonteLDS]

Originally posted by neopryn

watch it, dude. Nimrod's Son tore you apart in that other thread.

when you are talking about things that you know about, why would i have to watch anything. and to be honest i have no idea what you're talking about

Anyways enough with the complain about the server threads..

[Nimrod's Son]

Originally posted by MonteLDS


this thread is painfully stupid. their tons of factor and the main factor is CPU and RAM power, i doubt that it has bandwidth issue. but i am sure its CPU isn't dual xexon, like it should be for this kind of site, with this kind of attention. If the o-board didn't die we be better off. Also if we ban guest. and make it so u have to be a user it would help as well

Just so I don't repeat myself from the other thread..
Usually when a server starts experiencing issues, most people automatically assume it's a hardware deficiency, when it's not. That's because most laypeople, and people who think they know what they're talking about but really are just laypeople, have an automotive tendency. You look at a car, and to make it go faster you put a bigger engine in it, or supercharge it. What you fail to realize is that (to continue the analogy) it is much easier to just take a different road. Automotive analogies are flawed because they discount the fact that a server has an Operating System and interdependent software. SQL is incredibly memory intensive, but the solution is not usually simply adding "memory." It has been my experience that SQL databases are usually slapped together in piecemeal fashion that isn't noticibly negative at first, but once the implementation is done and the server gets busy, every redundancy, every mistake is multiplied.
I'm not sure how this server is implemented, nor do I claim to have experience with vBulliten. I do have experience with both UBB and YABB, however, and I will assume they are fairly similar, considering they are all PHP-Perl based applications that run on a SQL db.
That said, here is my initial point: I SHOULDNT GET MULTIPLE MESSAGES. What that means is that either:
Every time someone posts, the application runs a SQL query against the users table to see who is subscribed to the thread
OR
it runs a query against a subscribtion table to see what users are listed (this would be the optimal way as it involves less entries to search through, but does require more tables. Larger db, but quicker loads).
Now, after this initial query, it activates the Mailer Daemon, and passes along the parameters of username of recipient, username of poster, email address, thread title, thread forum nameand thread ID, which the program then formats in this manner:

mailto:email address?subject=Reply to post 'thread title'

Hello username of recipient,

username of poster has just replied to a thread you have subscribed to entitled - thread title - in the thread forum name forum of Netphoria Message Board.

This thread is located at:
http://www.netphoria.org/forums/show....php?threadid=thread id&goto=newpost

There may be other replies also, but you will not receive any more notifications until you visit the board again.

Yours,
Netphoria Message Board team

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Unsubscription information:

To unsubscribe from this thread, please visit this page:
http://www.netphoria.org/forums/memb...usub&threadid=thread id

To unsubscribe from ALL threads, please visit this page:
http://www.netphoria.org/forums/memb...type=allthread

Now, I don't even know if the server is running the (edit) SMTP mail server as well - it's possible it's all one box... which also begs the question that there may be tons of other processes running on the same server. There may not be. I don't know that, and you certainly don't, either.

What I DO know is that the redundant query that is run after each reply to a post is causing the server to run extra processes, causing extra SQL activity, and slowing things down.

I'm not "guessing that we need more RAM and processor speed" because I don't know our current RAM and processor(s). I do know that the queries are running too often.

I've been working with servers full time for 9 years Monte. How long have you been working with them?

[Nimrod's Son]

Oh, and I forgot to mention that it's a hell of a lot cheaper to fix your software flaws and implementation snafus and bugs then it is to run out and buy your "dual xexon" MLB and processors, especially since this is a free site run by someone who isn't asking you to pay a dime to use it.

[MonteLDS]

Originally posted by Nimrod's Son
Oh, and I forgot to mention that it's a hell of a lot cheaper to fix your software flaws and implementation snafus and bugs then it is to run out and buy your "dual xexon" MLB and processors, especially since this is a free site run by someone who isn't asking you to pay a dime to use it.

i am just telling you what Andrew told me when we talked. Netphoria is not on a good machine. and i believe it is running an SMTP *assuming that what u meant instead of AMTP*

i believe it is a SQL DB but don't quote me on that. Talk to Andrew. his software issue as he told me had be resolved. But maybe they have returned.

p.s. he wouldn't be "buying" anything. he rents these server. He doesnt have anything localy.

Also Andrew did ask people if they want to pitch in to pay for a new server... but maybe you were AFK when that happen

[Nimrod's Son]

Originally posted by MonteLDS


this thread is painfully stupid. their tons of factor and the main factor is CPU and RAM power, i doubt that it has bandwidth issue. but i am sure its CPU isn't dual xexon, like it should be for this kind of site, with this kind of attention. If the o-board didn't die we be better off. Also if we ban guest. and make it so u have to be a user it would help as well

Oh, and please... please, for the love of God, learn a little bit about grammar.

http://www.andromeda.rutgers.edu/~jlynch/Writing/

Originally posted by MonteLDS


this thread is painfully stupid. there are tons of factors, and the main factors are CPU and RAM power. i doubt that it has a bandwidth issue, but i am sure its CPU isn't dual xexon, like it should be for this kind of site, with this kind of attention. (sentence beyond help.) If the o-board didn't die, we would be better off. Also, if we ban guests and require everyone to have a user account, it would help as well

[Nimrod's Son]

Originally posted by MonteLDS


i am just telling you what Andrew told me when we talked. Netphoria is not on a good machine. and i believe it is running an SMTP *assuming that what u meant instead of AMTP*

i believe it is a SQL DB but don't quote me on that. Talk to Andrew. his software issue as he told me had be resolved. But maybe they have returned.

p.s. he wouldn't be "buying" anything. he rents these server. He doesnt have anything localy.

Also Andrew did ask people if they want to pitch in to pay for a new server... but maybe you were AFK when that happen

Yes, it was a typo, which I fixed. I didn't proofread that well, and I apologize.

It is a SQL db. I thought it was, but I double checked vbulletin.com to be sure.

I didn't say the machine was great. YOU were the one who suggested the upgrade to hardware. That's a lazy response. Your vaunted "dual xexons" didn't exist 2 years ago, but do you know what did? Messageboards. Wow, I wonder how they did it?

This whole thread was just me pointing out one example of a simple fix that could increase uptime for Netphoria.

Buying or renting.. either way, a better server will cost more money. Software options are usually free. Whether or not he asked for money is irrelevant to that fact and the fact that I serioulsy doubt you forked over any.

[MonteLDS]

The server has plenty of RAM, that is not the issue. The issue is the CPU, the server is a Cobalt Raq4i and the cpu on it isnt really that fast, its fine for most stuff but it can't handle the high loads of MySQL.

I am kind of stuck on what to do, I want to get a second server which would be much faster but it would cost around $100 U.S. a month.

Nobody is going to want to pay $5 a month in donations for that. One time only donations would cover a month or two at best so I am kind of stuck on what exactly to do.

- Andrew

[Nimrod's Son]

Originally posted by MonteLDS
The server has plenty of RAM, that is not the issue. The issue is the CPU, the server is a Cobalt Raq4i and the cpu on it isnt really that fast, its fine for most stuff but it can't handle the high loads of MySQL.

I am kind of stuck on what to do, I want to get a second server which would be much faster but it would cost around $100 U.S. a month.

Nobody is going to want to pay $5 a month in donations for that. One time only donations would cover a month or two at best so I am kind of stuck on what exactly to do.

- Andrew

I respectfully disagree. While a Cobalt RAQ4i is somewhat older, if it is a dedicated box, there shouldn't be any problems. I have a site (not currently running MySQL, but it has) running on a Raq2 with PHP3 and MySQL, and it's not an issue.
I respectfully submit that the software issues are still something that should be looked at, and as Jaggie suggested in another thread, the timout level on vBulliten could be increased.

[Travis Meekz]

nerd fights

[Crippler]

Originally posted by Travis Meeks
nerd fights

You just aptly described Netphoria.

[DeviousJ]

MONTEhttp://ottawa.rasc.ca/astronomy/chas...pse/equals.jpg http://www.westingrandvancouver.com/...hoto-prawn.jpg http://www.yikes.com/~rmb/letter.d.gif

[runs without pants]

Originally posted by Travis Meeks
nerd fights

Yeah. Nerds are dead sexy.

Tee hee. Dead. Tee hee. Sexy.