Most liked posts in thread: SQL error

The last couple of games we have got a sudden large influx of people on the site to a level where its hitting 100% CPU utilisation. Usually, at the most active, we don't hit more than 75%.

Actually made some tweaks to make some of the processes more efficient after last week but today it was even worse (and was maxing out the RAM as well, that may be related to the CPU getting overloaded though)

 

Lol might very well be. There was a sudden large influx of users (And I thought maybe it was the Chinese bots we had an influx of in November/December but I had banned all of China and there is no obvious influx of bots, they all seem like legit people)

 

So you expect us to be able to see the future and know a sudden unusual influx of visitors are about to happen. I have the server tools open during matches and actually catch many potential issues before any of you lot even aware but the CPU in the space of 10 seconds went from 62% to 100%

 

Around 300

 

It was actually around 650. What the forum records as a user and the 'unique' connections to the server differ.

The big problem really comes when it starts to get slower and people get impatient, especially when logging in. They click submit multiple times or keep refreshing the page which then adds load and makes it slower which see's more people do the same thing so the more it struggles the more the load gets making it worse