@jonah I didn’t realize that, I guess that makes sense why my changes to the web service don’t impact it. I don’t have Prometheus metrics enabled because I found it extremely confusing. I guess I should look into enabling that to help track down the bottleneck?

@jonah I enabled stats on the puma service and monitor it with a PHP script that generates alerts when the backlog number gets higher than 1000.

@jonah I’ve been using pgbouncer and it’s been basically magic since running it, I didn’t think it was a database issue because PgHero rarely shows over 50 connections but my web connections (puma) will hit over 1000 active a few times an hour now, sometimes queuing up 10-40k backlogs.

I never had this issue with >30k active users so something must have changed recently with my user activity.

Looking for some advice from #MastodonAdmins

What setting do you have WEB_CONCURRENCY and MAX_THREADS for your puma (mastodon-web) service?

I’ve set it 50 and 20 respectively for a pool of 1000 web processes, but I’ve been getting constant overloading with tens of thousands of backlogged connections.

Do I need to adjust the mastodon-streaming service settings also? I increased my database connection limit to 1500 to handle the connections plus extras.

Any ideas?

#mastodonadmin #sysadmin #mastoadmin

And another free Steam key!

#keydropt #steamkey #freesteamkey

https://keydropt.com/redeem.php?id=79864acf31c110f82bab8fc1e05123c4