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
RoundSparrow@lemmy.mlM · edit-21 year agonginx 500 errors to lemmy_ui webapp users, 0.17.4 eraplus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squarenginx 500 errors to lemmy_ui webapp users, 0.17.4 eraplus-squareRoundSparrow@lemmy.mlM · edit-21 year agomessage-square0fedilink
RoundSparrow@lemmy.mlM · edit-21 year agoLemmy server admins, please enable pg_stat_statements on your PostgreSQL server so the Lemmy community can better identify the performance problems on the more active sitesplus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareLemmy server admins, please enable pg_stat_statements on your PostgreSQL server so the Lemmy community can better identify the performance problems on the more active sitesplus-squareRoundSparrow@lemmy.mlM · edit-21 year agomessage-square0fedilink
RoundSparrow@lemmy.mlM · 1 year agoPostgreSQL "activity" table grows large: Configurable Activity Cleanup Duration · GitHub Issue #3103 · LemmyNet/lemmyplus-squaregithub.comexternal-linkmessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1external-linkPostgreSQL "activity" table grows large: Configurable Activity Cleanup Duration · GitHub Issue #3103 · LemmyNet/lemmyplus-squaregithub.comRoundSparrow@lemmy.mlM · 1 year agomessage-square0fedilink
RoundSparrow@lemmy.mlM · 1 year agoDeleting a user with lots of comments (1,59k) modding a few large communities (~20) kills the backend · Github Issue #3165 · LemmyNet/lemmyplus-squaregithub.comexternal-linkmessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1external-linkDeleting a user with lots of comments (1,59k) modding a few large communities (~20) kills the backend · Github Issue #3165 · LemmyNet/lemmyplus-squaregithub.comRoundSparrow@lemmy.mlM · 1 year agomessage-square0fedilink
RoundSparrow@lemmy.mlM · 1 year agoScaling federation · GitHub Issue #3062 · LemmyNet/lemmyplus-squaregithub.comexternal-linkmessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1external-linkScaling federation · GitHub Issue #3062 · LemmyNet/lemmyplus-squaregithub.comRoundSparrow@lemmy.mlM · 1 year agomessage-square0fedilink
RoundSparrow@lemmy.mlM · edit-21 year agoProposal: Lemmy incoming federation data, queue to database INSERT into comments, votes and other large tablesplus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squareProposal: Lemmy incoming federation data, queue to database INSERT into comments, votes and other large tablesplus-squareRoundSparrow@lemmy.mlM · edit-21 year agomessage-square0fedilink
RoundSparrow@lemmy.mlM · 1 year agowebapp performance concern - option for admins (and users?) to turn off home page right-column "trending communities" and "subscribed communities"plus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squarewebapp performance concern - option for admins (and users?) to turn off home page right-column "trending communities" and "subscribed communities"plus-squareRoundSparrow@lemmy.mlM · 1 year agomessage-square0fedilink
RoundSparrow@lemmy.mlM · 1 year agoDatabase: Large amount of timeouts observed no matter how large pool_size is or max_connections. · GitHub Issue #3112 · LemmyNet/lemmyplus-squaregithub.comexternal-linkmessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1external-linkDatabase: Large amount of timeouts observed no matter how large pool_size is or max_connections. · GitHub Issue #3112 · LemmyNet/lemmyplus-squaregithub.comRoundSparrow@lemmy.mlM · 1 year agomessage-square0fedilink
RoundSparrow@lemmy.mlM · 1 year agoScheduled tasks create database deadlocks when running multiple loadbalanced lemmy_server processes · GitHub Issue #3076 · LemmyNet/lemmyplus-squaregithub.comexternal-linkmessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1external-linkScheduled tasks create database deadlocks when running multiple loadbalanced lemmy_server processes · GitHub Issue #3076 · LemmyNet/lemmyplus-squaregithub.comRoundSparrow@lemmy.mlM · 1 year agomessage-square0fedilink
RoundSparrow@lemmy.mlM · 1 year agoPostgreSQL for Lemmy instance installers/operators/upgradersplus-squaremessage-squaremessage-square0fedilinkarrow-up11arrow-down10
arrow-up11arrow-down1message-squarePostgreSQL for Lemmy instance installers/operators/upgradersplus-squareRoundSparrow@lemmy.mlM · 1 year agomessage-square0fedilink
