You've likely been wondering why the site has been slow the past week. I've been wondering the same.

The Issue

Sluggish performance on the page displaying your past giveaway entries, and more recently, all pages. This seemed to occur primarily during peak hours, but also at what appeared to be random, during off-peak hours as well.

Why Is This Happening?

In short, we don't have enough ram to store our active dataset and indexes, so the site needs to occasionally read from disk. For example, a user attempts to view their giveaway entries from the past. Our server can't hold all of our giveaway entry information in our limited amount of ram, so this information would be read from disk. Scanning hundreds of millions of rows on disk to find the related data for a user is an incredibly slow process, and it might take 30+ seconds, when it should be taking 0.02 seconds if the data was available in ram. This explains why the page displaying your past giveaway entries would take a long time to load if you haven't accessed it in a while, since it would be reading from disk instead of ram.

Now, what about other pages, why has everything been slow lately? Well, the disks are so busy working overtime, trying to read the data for the above user, they're not available for other users browsing the site, and these users are left waiting, and waiting, and potentially timing out. If we had more ram available, the original user would be reading their data directly from ram, and the disks would be free for writes.

Solution

We need to download more ram. Our database server runs 24gb of ram at the moment, and that's far too low for our 60gb of data and indexes. I received a price today for upgrading to 128gb of ram, and we'll soon be going through with those upgrades. However, we need a short term solution so users can continue using the site before that happens. I ended up disabling the page for viewing your past giveaway entries. This keeps the hard drives from being a bottleneck and spending all of their time reading that information for a small number of users, when they need to focus on writes to the database for everyone else. It's peak hours right now, and you should notice the site being quite responsive, so I think this solution will work well until the ram upgrade.

Edit: The entered giveaway page will now show 100 of your past entries, in descending order. For performance reasons, this is the only way the results can be ordered and displayed until the server is upgraded, and full functionality can be restored.

8 years ago*

Comment has been collapsed.

Thank you cg for your ongoing imrovements to this site! Will the comment notifications come back soon?

8 years ago
Permalink

Comment has been collapsed.

Deleted

This comment was deleted 5 years ago.

8 years ago
Permalink

Comment has been collapsed.

you clever sob . you reserved and edited instant later. 10 comments by the time i see n click submit =.='

8 years ago
Permalink

Comment has been collapsed.

Good News Everybody!

View attached image.
8 years ago
Permalink

Comment has been collapsed.

I'm laughing so hard at this OMG

8 years ago
Permalink

Comment has been collapsed.

Is it only me? Yes? Okay...

View attached image.
8 years ago
Permalink

Comment has been collapsed.

View attached image.
8 years ago
Permalink

Comment has been collapsed.

Thanks for doing this for us cg, let us know if we can help somehow!

8 years ago
Permalink

Comment has been collapsed.

need more ram omnomnom

8 years ago
Permalink

Comment has been collapsed.

can't see my : View Entered =.='

8 years ago
Permalink

Comment has been collapsed.

Deleted

This comment was deleted 5 years ago.

8 years ago
Permalink

Comment has been collapsed.

A small price to pay temporarily and a big improvement noticed, nice.

8 years ago
Permalink

Comment has been collapsed.

You can never have enough RAM :-)

8 years ago
Permalink

Comment has been collapsed.

Why don't you use indiegogo/ kickstarter or even patreon for us to help you with the hardware upgrades and other costs?

8 years ago
Permalink

Comment has been collapsed.

I'm with him, if only i had money

8 years ago
Permalink

Comment has been collapsed.

Or a donation page? If a bunch of people chipped in a few bucks it would help.
cg, any particular reason yon don't want to do this?

8 years ago
Permalink

Comment has been collapsed.

While I only know about him via his forum posts, CG seems too hands off & giving to want to take from anyone else.

8 years ago
Permalink

Comment has been collapsed.

He gets some money from advertising. I assume this is enough to justify the upgrades.

8 years ago
Permalink

Comment has been collapsed.

128GB Fancy, i did some days ago a puzzle that required cheking my old giveaways but not problems.... xD thanks for the warnning :v

and thank you cg.

8 years ago
Permalink

Comment has been collapsed.

View attached image.
View attached image.
8 years ago
Permalink

Comment has been collapsed.

aye aye, captain!

8 years ago
Permalink

Comment has been collapsed.

I wanted to post the download more ram thing รง_รง

8 years ago
Permalink

Comment has been collapsed.

thank you so much guys!!

8 years ago
Permalink

Comment has been collapsed.

Download more ram. I love you steamgifts.

8 years ago
Permalink

Comment has been collapsed.

Thanks for link, needed some more RAM too :3

8 years ago
Permalink

Comment has been collapsed.

TLDR: stop looking at your entered giveaways all the time! Let it go! You won some, you lost many, tomorrow is another day. Also, the server is getting a RAM upgrade.

8 years ago
Permalink

Comment has been collapsed.

People usually look entered giveaways to leave some GAs to free points when needed.

8 years ago
Permalink

Comment has been collapsed.

Yeah, it's quickest way to do it without leaving any unwanted entries (like when you won something and want to leave all GAs for it - public and private alike).

8 years ago
Permalink

Comment has been collapsed.

I know guys, it was more of a joke.

8 years ago
Permalink

Comment has been collapsed.

:D

View attached image.
8 years ago
Permalink

Comment has been collapsed.

