RoundSparrow @ .ee@lemm.ee • 1 year agoRedis, Memcached, dragonfly for Lemmy and 2010 presentation on scaling....plus-squaremessage-squaremessage-square0 fedilinkarrow-up11
arrow-up11message-squareRedis, Memcached, dragonfly for Lemmy and 2010 presentation on scaling....plus-squareRoundSparrow @ .ee@lemm.ee • 1 year agomessage-square0 Commentsfedilink
RoundSparrow@lemmy.mlM • 1 year agopost inclusion, a solid WHERE clause filter before any JOIN on SELECT post (listing of posts)message-squaremessage-square0 fedilinkarrow-up11
arrow-up11message-squarepost inclusion, a solid WHERE clause filter before any JOIN on SELECT post (listing of posts)RoundSparrow@lemmy.mlM • 1 year agomessage-square0 Commentsfedilink
RoundSparrow@lemmy.mlM • edit-21 year agoLemmy Server Performance, PostgreSQL log_min_duration_statement - can big servers share logs? value 2500ms targeting "slow queries"plus-squaremessage-squaremessage-square0 fedilinkarrow-up11
arrow-up11message-squareLemmy Server Performance, PostgreSQL log_min_duration_statement - can big servers share logs? value 2500ms targeting "slow queries"plus-squareRoundSparrow@lemmy.mlM • edit-21 year agomessage-square0 Commentsfedilink
RoundSparrow@lemmy.mlM • edit-21 year agoCode to Stress Test Lemmy for performanceplus-squaremessage-squaremessage-square0 fedilinkarrow-up11
arrow-up11message-squareCode to Stress Test Lemmy for performanceplus-squareRoundSparrow@lemmy.mlM • edit-21 year agomessage-square0 Commentsfedilink
RoundSparrow@lemmy.mlM • edit-21 year agoHow lemmy.ca took on finding why PostgreSQL was at 100% CPU and crashing the Lemmy website this past weekend. PostgreSQL auto_explainplus-squaremessage-squaremessage-square0 fedilinkarrow-up11
arrow-up11message-squareHow lemmy.ca took on finding why PostgreSQL was at 100% CPU and crashing the Lemmy website this past weekend. PostgreSQL auto_explainplus-squareRoundSparrow@lemmy.mlM • edit-21 year agomessage-square0 Commentsfedilink
RoundSparrow@lemmy.mlM • 1 year agoLemmy Server optimization of PostgreSQL by focusing on community ownership of a post - and visibility of a post in a single control field. Also local flag transition to instance_id field, with value 1plus-squaremessage-squaremessage-square0 fedilinkarrow-up11
arrow-up11message-squareLemmy Server optimization of PostgreSQL by focusing on community ownership of a post - and visibility of a post in a single control field. Also local flag transition to instance_id field, with value 1plus-squareRoundSparrow@lemmy.mlM • 1 year agomessage-square0 Commentsfedilink
RoundSparrow@lemmy.mlM • edit-21 year agoLemmy Server Performance - is this Rust code reading the entire table of all site languages? Does it need to?plus-squaremessage-squaremessage-square0 fedilinkarrow-up11
arrow-up11message-squareLemmy Server Performance - is this Rust code reading the entire table of all site languages? Does it need to?plus-squareRoundSparrow@lemmy.mlM • edit-21 year agomessage-square0 Commentsfedilink
RoundSparrow@lemmy.mlM • edit-21 year agoLemmy Server Performance, two birds with one stone, mass deletes of content: Account Delete, Community Delete, User Ban - moving these operations to a linear queue and add undo support / grace periodplus-squaremessage-squaremessage-square0 fedilinkarrow-up11
arrow-up11message-squareLemmy Server Performance, two birds with one stone, mass deletes of content: Account Delete, Community Delete, User Ban - moving these operations to a linear queue and add undo support / grace periodplus-squareRoundSparrow@lemmy.mlM • edit-21 year agomessage-square0 Commentsfedilink
RoundSparrow@lemmy.mlM • edit-21 year agoLemmy Server and language choices on every individual comment, many rows in the database per-community, per-site, etc. Overheard of a comment INSERT SQLplus-squaremessage-squaremessage-square0 fedilinkarrow-up11
arrow-up11message-squareLemmy Server and language choices on every individual comment, many rows in the database per-community, per-site, etc. Overheard of a comment INSERT SQLplus-squareRoundSparrow@lemmy.mlM • edit-21 year agomessage-square0 Commentsfedilink
RoundSparrow@lemmy.mlM • edit-21 year agoREQUEST community review of Lemmy Server Performance on Post Votes, Comment Votes - the most frequent database writes. Optimize?plus-squaremessage-squaremessage-square0 fedilinkarrow-up11
arrow-up11message-squareREQUEST community review of Lemmy Server Performance on Post Votes, Comment Votes - the most frequent database writes. Optimize?plus-squareRoundSparrow@lemmy.mlM • edit-21 year agomessage-square0 Commentsfedilink
RoundSparrow@lemmy.mlM • edit-21 year agoGREAT NEWS about Lemmy Server Performance, another major SQL mistake has been discovered today: every single comment & post create (INSERT) is updating ~1700 rows in the site_aggregates tableplus-squaremessage-squaremessage-square0 fedilinkarrow-up11
arrow-up11message-squareGREAT NEWS about Lemmy Server Performance, another major SQL mistake has been discovered today: every single comment & post create (INSERT) is updating ~1700 rows in the site_aggregates tableplus-squareRoundSparrow@lemmy.mlM • edit-21 year agomessage-square0 Commentsfedilink
RoundSparrow@lemmy.mlM • 1 year agoLemmy scaling/performance: Move expensive PostgreSQL triggers to scheduled jobs. · GitHub Issue #3528 · LemmyNet/lemmyplus-squareexternal-linkmessage-square0 fedilinkarrow-up11
arrow-up11external-linkLemmy scaling/performance: Move expensive PostgreSQL triggers to scheduled jobs. · GitHub Issue #3528 · LemmyNet/lemmyplus-squareRoundSparrow@lemmy.mlM • 1 year agomessage-square0 Commentsfedilink
RoundSparrow@lemmy.mlM • 1 year agoInformation Overload - Beehaw style - Beehawexternal-linkmessage-square0 fedilinkarrow-up11
arrow-up11external-linkInformation Overload - Beehaw style - BeehawRoundSparrow@lemmy.mlM • 1 year agomessage-square0 Commentsfedilink
RoundSparrow@lemmy.mlM • 1 year agolemmy_server Rust code now exposes internal metrics via Prometheus endpointplus-squareexternal-linkmessage-square0 fedilinkarrow-up11
arrow-up11external-linklemmy_server Rust code now exposes internal metrics via Prometheus endpointplus-squareRoundSparrow@lemmy.mlM • 1 year agomessage-square0 Commentsfedilink
RoundSparrow@lemmy.mlM • edit-21 year agoBig Lemmy server lemmy.world has put into production critical performance fixes from a runaway SQL query identified by analyzing pg_stat_statements output - and greatly reduced their server overload!plus-squareexternal-linkmessage-square0 fedilinkarrow-up11
arrow-up11external-linkBig Lemmy server lemmy.world has put into production critical performance fixes from a runaway SQL query identified by analyzing pg_stat_statements output - and greatly reduced their server overload!plus-squareRoundSparrow@lemmy.mlM • edit-21 year agomessage-square0 Commentsfedilink
RoundSparrow@lemmy.mlM • 1 year agolemmy PERFORMANCE CRISIS: Rust code in pull requests is starting to use moka caching crateplus-squaremessage-squaremessage-square0 fedilinkarrow-up11
arrow-up11message-squarelemmy PERFORMANCE CRISIS: Rust code in pull requests is starting to use moka caching crateplus-squareRoundSparrow@lemmy.mlM • 1 year agomessage-square0 Commentsfedilink
RoundSparrow@lemmy.mlM • edit-21 year agoLemmy PERFORMANCE CRISIS: popular instances with many remote instances following big communities could stop federating outbound for Votes on comments/posts - code path identifiedplus-squaremessage-squaremessage-square0 fedilinkarrow-up11
arrow-up11message-squareLemmy PERFORMANCE CRISIS: popular instances with many remote instances following big communities could stop federating outbound for Votes on comments/posts - code path identifiedplus-squareRoundSparrow@lemmy.mlM • edit-21 year agomessage-square0 Commentsfedilink
RoundSparrow@lemmy.mlM • edit-21 year agoPERFORMANCE OPTIMIZATION: lemmy_server Rust code all over database lookup: "= LocalSite::read"plus-squaremessage-squaremessage-square0 fedilinkarrow-up11
arrow-up11message-squarePERFORMANCE OPTIMIZATION: lemmy_server Rust code all over database lookup: "= LocalSite::read"plus-squareRoundSparrow@lemmy.mlM • edit-21 year agomessage-square0 Commentsfedilink
RoundSparrow@lemmy.mlM • 1 year agolemmy.world feedback is that 0.17.4 performs better than 0.18.1 - is this true? What is slower?plus-squaremessage-squaremessage-square0 fedilinkarrow-up11
arrow-up11message-squarelemmy.world feedback is that 0.17.4 performs better than 0.18.1 - is this true? What is slower?plus-squareRoundSparrow@lemmy.mlM • 1 year agomessage-square0 Commentsfedilink
RoundSparrow@lemmy.mlM • 1 year agolemmy_server API for Clients and Federation alike, concurrency self-awareness, load sheding, and self-tuningplus-squaremessage-squaremessage-square0 fedilinkarrow-up11
arrow-up11message-squarelemmy_server API for Clients and Federation alike, concurrency self-awareness, load sheding, and self-tuningplus-squareRoundSparrow@lemmy.mlM • 1 year agomessage-square0 Commentsfedilink