ActivityPub Etsy when?

@mcc it depends on the font I'm using, because sometimes—like this—I will use an em-dash without spaces, and sometimes – like this – I will use an EN dash with spaces, depending on what I think looks better.

Em dashes with spaces seems superfluous to me in all cases though.

@KuJoe when 4.4 came out I made these Grafana dashboards to connect to Prometheus which were invaluable for troubleshooting database problems I was having: https://github.com/jonaharagon/mastodon-grafana

@KuJoe well, check those timings in the logs with journalctl first, good chance they'll say what's up.

The built-in metrics Mastodon added in 4.4 (iirc) are pretty nice to have in general though.

@KuJoe you're aware Puma's backlog is connections that have been established but not yet processed by something else, and not a backlog of connections right?

What are the requests waiting for when they're in this queue? Like, if you look at the logs for the mastodon-web service, each line should include something like: duration=5.78 view=0.00 db=1.27

Do you have Prometheus metrics enabled?

@KuJoe oh, if you have pgBouncer already then that is good. I see... where are you getting this backlog number from?

@KuJoe 1500 connection limit?

I have double your active users running on under 30 direct postgres connections most of the time. WEB_CONCURRENCY=24 and MAX_THREADS=15 (this is specific to my 44 CPU core count that I'm also sharing with Sidekiq and Postgres on the same machine, hence 24, don't overdo it...)

This might be over-explaining, but this is my setup:

1. You need to install pgBouncer https://docs.joinmastodon.org/admin/scaling/#pgbouncer

I have max_client_conn = 10000 and default_pool_size = 30 and reserve_pool_size = 120 set in pgbouncer.ini

This allows practically unlimited connections from Mastodon, but only 30 will be opened with postgres. It will scale up to 150 if absolutely required but that very rarely ever happens.

2. You should set max connections in Postgres itself to 200 and check https://pgtune.leopard.in.ua again.

Use OLTP instead of Web as the DB type. If your DB is on the same server as Mastodon don't just enter your total core count and RAM, enter only what you want dedicated to Postgres (so... probably about half).

Some settings depend on what max connections is, so if you ran pgTune before and then increased it they're probably wrong, best to double-check them all.

3. Profit

@WhoDisturbsMySlumber https://mastodon.neat.computer/@jonah/115973482132687933

Yes that seems plausible

@3dcandy https://mastodon.neat.computer/@jonah/115973482132687933

@dtwx https://mastodon.neat.computer/@jonah/115973482132687933

I think some are still missing the point. I’m not saying they’re going to lock up every single person who uses a VPN or watches porn.

Your government’s strategy is to make “crimes” like this as common and easy to commit as possible.

This way, if you ever do something completely legal which they *actually* don’t like, *which can be completely unrelated to VPNs or bypassing age verification,* they can pull up your internet history and easily prosecute you.

Organize a legitimate protest, and the government’s swift response will be to label you a child sex offender because they found you using evil VPN technology.

This is how free speech dies, not from a law that says “free speech is dead now,” but from draconian, authoritarian laws like this that give the government “plausible” reasons to go after anyone, which can’t easily be fought against.

This has always been the playbook to target innocents. In the USA, drug possession laws being created as a pretense for cops to raid and dismantle minority communities, for example. And now this is coming to the digital realm.

@paul nice you found the loophole, us tech guys always win after all

RE: https://mastodon.thenewoil.org/@thenewoil/115971195227745876

Next up will be a VPN ban. Many tech-y people will see that and think “lol yeah well that’s not going to stop *me* from using a VPN”

A VPN ban isn’t really meant stop you from using one. It means when they catch you doing so, they’ll use the fact you’re using this harmless technology itself as a *pretense* to lock you up without needing to do any “hard work” (i.e. an investigator’s job) like actually confirming whether you committed a real crime.

Don’t think you won’t be impacted just because you know how to outsmart an ISP filter! This is not a plan to protect children or stop you from consuming adult media. It is a ploy to eventually eliminate ALL freedom of expression and free access to information in the UK.

And the same goes for Chat Control and encrypted messengers, btw

#UKpol #VPNban #PornHub #ChatControl #Privacy #FreeSpeech #SocialMedia