Server Crashes - Printable Version+- Save-Point (https://www.save-point.org)
+-- Forum: Official Area (https://www.save-point.org/forum-3.html)
+--- Forum: Announcements and Updates (https://www.save-point.org/forum-9.html)
+--- Thread:
Server Crashes (/thread-11455.html)Server Crashes - Kirito - 01-01-2025
Over the holidays Save-Point crashed, and I just restarted it to keep it going. I was on vacation. Anyway, I got home, analyzed the problem. Our database had outgrown it's current RAM allocations - so maintenance tasks were causing it to run out of RAM. I looked up the cost of increasing the RAM on the server, and it would run us around double. I then noticed what the default allocation of buffer the server assigns to it's processes. I was able to double that, and it gets us past the issue so the server *should* stop crashing. That said, I can't increase it again with our current available RAM, so next time we outgrow and I need to bump that figure up, we'll have to upgrade the server with more RAM. It's not even like we need that RAM for normal operation, just when we do the normal maintenance tasks to ensure that the database is still healthy and to prevent data corruption because there is just so much data in there now.
RE: Server Crashes - kyonides - 01-02-2025
Just an idea, not saying it's plausible at all, but can't you like set it up to backup certain portions at a time so it doesn't increase RAM consumption way beyond normal?
Yeah, I know. There's a great chance you'll say the system would work as intended if such a plan were in place...
RE: Server Crashes - Kirito - 01-03-2025
(01-02-2025, 01:39 AM)kyonides Wrote: Just an idea, not saying it's plausible at all, but can't you like set it up to backup certain portions at a time so it doesn't increase RAM consumption way beyond normal?
Yeah, I know. There's a great chance you'll say the system would work as intended if such a plan were in place...
I think you completely misunderstood the issue. They do happen when the forum is not busy - this is why so far it has only crashed while no one is using it. The thing I can't do is make it take less memory to perform an operation without stripping the database of half our posts which really isn't an option. And no, I can't just optimize a portion of the database, it doesn't support that kind of slicing.
RE: Server Crashes - Kirito - 01-06-2025
So, database crashed again. I did a table repair upgraded the buffer, now to see what happens.
RE: Server Crashes - Kirito - 01-06-2025
Upgraded the cpu, and doubled the physical ram. hopefully this puts this issue to bed.