mastodon.world is one of the many independent Mastodon servers you can use to participate in the fediverse.
Generic Mastodon server for anyone to use.

Server stats:

8.1K
active users

#mastoadmin

50 posts43 participants4 posts today

Tech Note Of The Day (TNOTD):

If you're now on an instance that's been upgraded to the v4.4.* Mastodon distro series, you may want to set your Quote Posts visibility

NOTE: no one can *create* Quote Posts now, this is just in preparation for the v4.5.* distro upgrade

So, at

Preferences (now down at the bottom of the right column) --> Other

find "Who can quote" and set to your preference

I've set mine to "Only your (my) followers"

Note: "This setting will only take effect for posts created with the next Mastodon version, but you can select your preference in preparation."

BE SURE TO SAVE CHANGES

Carry on as you were

Tech Note Of The Day (TNOTD):

If you're now on an instance that's been upgraded to the v4.4.* Mastodon distro series, you may want to set your Quote Posts visibility

NOTE: no one can *create* Quote Posts now, this is just in preparation for the v4.5.* distro upgrade

So, at

Preferences (now down at the bottom of the right column) --> Other

find "Who can quote" and set to your preference

I've set mine to "Only your (my) followers"

Note: "This setting will only take effect for posts created with the next Mastodon version, but you can select your preference in preparation."

BE SURE TO SAVE CHANGES

Carry on as you were

My laziness has led to 1TB of media on Backblaze for my instance.

Guess I should stop being lazy and setup a cron.

But I did setup some monitoring so that is a win (please clap).

Replied in thread

@ai6yr I mentioned to someone yesterday that I've been looking at The Ultimate Nginx Bad Bot Blocker— I just want to make sure it doesn't include Mastodon due to the "DDOS" link preview claims issue.

It claims, "The Ultimate Nginx Bad Bot, User-Agent, Spam Referrer Blocker, Adware, Malware and Ransomware Blocker, Clickjacking Blocker, Click Re-Directing Blocker, SEO Companies and Bad IP Blocker with Anti DDOS System, Nginx Rate Limiting and Wordpress Theme Detector Blocking. Stop and Block all kinds of bad internet traffic even Fake Googlebots from ever reaching your web sites. " #MastoAdmin

github.com/mitchellkrogza/ngin

Nginx Block Bad Bots, Spam Referrer Blocker, Vulnerability Scanners, User-Agents, Malware, Adware, Ransomware, Malicious Sites, with anti-DDOS, Wordpress Theme Detector Blocking and Fail2Ban Jail f...
GitHubGitHub - mitchellkrogza/nginx-ultimate-bad-bot-blocker: Nginx Block Bad Bots, Spam Referrer Blocker, Vulnerability Scanners, User-Agents, Malware, Adware, Ransomware, Malicious Sites, with anti-DDOS, Wordpress Theme Detector Blocking and Fail2Ban Jail for Repeat OffendersNginx Block Bad Bots, Spam Referrer Blocker, Vulnerability Scanners, User-Agents, Malware, Adware, Ransomware, Malicious Sites, with anti-DDOS, Wordpress Theme Detector Blocking and Fail2Ban Jail f...

Ich bräuchte mal eure Hilfe. Meine Instanz, die Embassy, belegt super viel Storage. Das sind hauptsächlich Attachments. Mittlerweile kommen da fast 2 TB zusammen. Es waren sogar über 4 TB bis ich aufgeräumt habe (tootctl media remove und remove-orphaned , auch purge-headers und delete-profiles; days=3). 2 TB finde ich aber immer noch extrem viel. Dadurch wird mein S3 sehr teuer. Letzten Monat kostete der Spaß 40 € bei Wasabi. Was kann ich noch tun um die Belegung und damit die Kosten zu reduzieren? #Mastoadmin Gerne #RT

Our Mastodon :mastodon: instance burningboard.net

Running on energy efficient arm64 CPU (Ampere Altra Q80-30) and just 16GB of RAM in a virtual machine.

Now running on latest Debain Linux 13 :debian: with Linux kernel 6.12.

For that little hardware footprint, it's quite performance, reliable and fast (with over 100 active users).

Just the media files are offloaded to S3 storage at our provider.

Por fin he descubierto, gracias a un post de Reddit, donde están las "etiquetas pendientes de aprobar" que nunca aparecen. Están en Moderación, Etiquetas, y en el desplegable marcas “Revisión solicitada”, ahí están las desgraciadas. #MastoAdmin

Replied to Talya (she/her) 🏳️‍⚧️✡️

@Yuvalne If you have access to the database you could run

SELECT
CONCAT(accounts.username, '@', accounts.domain),
sum(media_attachments.file_file_size)/ 1024 / 1024 as "Total Size (MB)"
FROM
accounts
JOIN media_attachments ON media_attachments.account_id = accounts.id
WHERE media_attachments.file_file_size is not null
GROUP BY
CONCAT(accounts.username, '@', accounts.domain)
ORDER BY
sum(media_attachments.file_file_size) DESC;

to get the list of accounts by total file size.

Or

SELECT
accounts.domain,
sum(media_attachments.file_file_size) / 1024 / 1024 as "Total Size (MB)"
FROM
accounts
JOIN media_attachments ON media_attachments.account_id = accounts.id
WHERE media_attachments.file_file_size is not null
GROUP BY
accounts."domain"
ORDER BY
sum(media_attachments.file_file_size) DESC;

to get a list of instances by file size.

Replied to Talya (she/her) 🏳️‍⚧️✡️

@Yuvalne Question: Determine the media attachment file storage size held on a server for each account on Mastodon instance.

Mastodon Admin >Accounts pages clearly show what the media attachment storage size is for each account. Whether that is dynamically pulled when you view an account or is saved in the database periodically, I am not sure.

I ran "runuser -l mastodon -c 'cd ~ && pg_dump --column-inserts --table=accounts mastodon_production > accounts2.sql'" and it came back with a listing of accounts with this information as a text sql file for each account. I didn't see Media_attatchment file sizes in that info.

Maybe there is a pg_dump recipe that would return the "Media Attachment" info from the Admin>Account pages if it is saved in the database. I can't figure out what field that would be in the database schema. It's early, still, though, and I just brushed over the schema.😉 Tagging #mastodon #MastoAdmin #data #MastoDev in case someone is familiar with it.

Info it returned:
id, username, domain, private_key, public_key, created_at, updated_at, note, display_name, uri, url, avatar_file_name, avatar_content_type, avatar_file_size, avatar_updated_at, header_file_name, header_content_type, header_file_size, header_updated_at, avatar_remote_url, locked, header_remote_url, last_webfingered_at, inbox_url, outbox_url, shared_inbox_url, followers_url, protocol, memorial, moved_to_account_id, featured_collection_url, fields, actor_type, discoverable, also_known_as, silenced_at, suspended_at, hide_collections, avatar_storage_schema_version, header_storage_schema_version, devices_url, suspension_origin, sensitized_at, trendable, reviewed_at, requested_review_at, indexable

#Mastoadmin is there a good way to find which remote accounts/domains take a ton of space with media attachments? our server's remote media cache is ballooning by 30GB *a day* and that definitely sounds wrong.
the info exists somewhere because you can see it in the admin console, but neither the admin console nor #tootctl seem to have a way to sort by attachments total size (unless i'm missing something). any advice?