Server issues & scheduled downtime for 7 am GMT January 9

7 posts
User avatar
Gender Male
Points 11542
Reviews 426
The server will be shutdown for as long as 1 hour beginning at 7 am GMT on January 9. That's typically the slowest time of the day on YWS, so few users should be affected. The shutdown is to do some database maintenance that can only be done when the database is taken offline.


Reason and technical discussion follows

This will address some of the ongoing server issues that we've been having lately. A large number of these issues were related to the flashchat that we brought back for a few days. The flashchat is poorly designed and is thus a memory hog. Since the YWS server doesn't have enough memory as it is, the flashchat exacerbated the problem. But, getting rid of it doesn't solve the problem entirely.

Right now, activity is up. Way up. Yesterday, we had over 26,000 pageviews in a single day without anything special going on. That means activity on YWS has already returned to the levels of 2011, which was the heyday of this site. Activity also currently shows no signs of flattening out or decreasing.

So with rising levels of activity, I need to do more database optimization. Part of this optimization will involve deleting information from the database that is duplicated elsewhere or no longer needed. For example, the old literary forums will be removed as everything contained in them is now duplicated in the literary area. There's also information in the database for the old poetry and short story sections (the ones that contained published works by authors such as Emily Dickinson and Rudyard Kipling), and that stuff can be removed as we're currently not using it. Please note, there are multiple backups of everything just in case (there's even backups for restoring this site to November 15, 2004!).

But there's also a corrupted file in the database that needs to be repaired. This corrupted file doesn't harm anything, but it's printing hundreds of error messages every second. That's a big resource drain on the server, and the only way to fix it is to delete it. But if I delete it while the site is running, then all information on the site will be deleted as well. It's kind of an important file (google "ibdata1 file" if you're interested in knowing what it is).

However, the above is still not going to fix everything. The only way to completely fix the server issues is to purchase more ram. At the moment, there's no money for that. But I'm hoping that I'll be able to double the size of the server within the next few months. Once I'm able to do that, there'll be no server issues at all for a very long time (at least a month!).




User avatar
Gender Female
Points 4980
Reviews 96
I've still got a couple useless dollars spare on a prepaid card of mine. Am saving it for the option to donate.
Noni Naps Through Nano
NaPoWriMo 2016
Stories Not Otherwise My Own

AnnieJaePayne
The Three Ninjateers
Being awesome since Jan 2012.




User avatar
Gender nonbinary
Points 4007
Reviews 117
noninjaspresent wrote:I've still got a couple useless dollars spare on a prepaid card of mine. Am saving it for the option to donate.


I'm sure you're not the only one ^^

Really, Nate, you could put some account number up or something, you never know.. Without this place, some of us would pretty much be lost, so allow me to speak in the name of all and say we'd like to help if can..
• previously ChildOfNowhere
- they/them -
literary fantasy with a fairytale flavour




User avatar
Gender Male
Points 11542
Reviews 426
Everything should be working now.

The initial results look good, but only time will tell.




User avatar
Gender Female
Points 26101
Reviews 1335
Hey! That was my prime check-YWS-between-classes time! D:
you can message me with anything: questions, review requests, rants
are you a green room knight yet?
have you read this week's Squills?




User avatar
Gender Female
Points 3888
Reviews 763
So that's what happened.
Clearly, it's a sign that I should look into these threads more.
~
Pretending in words was too tentative, too vulnerable, too embarrassing to let anyone know.
- Ian McEwan in Atonement

sachi: influencing others since GOD KNOWS WHEN.





User avatar
Gender Male
Points 11542
Reviews 426
We had about 35 minutes of downtime that began when Cloudflare, our DNS provider, started doing some scheduled maintenance. Everything should be good now.

On the plus side, it gave me a good baseline to compare site activity against when I'm the only one who can access the server!



Now I realize that there is no righteous path, it’s just people trying to do their best in a world where it is far too easy to do your worst.
— Castiel