@support Is the server down just now as I can’t login or see it on the web ?

    • BitOneZero @ .world@lemmy.world
      link
      fedilink
      arrow-up
      3
      ·
      1 year ago

      lemmy internally has SQL flaws that have not gotten much attention. A few days ago, over the weekend, lemmy.ca people studied some of the SQL and exposed a problem where every single new comment and new post on a local server updates 1500 rows in a database table where it should be updating just 1. There have been similar runaway SQL statements discovered. Fixes for the most recent issue are already on GitHub waiting for merge and publication.

      • Wren@sopuli.xyz
        link
        fedilink
        English
        arrow-up
        3
        ·
        1 year ago

        Not sure if there’s a tangible gain to be had (apart from if it were Reddit interfering), but some people just enjoy being jerks simply for the sake of being jerks. Look at the whole The Lizard Squad situation with Xbox and Playstation awhile back, there was no reason, they just wanted to upset people for the hell of it