A Phlaming Phoenix

  • 1 Post
  • 42 Comments
Joined 1 year ago
cake
Cake day: June 19th, 2023

help-circle














  • 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.




  • The article asks what is the politically neutral answer to the question of whether a trans woman is a woman. I wonder why this is a political question at all. Send like a question for scientists - biologists and sociologists and such. Seems they have achieved something like a consensus on the matter. I don’t see anything inherently political about that, except that folks of a certain political bent have made it political. It’s not a matter of “what do we do in public policy about trans people” but “fascists refuse to accept trans people in society and have decided to lambast and punish them”.

    In case my position isn’t obvious, trans people are people and trans rights are human rights. If there wasn’t a group of people trying to make them into a second class group of citizens (or a group of “eradicated vermin”) we wouldn’t be having a political conversation about this at all.