Avatar
grips
f51bfdc8460692883afe8809bf642ec7fef6fc760b30daf8bc2a71120c4830c1
🇸🇰 Admin, retard, legend. 🇸🇰 Music: soundcloud.com/gensogrips + kkons.bandcamp.com RYM: https://rateyourmusic.com/~gensogrips MAL: https://myanimelist.net/profile/gensogrips Japanese practice account: @grips@sushi.ski Russian practice account: @grips@eientei.org :cross_latin_silver2::arch::autism::tedk:

nostr:npub1w4jud2zhl9ztd5pycpzsq9nf07c3vcguavtrc6jypvtd6qealy9sl8cead much of it sounds quite pretty, even somewhat compatible. the biggest difference is, of course, that Holzner discards what has been revealed by God and Jesus and instead professes ignorance. I suspect this was his way of quelling the dissonance between Catholic Christianity and National Socialism, rather than simple disbelief. I know that I'd also be similarly torn as a German in those times, so I'll refrain from any harsher judgements

up until late about december 2022 we were battling the database server being at 100% load 24/7. turns out you need to actively be repacking your database at least weekly. taking it down and doing a full vacuum helps, but the repack allows you to do it while it’s online.

that being said, there are still some things in pleroma that cause major database issues that i’ve brought up in the past – this for example https://gitlab.com/soapbox-pub/rebased/-/issues/137 – this one particular issue ties up 32-40 database connections at a time, almost 4x what the typical pleroma server has configured for database connections (and would equate to 100% cpu usage on anything <8 threads) for nothing. it’s literally trying to update bookmarks from people who have deleted their accounts or are on instances that are unreachable. its just stupid shit like that

nostr:npub108zt8c43ulvdwnax2txurhhr07wdprl0msf608udz9rvpd5l68ascvdkr5 dang, I didn't know repack was a thing :akaheh:

well i certainly wasn't expecting 30 thousand users. the unfortunate part with pleroma, in specific its database is that it doesn't scale well at all. if you aren't actively maintaining it, your instance with only a handful of people will grind to a halt.

we started poast out on mastodon on a shitty 2c/2gb VPS in January 2021 and garnered 1000 users in only a handful of hours because some friends and i were advertising it on twitter. we outgrew what it was on the first day and ended up moving to a dedicated server that was 50$/mo for a few months. we got up to about 3000 users and outgrew that server (4c/8t 16GB shitty E3 Xeon from dedipath). during this time cloudflare also despite us paying monthly suspended CDN services for us and accused us of "abusing the free tier" so overnight one night poast had all of its images replaced with "User is abusing Cloudflare's Free Tier" or some shit image. so I had to build our own CDN. I started doing that in March of 2021 and had it deployed by the end of the month which initially cost us about 50$ per month but now accounts for a much larger amount. the majority of costs poast incurs is making sure we have the bandwidth we need tbh.

anyway, in march 2021 we moved from that shitty e3 to a dual xeon 24c/48t 64GB dedicated server from a company based in Texas called Spin Servers. this was fine until one day a switch in their backend disabled our 10G network because of a bandwidth overage despite us being unmetered and it happened on a day they decided to take siesta I guess -- wasnt a national holiday or anything but nobody at all was in the office. it was 11 hours before the owner of the company reached out to me to apologize but by then we had already made concessions to move.

at this point because the server was always taxed we decided it was time to split pleroma and the database server -- this is where the jump in cost came from as we were renting a partial rack at another datacenter and had several machines hosted there (still have one that's being used for revolver iirc)

i cut the cost down about 400$ from its peak of about 2400$/mo by switching to where our hardware is now but yeah. thats the history of poast and why it costs so much. tldr multiple servers powering the backend and having to run our own CDN. using something like bunny.net for CDN our costs would be ~4-5k/mo alone

nostr:npub108zt8c43ulvdwnax2txurhhr07wdprl0msf608udz9rvpd5l68ascvdkr5 I see, thanks. was the database size a big problem before the split? that's what's biting me in the ass in the long run

nostr:npub1pt6l3a97fvywrxdlr7j0q8j2klwntng35c40cuhj2xmsxmz696uqfr6mf6 yeah, sums are a nice way to look at it. these approximations seem pretty good, I myself would probably just make a quick python script and then bisect the ratio to come as close as possible. I was just looking for algebraic solutions

nostr:npub108zt8c43ulvdwnax2txurhhr07wdprl0msf608udz9rvpd5l68ascvdkr5 that sucks, sorry

genuine question, what were you expecting at the start? did the costs spiral out way too much?

nostr:npub19640q62askd6gdx7rpsssus6lnqxuh86475ue0la3gjee4j7qguqm2s55q nostr:npub1lareccazvjjjn9x7cprulux8lhlc3n969la32fc96ld68ccjv67qguq5vr Its name is a reference to a scene in the moé anime Is the Order a Rabbit? where two characters argue over the pronunciation of the word "coffee". Of course, the Japanese pronunciation which the anime singles out as "correct" and "well-pronounced" sounds ridiculous to western ears, leading to its status as a meme.

nostr:npub175dlmjzxq6fgswh73qym7epwcll0dlrkpvcd479u9fc3yrzgxrqsjdwrtj The general formula for solving cubic equations is extremely ugly, there's no way around it. The one for quartic equations is even worse. Both formulas are obtained by algebraic manipulations which resemble "completing the square" for quadratic equations.

There is no general formula for equations of degree > 4. (Abel's Impossibility Theorem.) So the fact that explicit formulas exist for degrees <= 4 should be considered a miracle, even if those formulas are ugly.

For your specific equation, I don't see any trick which would give a nicer formula. What do you need it for? For many applications, an approximate algorithm like Taylor expansion or Newton's method would be just as good as an explicit formula.

nostr:npub1pt6l3a97fvywrxdlr7j0q8j2klwntng35c40cuhj2xmsxmz696uqfr6mf6 I see, thanks

>What do you need it for?

honestly just for fun. first I wondered what 2 + 2x + 2x² = 7 would be (just to split up a line segment into nice geometrical ratios, given that we already have a 2/7 segment on it. my geometrical OCD really wanted to know), then I generalized it to 1 + x + x² = z and after that I wondered if we can do this further

nostr:npub19640q62askd6gdx7rpsssus6lnqxuh86475ue0la3gjee4j7qguqm2s55q ah, you mean the domain name? I'm not that good with names, though maybe it was already taken. I don't remember

nostr:npub1pt6l3a97fvywrxdlr7j0q8j2klwntng35c40cuhj2xmsxmz696uqfr6mf6 hey mist, I see you're discussing math again. do you perchance have any experience with cubic equations? I'm wondering about the general solution to 1 + x + x² + x³ = z [z∈R], the wiki page on cubic equations almost had me crying and wolfram vomited out this abortion. surely the real root can't be that ugly

when my paycheck finally comes I'll probably buy a bottle of alcohol and then you'll probably see a resurgence in griposts

each of the Wikipedia articles on the five Orbán governments has a contemporary portrait of Orbán. he's evolving like a Pokémon. amazing

survived a weekend in Budapest