123
-=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- (c) WidthPadding Industries 1987 0|599|0 -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=-
Socoder -> Site & Server -> Server Go Pop!

Posted : Tuesday, 19 May 2020, 08:31
Jayenkai
Hmm.. That's new. Complete outage of the SQL server, there.. Sorry about that, folks. (Nobody told me!)

-=-=-
''Load, Next List!''
Posted : Tuesday, 19 May 2020, 08:31
rychan
Must be something going around, my server died for a few minutes early yesterday morning, then my slew of debug emails appeared, all 48,000 of them. I'm guessing the web-spider was crawling at the same time...

-=-=-
Web / Game Dev, occasionally finishes off coding games also!

Refresh Games - Game Dev Blog
Posted : Tuesday, 19 May 2020, 09:02
Jayenkai
I know why it happened, but need to figure out a way to stop it in future.
Someone visited Foldapuz, and flicked through about 100 iterations of puzzle sheets. Over and over and over again, it had to generate images, and each time it does so, the system leaks a little bit of memory.
The PHP continued but the SQL could not longer fit!!

I'm convinced it's a PHP issue, trying to draw (Text, lines, copy, paste, rotate, scale, and more) 3,508x2,480 pixel images, to generate puzzle sheets. or at least, I think that's where the memory leak is..!

Need to figure out a way to either a) fix the leak, or b) get the server to clear out the memory (reboot apache) when it gets too bad.

Hmmm..

-=-=-
''Load, Next List!''
Posted : Tuesday, 19 May 2020, 09:11
rychan
Ahhh, are they not just daily still then?

If they are then I'd cache the resultant image for each day in a known directory, so you can just serve up an image file as opposed to getting PHP to go through the loop each time it runs.

That or just disable it if your server load goes over a certain number with a polite message and perhaps just an image of today's puzzle sheet?

-=-=-
Web / Game Dev, occasionally finishes off coding games also!

Refresh Games - Game Dev Blog
Posted : Tuesday, 19 May 2020, 10:14
Jayenkai
Caching of each puzzle, done already.
But then it loads them orientates them for the requested sheet, pastes them together and outputs the result.
It does also cache those, but not everything..
There are 82 puzzle types, and 8 slots, meaning .. um...



Yeah, I ain't caching all those combinations!!!

-=-=-
''Load, Next List!''
Posted : Tuesday, 19 May 2020, 10:39
rychan
Cool, glad you've got caching going on there, that's good stuffs.

Yeah, that'd be insane, way too much caching!

-=-=-
Web / Game Dev, occasionally finishes off coding games also!

Refresh Games - Game Dev Blog