Haken speaks

POSTED BY: SigmaNunki
UPDATED: Sunday, July 27, 2008 23:01
VIEWED: 6539
PAGE 1 of 4

1 2 3 4 NEXT PAGE

SIGMANUNKI

Monday, July 21, 2008 7:20 AM

Don't know if anyone has posed this, but Haken speaks on fff.net issues:

http://www.shinyuniverse.net/blog.aspx?bid=72
"""
Due to an unknown problem with the SQL server, FFF.NET will be down for the time being.

I'm not quite sure what is going on at this point. I checked the database, cleared the transaction logs, did a defrag, and reindexed the tables. None of it seems to work. Queries are just slow for some strange reason.

Next thing I'll try is importing all the tables and stored procedures into a new database. Maybe that might fix things.
"""

Btw, this isn't the first time this has happened.

----
I am on The Original List (twice). We are The Forsaken and we aim to burn!
"We don't fear the reaper"

HAKEN

Monday, July 21, 2008 12:14 PM

That's somewhat old news. FFF.NET is working much better now. The database was moved to another server Friday night, which seems to have resolved some of the speed issues that the site was having.

With the large number of visitors we have daily, many of whom are viewing the site all together at the same time at any given moment, I think the site is actually doing pretty okay in terms of handling the load.

By design (because I didn't know any better 4+ years ago when I built FFF.NET) this site is inherently slow. So any sort of problems we have these days just compounds the performance issues.

Am I going to rewrite the code or rebuild the site to make things go faster? Probably not. Well, maybe if Firefly comes back as a series or there's another Serenity movie, then at that point, yeah, a definite yes. Till then, we'll just fly slow and steady.

PHYRELIGHT

Monday, July 21, 2008 12:41 PM

I think the biggest problem is a traffic increase due to Dr. Horrible's Sing-Along Blog, 'cause the same thing happened at drhorrible.com and whedonesque.com last week, and that's when a lot of the problems started here, right? It's not nearly as bad now, but I've now noticed that I usually can't access FFF during high-traffic times like in the evenings.

I hope this helps to send you off in a better direction.

Darksiders can keep their cookies. We have better writers.

Grrr. Argghh.

Experience the Horribleness!

http://www.drhorrible.com

... Oh, my gosh. I've turned into one of those people with a crazy signature! ACK!! O_o

SIGMANUNKI

Tuesday, July 22, 2008 2:07 AM

Quote:
Originally posted by Haken:
That's somewhat old news. FFF.NET is working much better now. The database was moved to another server Friday night, which seems to have resolved some of the speed issues that the site was having.

With the large number of visitors we have daily, many of whom are viewing the site all together at the same time at any given moment, I think the site is actually doing pretty okay in terms of handling the load.

Point of fact, it took me over 20 minutes to the point where I was logged in and starting to reply to your post. I don't exactly call that "pretty okay in terms of handling the load." I would call it obscene.

Quote:
Originally posted by Haken:

By design (because I didn't know any better 4+ years ago when I built FFF.NET) this site is inherently slow. So any sort of problems we have these days just compounds the performance issues.

Am I going to rewrite the code or rebuild the site to make things go faster? Probably not. Well, maybe if Firefly comes back as a series or there's another Serenity movie, then at that point, yeah, a definite yes. Till then, we'll just fly slow and steady.

Slow, that's what you call it. I call it unusable. Honestly, if you don't have the time to maintain a site, than why not accept one of the many offers to hand off development (and/or help)? Then perhaps the users wouldn't have to deal with the nonsense of having the site go down or otherwise unavailable several times a year because of things which are entirely preventable.

----
I am on The Original List (twice). We are The Forsaken and we aim to burn!
"We don't fear the reaper"

SIGMANUNKI

Tuesday, July 22, 2008 2:37 AM

Quote:
Originally posted by PhyreLight:
I think the biggest problem is a traffic increase due to Dr. Horrible's Sing-Along Blog, 'cause the same thing happened at drhorrible.com and whedonesque.com last week, and that's when a lot of the problems started here, right? It's not nearly as bad now, but I've now noticed that I usually can't access FFF during high-traffic times like in the evenings.

I hope this helps to send you off in a better direction.

Correlation does not imply causation. And in case you didn't get Haken's response, there wasn't a direction he was heading. His response is to let things be. As in, we have to put up with the site being unstable and slow.

Also, the problems with those other sites were due to a change in servers and the resultant issues with DNS entries not instantly updated around the world. As in, it had nothing to do with load.

EDIT: It took over 2 hours to post (and update) both posts. Ya, this is acceptable.

----
I am on The Original List (twice). We are The Forsaken and we aim to burn!
"We don't fear the reaper"

JEWELSTAITEFAN

Tuesday, July 22, 2008 3:57 AM

So is the problem resolved? haven't been able to do much last week, and yesterday again. Couldn't even see threads, only the main index and sometimes the forum index of threads.
I'm on from 2200-0500 Central Standard Time, so I don't think midnight to 4am is the heavy traffic time, is it?
Can somebody say that posts made now will not be deleted like all our posts last week?

JEWELSTAITEFAN

Tuesday, July 22, 2008 3:57 AM

So is the problem resolved? haven't been able to do much last week, and yesterday again. Couldn't even see threads, only the main index and sometimes the forum index of threads.
I'm on from 2200-0500 Central Standard Time, so I don't think midnight to 4am is the heavy traffic time, is it?
Can somebody say that posts made now will not be deleted like all our posts last week?

FILLYGIRL

Thursday, July 24, 2008 12:23 PM

Haken,
THANK YOU VERY MUCH FOR ALL THE HARD WORK GETTING THIS BACK!!!!

...I work in IT, I know it was a bitch to fix, can I ask what you did or found out was the problem? Thanks again, YOU ROCK!

deb

Chaplain of the 76th Independant Battalion

...it's worse than you know...Operative
...it usually is.....Mal

HAKEN

Thursday, July 24, 2008 6:03 PM

Quote:
Originally posted by fillygirl:
...I work in IT, I know it was a bitch to fix, can I ask what you did or found out was the problem? Thanks again, YOU ROCK!

Normally FFF.NET runs on two separate servers. It seems like there was a problem with the link between the web server and the SQL server. It could be the network card or maybe something else. I'll have to test it to be sure.

To isolate the problem, I moved the website so that it's on the same server as the SQL server. The site seems to be doing much better now. Since having the website and SQL on the same server isn't a very good idea performance wise, I'll have to eventually move the site back when the server gets fixed.

That's where we're at right now.

MAGHAFFAR

Thursday, July 24, 2008 8:31 PM

Cap'n Haken.... How this site operates -- under the rader and all -- is the perfect metaphor for the Browncoat Universe. We don't want no Gorramn Alliance-blazing fast site where nuthin' ever breaks down. Our compression coil busts, guess we drift until you can fix it. Stay Shiny & Keep Us Flyin'. Hen duo xie ni.

--MAGhaffar

==================================================================
Jonathan M.A.Ghaffar - Your Firefly/Serenity MP3 Ringtone Smuggler!
Free MP3 uploader (PC) at: www.tonethis.com
-----------------------------------------------------------------
MAGhaffar@wayoftheseekers.com
FF Stickers & "Scents of Serenity" Perfume Oils.
http://www.TombofJesus.com --> www.alislam.org

1 2 3 4 NEXT PAGE