Hey guys, just keeping you in the loop about what’s up. I was forced to nuke all of the comments on the previous three chapters (as well as the previous post). Basically, I’m 99% sure that due to the way things were coded, the comments were killing the server, but not in the way you think.
Here’s the issue; the way the current system works is, each time the page is reloaded or looked at, there is a query/hook to the database to show how many comments each person has (which also generates the rank). This is a simple query; no big deal. The problem comes when we have HUNDREDS of comments, that mean each time someone reloads/opens the page, there’s hundreds of additional queries that are being generated, and since we have (on average) 500-1000 people on the site at any time…we’re quickly DDOS’ing ourselves (on top of the still-ongoing DDOS).
Turning on Varnish (the thing which is making you see the mobile site on PC, and the PC site on mobile) helps with the problem, but Varnish cache doesn’t play well with the theme in its current configuration, AND is pissing off the advertisers, so that isn’t a long-term solution either.
This idea is awesome, and we’re definitely going to continue it, but for now, I had to nuke the comments in the past three chapters. You may see the system ‘appear and disappear’; don’t worry about it, that just means we are troubleshooting it. For now though, this was causing the database to choke; we were averaging a load of 9 (our ‘max’ should be 6), but after I deleted the comments, it immediately dropped to 2, which strongly indicates that my interpretation is correct.
tldr; comments nuked because the new system + massive comment influx was killing the server. And also, to be honest, it was kinda making it impossible for me, even with my backend tools, to be able to read each chapter. I apologize to the people who just recently commented and/or were commenting on topic, but it was just too much. I’ll have to do something about that later, hehe.
Anyhow, chapter soon!