Embed Notice

HTML Code

<blockquote style="position: relative; padding-left: 55px;"><section><a href="https://mastodon.ar.al/users/aral/statuses/110745828476152774">Aral Balkan (aral@mastodon.ar.al)'s status on Thursday, 20-Jul-2023 19:01:27 JST</a><a href="https://mastodon.ar.al/@aral" title="aral@mastodon.ar.al"><img src="https://gnusocial.jp/avatar/4627-48-20250615202325.webp" width="48" height="48" alt="Aral Balkan" style="position: absolute; left: 0; top: 0;">Aral Balkan</a><div><ul><li></ul></div></section><article><p>The latest Mastodon single-person instance performance/scaling issue:</p><p>350+ queries to the database each taking over 2 seconds each basically every time I post something. 👀 </p><p>Very odd.</p><p>(In case you wonder why you can’t reach my instance after I post sometimes.)</p><p>The lovely <a href="https://toot.io/@jan">@jan</a> is on it and opened an issue (<a href="https://github.com/mastodon/mastodon/issues/25949" rel="nofollow noreferrer">https://github.com/mastodon/mastodon/issues/25949</a>) but there doesn’t seem to be much progress yet.</p><p>Looks like my account is a good canary in the coalmine for this stuff :)</p><p><a href="https://mastodon.ar.al/tags/mastodon" rel="tag">#mastodon</a> <a href="https://mastodon.ar.al/tags/scaling" rel="tag">#scaling</a> <a href="https://mastodon.ar.al/tags/performance" rel="tag">#performance</a></p></article><footer><a rel="bookmark" href="https://gnusocial.jp/conversation/1821286#notice-3572280">In conversation</a><time datetime="2023-07-20T19:01:27+09:00" title="Thursday, 20-Jul-2023 19:01:27 JST">Thursday, 20-Jul-2023 19:01:27 JST</time> <span>from <span><a href="https://mastodon.ar.al/@aral/110745828476152774" rel="external" title="Sent from mastodon.ar.al via ActivityPub">mastodon.ar.al</a></span></span><a href="https://mastodon.ar.al/@aral/110745828476152774">permalink</a><h4>Attachments</h4><ol><li><article><header><div>Domain not in remote thumbnail source whitelist: opengraph.githubassets.com</div><h5><a href="https://github.com/mastodon/mastodon/issues/25949">Hundreds of slow queries after posting to 40k followers · Issue #25949 · mastodon/mastodon</a></h5><div></div></header><div>Steps to reproduce the problem Publish a post to 40k followers on a 6 year old instance. Expected behaviour Sidekiq should process the publishing jobs in background. Actual behaviour UI freezes for...</div><footer></footer></article></li></ol></footer></blockquote>

Corresponding Notice

Embed this notice
Aral Balkan (aral@mastodon.ar.al)'s status on Thursday, 20-Jul-2023 19:01:27 JSTAral Balkan
- Jan
The latest Mastodon single-person instance performance/scaling issue:
350+ queries to the database each taking over 2 seconds each basically every time I post something. 👀
Very odd.
(In case you wonder why you can’t reach my instance after I post sometimes.)
The lovely @jan is on it and opened an issue (https://github.com/mastodon/mastodon/issues/25949) but there doesn’t seem to be much progress yet.
Looks like my account is a good canary in the coalmine for this stuff :)
#mastodon #scaling #performance
In conversationThursday, 20-Jul-2023 19:01:27 JST from mastodon.ar.alpermalink
Attachments
1. Domain not in remote thumbnail source whitelist: opengraph.githubassets.com
  Hundreds of slow queries after posting to 40k followers · Issue #25949 · mastodon/mastodon
  Steps to reproduce the problem Publish a post to 40k followers on a 6 year old instance. Expected behaviour Sidekiq should process the publishing jobs in background. Actual behaviour UI freezes for...

Public

Embed Notice

HTML Code

Corresponding Notice