A Phlaming Phoenix

  • 0 Posts
  • 19 Comments
Joined 1 year ago
cake
Cake day: June 19th, 2023

help-circle





  • I use the term “queer” to describe myself because my sexual identity (which is something like bisexual or pansexual) and my neurodivergence have made me something of a cultural outcast throughout most of my life. I don’t really “fit in” with most people, and “queer” describes that experience pretty succinctly.

    To the person you are responding to, I am cautious about using this word too broadly because some people have specific trauma around this word. Bigots often wield the word like a weapon, so people who are subjected to that and don’t have adequate supports to deal with that trauma can get offended by it. I don’t think we should so flippantly dismiss that. It works for me. It doesn’t work for others.




  • To build on this (and I also use Postgres, so I’m assuming MySQL/MariaDB are similar), there is almost certainly a metric emitted by the DBs that can tell you how long that lag is between initial write and replica updates. That would be the thing to monitor to detect the specific problem where replication lag creates application lag.

    Also worth mentioning that horizontal scaling can solve some problems, but there are a few major configuration items to check that will improve performance across all the replicas. Off the cuff:

    • Properly index your tables
    • Build on hardware big enough to keep indexed data in memory
    • Don’t use the MyISAM engine with MySQL since it has a bunch of performance and locking problems. Upgrade to InnoDB.
    • Optimize your queries. Horizontal scaling won’t give you much improvement if you’re doing full table scans or something like that. ORMs can produce some pretty ugly SQL sometimes. Consider writing your own queries that are better optimized to make use of your indices.



  • Not OP but I think they meant supporters of neoliberal economic policy and somewhat progressive social policies. “Liberal” like American liberal politics. The point being that they think they have good politics because they think trans people are people and aren’t the kind of right wing fanatic we get a lot of. They’re “left” to the extent that the American political spectrum allows for without understanding what “left” actually means, without being conscious of the overarching machinations that make then think their politics are good even as they continue to feed a system that intentionally blinds them to any honest criticism.


  • A lot has been said already, but it’s worth mentioning that modern guns are much more capable of killing than guns 200 years ago. Back then, guns were very inaccurate and had to be reloaded one shot at a time and packed by hand. Now we have automatic weapons with large magazines that can be swapped out in seconds. They have less recoil and greater accuracy. Regardless of cultural and political issues, guns are just more capable of killing than they used to be.






  • This dilution of content is really the issue. If Netflix still had the movies I want to watch, I’d just use it. Netflix is easier than piracy.

    But Netflix doesn’t ever have what I want to watch anymore. Now those movies are scattered across half a dozen other services that each cost $15/month. It’s a pain to figure out what’s streaming where and if it will cost me anything extra on top of my monthly dues. As Gabe Newell said, it’s a service problem.

    Piracy gets you more centralized access to more content for free. If you’re behind a VPN or use a private tracker (or both) it’s safe. So why spend all my money on Netflix and Hulu and Prime and Disney and Max and whatever else just to have a fifty/fifty chance that one of them might be streaming the movie I want to watch?


  • This would run counter to the principle that lemmy should remain detached from corporate control, though. Especially considering most places (in the US anyway) live under ISP monopoly. Comcast/NBC would end up owning like 40% of lemmy.

    I predict corporate interests trying to run their own lemmy, branding it as something else, extending it to include features they don’t push back to the upstream projects, then federating with other instances to maximize the amount of user data that can be collected.