Downtime and Upgrades

Administrators will post news concerning the site here.

Re: Downtime and Upgrades

Postby Spokavriel » Tue Jun 16, 2009 9:30 am

Considering my problems with marking threads read since the "Optimization" I'm guessing it only made changes to database entries made by the forum post upgrade.
Image
Spamville Character ProfileArchived Current Senshi of Ophelia (Uranus VII).
My Console Video Games
Spokavriel
User avatar
Eternal Power Senshi
Posts: 47377
 

Re: Downtime and Upgrades

Postby Crescent Pulsar » Tue Jun 16, 2009 12:33 pm

It seems like it's difficult to make new post indicators go away after browsing the new post. I kind of rely on them to know what's new, so it's kind of irritating to check and make sure and find out it's something I've already seen. <_<;
Crescent Pulsar
User avatar
Crisis Power Senshi
Posts: 10046
 

Re: Downtime and Upgrades

Postby lwf58 » Tue Jun 16, 2009 12:48 pm

The tweaking I did was around 10:00 pm Central time last night, so problems you may have had yesterday were not a result of that.
lwf58
User avatar
Site Master
Posts: 2201
 

Re: Downtime and Upgrades

Postby Stacy » Tue Jun 16, 2009 12:51 pm

lwf58 wrote:It might just be a matter of having so many legacy messages in our databases that the server is having problems dealing with them all. I really don't know enough about bulletin boards to know if there's some sort of practical limit. Since I just got done trimming the user list, it doesn't seem likely that having too many users was the cause. After all, there are much larger boards that we are running out there.

It isn't. Messages are only processed when they're needed, so old ones sitting about doesn't hurt anything. The only reason a large number of posts would slow things down is lots of fulltext searching, and even then it's MySQL's fault and not that of phpBB. As far as a post limit... 16,777,215. That's how many unique IDs a post could have. Right now we're at about 261,385. I wouldn't worry about post counts anytime soon.
Ask me about my curses, clothing, contracts, wishes, viruses, potions, wards, prophecies, mutant abilities, school uniforms, books, hexes, jewelry, wards, DNA resequencers, computer programs, enchantments, weapons, water springs, musical instruments, blessings, alchemic techniques, porphyric feline hemophilia, spacial anomalies, kitsune magic, demonic adoption rituals, and data manipulation techniques for turning people into girls!
Stacy
User avatar
Site Mistress
Posts: 690
 

Re: Downtime and Upgrades

Postby Spokavriel » Tue Jun 16, 2009 1:07 pm

About 10 central is when all the posts since the upgrade switched to displaying themselves unread. And ever since then if I have had the last post on a board the new post indicator icon on the index page won't go away without hitting the Mark All Read for the entire forum.
Image
Spamville Character ProfileArchived Current Senshi of Ophelia (Uranus VII).
My Console Video Games
Spokavriel
User avatar
Eternal Power Senshi
Posts: 47377
 

Re: Downtime and Upgrades

Postby lwf58 » Wed Jun 17, 2009 7:46 am

Okay. I changed a couple of settings back to what they were before to try and get the read/unread working properly again. The change I made was supposed to move tracking read/unread to cookies instead of having a database track 'em.
lwf58
User avatar
Site Master
Posts: 2201
 

Re: Downtime and Upgrades

Postby talonhunter » Thu Jun 18, 2009 2:34 pm

The good news is...I can FINALLY use my iPhone to read posts on the site...only when i go to post, it wont let me stay logged in to write a post. Not necessarily a bad thing mind you, but it can be a little annoying when all I have out at the time is my phone. If it's a compatibility glich, then I can live with needing to break out the Air card and laptop to post, but if it is fixable, then it would be greatly loved by those of use who use these (pretentious and insane) devices. Thanks for what you do
Who needs the light when the shadows are so much more...Playful

Senshi of Dione (Saturn IV)

=^*^=
Come see some of the crew here
talonhunter
User avatar
Prism Power Senshi
Posts: 2704
 

Re: Downtime and Upgrades

Postby lwf58 » Tue Jul 14, 2009 7:49 pm

Okay, we finally have a straight answer about the spate of site outages this year. It seems that our site is causing other sites on our server to experience slowdowns, and when that happens, the hosting company changes permissions on our site database to fix the problems they are having. Josh, Stacy and I are talking over possible solutions.
lwf58
User avatar
Site Master
Posts: 2201
 

