Xanza

joined 6 months ago
MODERATOR OF
[–] Xanza@lemm.ee 20 points 3 months ago* (last edited 3 months ago) (7 children)

All the stackoverflow answers lead to - its complex. read a 2000 page book.

This is an exceptionally good answer and you're doing everything possible to avoid doing it, when you could have been half way done with the book by now probably. Database administration is a profession, not a job. It requires specialized training to do it well and doing everything possible to avoid that training and knowledge won't help you one bit.

my queries are not that complex.

It doesn't matter. Your database is very complex.

they simply go through the whole table to identify any duplicates

You search 10 million records on every request and you wonder why it's slow?

is there a wizard move to bypass any of my restriction or is a change in the setup and algorithm inevitable?

No. Database administration is very difficult. Reading that 2000 page book is essential for setting up infrastructure to avoid a monolithic setup like this in the first place.

the other culprit is that our server runs on a HDD which is with 150mb read and write per second probably on its edge.

lol wtf

Realistically, this setup is 10 years too old. How large is your database? Is there any reason why it can't be run in memory? 10 million lines isn't insurmountable. Full text with a moderate number of tables could be ~10GB--no reason that can't be run in memory with Redis or other in-memory database or to update to a more modern in-memory database solution like Dice.

Your biggest problem is the lack of deduplication and normalization in your database design. If it's not fixed now, it'll simply get worse YOY until it's unusable. Either spend the time and money now, or spend even more time and money later to fix it. 🤷‍♂️

tl;dr: RTFM.

[–] Xanza@lemm.ee 1 points 3 months ago

VMs become really slow and laggy as soon as my SabNZBd starts downloading something

Because you're saturating your connection. lol.

[–] Xanza@lemm.ee -1 points 3 months ago (3 children)

No other solution exists that is as easy as Plex and as secure as Plex.

Entrenchment. This is a profoundly absurd statement.

I paid like $100 for a lifetime Plex Pass like 10 years ago.

You paid $100 to access software hosted on your own devices. That's wonderful you think that's a great idea. I'm sure the Plex devs love you and would kiss you right on the mouth.

They sign in and they can stream from everyones libraries. No VPNs needed, no other hoops.

Because you're vendor locked in.. lol.

[–] Xanza@lemm.ee 0 points 3 months ago (1 children)

But paying for the ongoing maintenance of software isn’t some evil thing, even if I self host it.

But that's not what you're paying for. You're paying for access to that software...

[–] Xanza@lemm.ee 1 points 3 months ago (4 children)

Yes. There are several recent instances where he's "slamming" Israel. And then 3 decades where they're best friends, including up to the end of 2024....

[–] Xanza@lemm.ee 1 points 3 months ago* (last edited 3 months ago) (1 children)

Syncplay requires adequate hardware and network. Especially if you're transcoding at the same time. You're transcoding for 2 people at once, and depending on your setup sending to each person at different rates. It's hard to coordinate that.

[–] Xanza@lemm.ee 1 points 3 months ago

But she fed the troll anyways by telling him to fuck off... These people feed on attention and she gave them a significant amount. Way way way more than he was hoping for with a seemingly innocuous comment.

[–] Xanza@lemm.ee 32 points 3 months ago (6 children)

Two things can be true.

I know a lot of women who didn't vote for her because she was a woman. Shit is crazy to me, but that doesn't mean it's not the reality. I'm sure there are a shocking number of people who didn't vote for her because she's a woman.

[–] Xanza@lemm.ee 6 points 3 months ago (5 children)

This is the ideal progressive ticket, IMO. It's not as scary for the mid as having a female President (grow the fuck up, guys), but she'll still be able to provide her support and opinion far above her current station. People seem to really like Tim, which is great.

But in the end none of it matters. They're all historically pro-Israel and people don't forget that. They've begun to change their tune, but only just now. It seems disingenuous to get votes, which just seems...hollow.

[–] Xanza@lemm.ee 17 points 3 months ago* (last edited 3 months ago) (7 children)

There are two schools of thought, and one of them is insanely wrong.

The current preferred method (by youngins) for pirating is by using a VPN provider to "hide" your torrent traffic, which is generally valid, but it's not a silver bullet and it's a wrong way to think.

The other is to use a seedbox, which is a remote server hosted in a country that doesn't recognize piracy as a crime to begin with...

The choice is clear. Especially when you consider to get a good private VPN you'll have to pay $5-10/mo. You may as well pay $5-10/mo to commit a crime where no one thinks its a crime, then you never have to worry about it. Using a VPN you can still get caught, it's just exceptionally rare because conditions have to line up perfectly. But what if your VPN is down, and you accidentally begin a download? You willing to get a $100,000 fine for that?

Just use a damn seedbox.

[–] Xanza@lemm.ee 2 points 3 months ago

Singapore, but for what reason they didn’t explain well to me.

Fast internet speeds, and generally they don't give a fuck about American IP, although that's beginning to change.

[–] Xanza@lemm.ee 2 points 3 months ago

Been using FeralHosting for 10 years or so now. A bit more expensive than the rest, but I've had less than 3-4 issues within that whole time and they've always been a reliable provider. Highly recommend them.

view more: ‹ prev next ›