Thanks for the update.
(To be honest I am wondering a bit how you're paying for it and what kind of system you got set up server-wise but that's just my curiosity :p)

8 years ago
Permalink

Comment has been collapsed.

Surprisingly fast! Thanks!

8 years ago
Permalink

Comment has been collapsed.

I've got a 256mb ddr stick somewhere in here I could part with for few gta 5s. :-)

8 years ago
Permalink

Comment has been collapsed.

That all? I'll dig out my old 386.

8 years ago
Permalink

Comment has been collapsed.

Thanks for keeping us informed. They're using hard drives? Why not some RAID configuration with SSDs? SSDs have much better access time than HDDs... That is the most important advantage of SSD over HDD.

Random read latency:

View attached image.
8 years ago
Permalink

Comment has been collapsed.

SSDs dies really fast with a lot of writes.

8 years ago
Permalink

Comment has been collapsed.

And they are few times more expensive than HDDs. That's why they won't be used as primary storage space for a long time (having on them tons of photos, games, movies and so on)

8 years ago
Permalink

Comment has been collapsed.

Dude... Don't burst his bubble. Not cool!

8 years ago
Permalink

Comment has been collapsed.

I'm talking about enterprise SSDs, not consumer garbage. Thousands of servers on Internet use SSDs.

8 years ago
Permalink

Comment has been collapsed.

SLC SSD also dies fast with a lot of writes and are very expensive.
Enterprises usually use that "consumer garbage" too, because it's much cheaper to them to change the drives every month than to buy a very expensive one that's going to last just some months more.

8 years ago
Permalink

Comment has been collapsed.

Thats actually not true. They do not die dast because of many writes. There is more than enough resources there. It's a myth. In 99% of early SSD death the faulty controller is the cause.

8 years ago
Permalink

Comment has been collapsed.

ssdendurancetest.com

8 years ago
Permalink

Comment has been collapsed.

Could be budget available to him to upgrade things. You realise he wouldn't have an endless budget to spend updating the site. And since he doesn't want us donating for it, I imagine a fair bit comes out of his own pockets.

8 years ago
Permalink

Comment has been collapsed.

Do you know by any chance why donations are not accepted? This site will continue growing like crazy and there are bunch of nice people that would love to help.

8 years ago
Permalink

Comment has been collapsed.

From what I remember, from the moment you accept donations people have expectations and feel entitled to a certain level of service. cg wanted to keep this a hobby project and not owe anything to anyone.

8 years ago
Permalink

Comment has been collapsed.

I understand and respect this but this site is not cheap to run =\

8 years ago
Permalink

Comment has been collapsed.

...or ads. It is hard to believe that someone would run server for 4 years or so with their own pocket.

8 years ago
Permalink

Comment has been collapsed.

I'm wondering how much of the operation costs the ads are able to cover.

8 years ago
Permalink

Comment has been collapsed.

There is a banner on home page. If you don't see it, you are probably using adblocker like most of us ;__;
A bunch of ads will be annoying.

It may be a good idea to add SG to exceptions in your adblocker so it would help generate some revenue. 1 banner won't kill anyone.

8 years ago
Permalink

Comment has been collapsed.

I know that, and I don't mind if they put some ads to pay for the upgraded server...

8 years ago
Permalink

Comment has been collapsed.

We do run RAID. SSDs would be great, but we're only noticing the limitations of our current drives because the server doesn't have enough RAM, and the drives are busy performing all of these unnecessary reads, which they'll no longer be doing once the dataset fits entirely in RAM.

8 years ago
Permalink

Comment has been collapsed.

Yes, I supposed you used RAID for security and better access times, but with SSDs the latency is ridiculous. I was thinking about the future, because there's a limit for RAM upgrade. Thanks for your response.

8 years ago
Permalink

Comment has been collapsed.

Are you running this on a colocated server or a virtual server?

Because in the latter case, depending on your provider, ssd's shouldn't be too expensive and still have a noticeable performance gain.

Of course if it's your own colocated server, then SSD's would be a costly choice and not worth it for the time being, as long as your RAM can fit the dataset properly with some room for growth.

8 years ago
Permalink

Comment has been collapsed.

I'd bet it is a dedicated server for the database only, or at least the new setup will be like that. One dedicated machine with a Xeon, 128GB of RAM and hard drives in RAID.

8 years ago
Permalink

Comment has been collapsed.

eww what on earth is download more ram? does it really work? can i sell my own ram and get like 16gb for free from their site? :D

8 years ago
Permalink

Comment has been collapsed.

Yes, you can.
You'll have to remove your own ram from your rig before attempting to get some from their site though.

8 years ago
Permalink

Comment has been collapsed.

wow so it really works? and i cant combine it with my own ram, thats it? :P well its not like i cant google or reddit it, so ill do it after tonights champions league games, dont really have to bother you with so many questioons. Like do i keep my graphics card, and stuff.

nice site though :d ok i think we should stop here, someone will think its a real thing

8 years ago*
Permalink

Comment has been collapsed.

it says its a joke on the download page though ^_^
Was just curious how far it'd go

8 years ago
Permalink

Comment has been collapsed.

I was one of these "bad" users which were checking "entered GA" page from time to time :D I feel guilty....

8 years ago
Permalink

Comment has been collapsed.

Thank you, cg :)

8 years ago
Permalink

Comment has been collapsed.

thank you :) I hope things are resolved soon

8 years ago
Permalink

Comment has been collapsed.

Closed 8 years ago by cg.