Posts: 393
Threads: 35
Joined: Aug 2009
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.
Posts: 4,666
Threads: 559
Joined: Dec 2009
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...
"For God has not destined us for wrath, but for obtaining salvation through our Lord Jesus Christ," 1 Thessalonians 5:9
Maranatha!
The Internet might be either your friend or enemy. It just depends on whether or not she has a bad hair day.
![[Image: SP1-Scripter.png]](https://www.save-point.org/images/userbars/SP1-Scripter.png)
![[Image: SP1-Writer.png]](https://www.save-point.org/images/userbars/SP1-Writer.png)
![[Image: SP1-Poet.png]](https://www.save-point.org/images/userbars/SP1-Poet.png)
![[Image: SP1-PixelArtist.png]](https://www.save-point.org/images/userbars/SP1-PixelArtist.png)
![[Image: SP1-Reporter.png]](https://i.postimg.cc/GmxWbHyL/SP1-Reporter.png)
My Original Stories (available in English and Spanish)
List of Compiled Binary Executables I have published...
HiddenChest &
Roole
Give me a free copy of your completed game if you include at least 3 of my scripts!
Just some scripts I've already published on the board...
KyoGemBoost XP VX & ACE,
RandomEnkounters XP,
KSkillShop XP,
Kolloseum States XP,
KEvents XP,
KScenario XP & Gosu,
KyoPrizeShop XP Mangostan,
Kuests XP,
KyoDiscounts XP VX, ACE & MV,
KChest XP VX & ACE 2016,
KTelePort XP,
KSkillMax XP & VX & ACE,
Gem Roulette XP VX & VX Ace,
KRespawnPoint XP, VX & VX Ace,
GiveAway XP VX & ACE,
Klearance XP VX & ACE,
KUnits XP VX, ACE & Gosu 2017,
KLevel XP,
KRumors XP & ACE,
KMonsterPals XP VX & ACE,
KStatsRefill XP VX & ACE,
KLotto XP VX & ACE,
KItemDesc XP & VX,
KPocket XP & VX,
OpenChest XP VX & ACE
Posts: 393
Threads: 35
Joined: Aug 2009
Yesterday, 05:59 AM
(This post was last modified: Yesterday, 06:00 AM by Kirito.)
(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.
Server Crashes