Re: Downtime and Upgrades

Postby PCHeintz72 » Tue Jul 14, 2009 8:22 pm

Wierd... as big as this site is... I would not have thought it to get enough forum traffic to slow down most ISP servers. Afterall, there are plenty of high volume forums out there. I myself go to a couple of forums that are a lot larger. TFF comes to mind.
PCHeintz72
User avatar
Prism Power Senshi
Posts: 2686
 

Re: Downtime and Upgrades

Postby Spokavriel » Tue Jul 14, 2009 8:39 pm

From what I have been told the ISP's server is rather underpowered in processing and data handling capabilities. Hamstringed by being built with 1GB of Ram That would have been ok in 2003 if you are hosting multiple sites through the same processor but it's still rather low for anything more recent.
Image
Spamville Character ProfileArchived Current Senshi of Ophelia (Uranus VII).
My Console Video Games
Spokavriel
User avatar
Eternal Power Senshi
Posts: 47377
 

Re: Downtime and Upgrades

Postby lwf58 » Tue Jul 14, 2009 8:44 pm

It's not the traffic. We don't even have the kind of traffic we had a year or two ago. There's just something about the site that's causing the server to use more CPU time for it than the hosting company likes. I don't know what the limit is, since it's not mentioned in the TOS, but other hosting companies list 10% CPU usage in theirs.

One of my options is to have them move fukufics to a VPS (virtual private server), which would give us 100% dedicated resources. That would end the problems we are having now and save us the hassle of finding a new hosting company that's worth a hoot and then moving to it. Finding a host is a real concern, because there are hundreds of them out there that promise the moon and stars for really low rates and then don't deliver. Current problems aside, the company we are with has been pretty reliable for the years we've been with them.

That'd double my monthly costs for the site, but I'm thinking it might be worth it.
lwf58
User avatar
Site Master
Posts: 2201
 

Re: Downtime and Upgrades

Postby Sky » Tue Jul 14, 2009 10:48 pm

lwf58 wrote:It's not the traffic. We don't even have the kind of traffic we had a year or two ago. There's just something about the site that's causing the server to use more CPU time for it than the hosting company likes. I don't know what the limit is, since it's not mentioned in the TOS, but other hosting companies list 10% CPU usage in theirs.


Weird. Has the move to phpBB 3 helped at all? Could you move to MySQL 5?

Do your Apache/IIS logs indicate any kind of correlation between who (or what) is browsing the site when Fukufics starts burning CPU?
"The ultimate measure of a man is not where he stands in moments of comfort and convenience, but where he stands at times of challenge and controversy."
-- Martin Luther King, Jr.
Sky
User avatar
Senshi Cadet
Posts: 166
 

Re: Downtime and Upgrades

Postby lwf58 » Wed Nov 17, 2010 8:24 am

You may or may not have noticed a break in service due to the domain name expiring. No worries. It happened because the domain registration was tied to an expired credit card, and that's been dealt with, and as you can see, the site's back up and running normally again.

So nothing to see here, folks. Move along, move along.
lwf58
User avatar
Site Master
Posts: 2201
 

Re: Downtime and Upgrades

Postby Dumbledork » Wed Nov 17, 2010 10:27 am

lwf58 wrote:You may or may not have noticed a break in service due to the domain name expiring. No worries. It happened because the domain registration was tied to an expired credit card, and that's been dealt with, and as you can see, the site's back up and running normally again.

So nothing to see here, folks. Move along, move along.


LOL. And here I had thought someone had hijacked the webpage.
And that's the bottom line 'cause Dumbledork said so.

Dumbledork 3:16
Dumbledork
User avatar
Prism Power Senshi
Posts: 3341
 

Re: Downtime and Upgrades

Postby Spokavriel » Wed Nov 17, 2010 3:07 pm

I was worried that the expiration provided the possibility for the site to become hijacked.
Image
Spamville Character ProfileArchived Current Senshi of Ophelia (Uranus VII).
My Console Video Games
Spokavriel
User avatar
Eternal Power Senshi
Posts: 47377
 

PreviousNext

Return to Site Announcements

Who is online

Users browsing this forum: No registered users