I have a bunch of nodes and tested runtime of vacuuming the databases in-place against copying them to a ramdisk, vacuuming them there, and moving them back to the disk. The results are quite impressive. The orders database takes the overwhelming majority of the time so I’m including its size befo…

What is the purpose behind such a combative reply when all I did is share information about what happened on my own nodes? Please back off a bit. [image] direktorn: What would be the real impact on a node? Less downtime… means more uptime. Which is good for obvious reasons. You can’t earn…

[image] cdhowie: What is the purpose behind such a combative reply Are you saying I don’t have the right to have an opinion? Perfect

Thanks. I Just ran a modified version of your in place script. It finished pretty fast but my DBs are not very old and I had defraged them recently also. I had planned to eventually vacuum them one at a time when I got bored enough but this script made it easy to do them all at once.

[image] direktorn: Are you saying I don’t have the right to have an opinion? Not at all, but creating a strawman (“You also assume your HDs are a benchmark for all SNOs”) and then attacking that is rude and fallacious. I never set out to prove anything, only provide information about what ha…

Alexy decided to split some comments, making it even a more mess.

Spaghetti forum-ing… Organization of threads is a tough job. Frankly, I’m impressed with the management job here.

The split comments were questioning whether vacuuming is even necessary, while this topic is about vacuuming the databases in a ramdisk to make the vacuum process faster. They didn’t belong in this thread.

Someone told me that vacuum is built into the latest version so its no longer manually necessary - is this accurate information?

For Vacum DB on windows GUI I recomend SQL Browser it can vacum, db with normal human interface, no scripts, also can make integrity checks.

I’m not sure why I can’t edit the original post anymore (ping @Alexey ) but the ramdisk-vacuum script is dangerous and needs to be fixed. If stopping the storagenode container times out, one or more WALs may still exist. This is not currently accounted for in the script and this causes two very bad …

Storj Community Forum (official)

Vacuum databases in a ramdisk to reduce downtime

Node Operators

database, storagenode

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled