RoundSparrow@lemmy.mlM · 1 year agoLemmy scaling/performance: Move expensive PostgreSQL triggers to scheduled jobs. · GitHub Issue #3528 · LemmyNet/lemmyplus-squaregithub.comexternal-linkmessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1external-linkLemmy scaling/performance: Move expensive PostgreSQL triggers to scheduled jobs. · GitHub Issue #3528 · LemmyNet/lemmyplus-squaregithub.comRoundSparrow@lemmy.mlM · 1 year agomessage-square0fedilink
RoundSparrow@lemmy.mlM · 1 year agoInformation Overload - Beehaw style - Beehawplus-squarebeehaw.orgexternal-linkmessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1external-linkInformation Overload - Beehaw style - Beehawplus-squarebeehaw.orgRoundSparrow@lemmy.mlM · 1 year agomessage-square0fedilink
RoundSparrow@lemmy.mlM · 1 year agolemmy_server Rust code now exposes internal metrics via Prometheus endpointplus-squaregithub.comexternal-linkmessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1external-linklemmy_server Rust code now exposes internal metrics via Prometheus endpointplus-squaregithub.comRoundSparrow@lemmy.mlM · 1 year agomessage-square0fedilink
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-squarelemmy.worldexternal-linkmessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1external-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-squarelemmy.worldRoundSparrow@lemmy.mlM · edit-21 year agomessage-square0fedilink
DreadTowel@lemmy.worldEnglish · 1 year agoDe-facto memory leakplus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareDe-facto memory leakplus-squareDreadTowel@lemmy.worldEnglish · 1 year agomessage-square0fedilink
RoundSparrow@lemmy.mlM · 1 year agolemmy PERFORMANCE CRISIS: Rust code in pull requests is starting to use moka caching crateplus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squarelemmy PERFORMANCE CRISIS: Rust code in pull requests is starting to use moka caching crateplus-squareRoundSparrow@lemmy.mlM · 1 year agomessage-square0fedilink
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-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-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-square0fedilink
RoundSparrow@lemmy.mlM · edit-21 year agoPERFORMANCE OPTIMIZATION: lemmy_server Rust code all over database lookup: "= LocalSite::read"plus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squarePERFORMANCE OPTIMIZATION: lemmy_server Rust code all over database lookup: "= LocalSite::read"plus-squareRoundSparrow@lemmy.mlM · edit-21 year agomessage-square0fedilink
code@lemmy.mayes.ioEnglish · 1 year agoAdmin toolsplus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareAdmin toolsplus-squarecode@lemmy.mayes.ioEnglish · 1 year agomessage-square0fedilink
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-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-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-square0fedilink
RoundSparrow@lemmy.mlM · 1 year agolemmy_server API for Clients and Federation alike, concurrency self-awareness, load sheding, and self-tuningplus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squarelemmy_server API for Clients and Federation alike, concurrency self-awareness, load sheding, and self-tuningplus-squareRoundSparrow@lemmy.mlM · 1 year agomessage-square0fedilink
RoundSparrow@lemmy.mlM · edit-21 year agolemmy-ui seems to be doing database search for Post Title matches while typing every single character or edit, for performance reasons suggest an option to disable this feature be available to adminsplus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squarelemmy-ui seems to be doing database search for Post Title matches while typing every single character or edit, for performance reasons suggest an option to disable this feature be available to adminsplus-squareRoundSparrow@lemmy.mlM · edit-21 year agomessage-square0fedilink
RoundSparrow@lemmy.mlM · edit-21 year agoAdd http cache for webfingers by cetra3 · Pull Request #3317 · LemmyNet/lemmy (adding moka as an in-memory cache to Rust code)plus-squaregithub.comexternal-linkmessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1external-linkAdd http cache for webfingers by cetra3 · Pull Request #3317 · LemmyNet/lemmy (adding moka as an in-memory cache to Rust code)plus-squaregithub.comRoundSparrow@lemmy.mlM · edit-21 year agomessage-square0fedilink
phiresky@lemmy.world · 1 year agoHigh CPU usage? How to profile Lemmy server process CPU usageplus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareHigh CPU usage? How to profile Lemmy server process CPU usageplus-squarephiresky@lemmy.world · 1 year agomessage-square0fedilink
RoundSparrow@lemmy.mlM · edit-21 year agoLemmy Server - full text real-time searching of all comments&posts is a performance concern. Might have worked when lemmy database was low on content.plus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareLemmy Server - full text real-time searching of all comments&posts is a performance concern. Might have worked when lemmy database was low on content.plus-squareRoundSparrow@lemmy.mlM · edit-21 year agomessage-square0fedilink
RoundSparrow@lemmy.mlM · 1 year agoLemmy's Rust code - interfacing to PostgreSQL, http methods for federation connections inbound and outboundplus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareLemmy's Rust code - interfacing to PostgreSQL, http methods for federation connections inbound and outboundplus-squareRoundSparrow@lemmy.mlM · 1 year agomessage-square0fedilink
vapeloki@lemmy.mlEnglish · 1 year agoLemmy Benchmarking - Working on toolingplus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareLemmy Benchmarking - Working on toolingplus-squarevapeloki@lemmy.mlEnglish · 1 year agomessage-square0fedilink
RoundSparrow@lemmy.mlM · edit-21 year agoLemmy PostgreSQL performance: comment_like & post_like tables have a lot of indexes (5 alone on comment_like), SQL INSERT is taking 0.4 seconds per upvote. Federation incoming lower priority?plus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareLemmy PostgreSQL performance: comment_like & post_like tables have a lot of indexes (5 alone on comment_like), SQL INSERT is taking 0.4 seconds per upvote. Federation incoming lower priority?plus-squareRoundSparrow@lemmy.mlM · edit-21 year agomessage-square0fedilink
RoundSparrow@lemmy.mlM · 1 year agoI suspect the widespread Federation problems and 'nginx 500' errors are connected, Lemmy is swarming comments, likes to other Lemmy servers and causing a Denial of Service on peersplus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareI suspect the widespread Federation problems and 'nginx 500' errors are connected, Lemmy is swarming comments, likes to other Lemmy servers and causing a Denial of Service on peersplus-squareRoundSparrow@lemmy.mlM · 1 year agomessage-square0fedilink
RoundSparrow@lemmy.mlM · 1 year ago[Architecture] Scaling federation throughput via message queues and workers · Issue #3230 · LemmyNet/lemmyplus-squaregithub.comexternal-linkmessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1external-link[Architecture] Scaling federation throughput via message queues and workers · Issue #3230 · LemmyNet/lemmyplus-squaregithub.comRoundSparrow@lemmy.mlM · 1 year agomessage-square0fedilink
