Notices by Vivi Nella Verita (verita84eva@poster.place), page 2

Vivi Nella Verita (verita84eva@poster.place)'s status on Monday, 29-Apr-2024 09:02:49 JST Vivi Nella Verita
in reply to
- Tetra
@tetra

Some let you say nigger

In conversation about 7 months ago from poster.place permalink
Vivi Nella Verita (verita84eva@poster.place)'s status on Saturday, 27-Apr-2024 01:59:18 JST Vivi Nella Verita
in reply to
- DJ :debian: :coolcat: :colombia:
@dj

https://pastebin.com/AHQeTtCp
In conversation about 7 months ago from poster.place permalink
Attachments
1. clean-akkoma() { DATABASES=(akkoma detroitriotcity) echo "Stopping A - Pastebin.com
  
  Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.
Vivi Nella Verita (verita84eva@poster.place)'s status on Saturday, 27-Apr-2024 01:59:08 JST Vivi Nella Verita
- DJ :debian: :coolcat: :colombia:
@dj

A function to actually clean Akkoma /Pleroma well

```
DATABASES=(akkoma detroitriotcity)
echo "Stopping Akkoma"
systemctl stop akkoma
for i in "${DATABASES[@]}"; do
echo "Scanning Fderated Posts to Delete: $i"
su postgres -s /bin/bash -lc "echo \"SELECT COUNT(*) FROM \"objects\" AS o0 WHERE (o0.\"data\"->'to' ? 'https://www.w3.org/ns/activitystreams#Public' OR o0.\"data\"->'cc' ? 'https://www.w3.org/ns/activitystreams#Public') AND (o0.\"inserted_at\" < now() - interval '15 days' ) AND (split_part(o0.\"data\"->>'actor', '/', 3) != '$i')\" | psql $i"
echo "Deleting Objects for: $i"
su postgres -s /bin/bash -lc "echo \"DELETE FROM \"objects\" AS o0 WHERE (o0.\"data\"->'to' ? 'https://www.w3.org/ns/activitystreams#Public' OR o0.\"data\"->'cc' ? 'https://www.w3.org/ns/activitystreams#Public') AND (o0.\"inserted_at\" < now() - interval '15 days' ) AND (split_part(o0.\"data\"->>'actor', '/', 3) != '$i')\" | psql $i"
echo "Deleting Activities for: $i"
su postgres -s /bin/bash -lc "echo \"DELETE FROM \"activities\" where data->>'type' = 'Create' and local = 'f' and inserted_at < now() - interval '10 days'"\" | psql $i
echo "Starting Akkoma: $i"
systemctl start akkoma
done
}
```
In conversation about 7 months ago from poster.place permalink
Attachments
1. No result found on File_thumbnail lookup.
  
  ActivityStreams 2.0 Terms
  
  This document lists the terms used for the ActivityStreams 2.0 protocol and its stable extensions, and provides a namespace so each term has an HTTP IRI.
Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 15:01:32 JST Vivi Nella Verita
in reply to
@mint @colonelj @i @admin @ChristiJunior

Some success. After Repack, Activities table went from 38GB to 15GB. I deleted Federated Activites up to the last 10 days. WTF happened in the last 10 days on Fedi lol

Total Disk Footprint of the Database Dir is now 34GB. It was 93GB before we started the work today.

Thanks everyone!

In conversation about 7 months ago from poster.place permalink
Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 09:47:13 JST Vivi Nella Verita
in reply to
@mint @colonelj @i

pg_backup will not include all the deleted data right?

In conversation about 7 months ago from poster.place permalink
Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 09:46:01 JST Vivi Nella Verita
in reply to
@mint @colonelj @i

will do repack now. Doing a dump first with pg_backup to see if size is smaller

In conversation about 7 months ago from poster.place permalink
Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 09:44:59 JST Vivi Nella Verita
in reply to
@mint @colonelj @i

I ran it , even ran it again to 30 days. Activities size didn't change. Heavy DIsk IO when running so it was doing something
In conversation about 7 months ago from poster.place permalink
Attachments
1. Untitled attachment
  https://poster.place/media/ec26248c631c9c80eb53217e94ab5430a1f644dcc440c83741cd42f681c57a4c.png
Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 07:12:14 JST Vivi Nella Verita
in reply to
- Christi Junior
@ChristiJunior

Looks like the DB clean up slowed it down too much, Aborted it

In conversation about 7 months ago from poster.place permalink
Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 07:11:17 JST Vivi Nella Verita
in reply to
- Christi Junior
@ChristiJunior

No. What do you see?

In conversation about 7 months ago from poster.place permalink
Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 06:33:23 JST Vivi Nella Verita
in reply to
@mint @colonelj @i oh boy. Try deleting shit from your own instance and oban_jobs filles up and kills your disk io . That was a first big issue with DRc when trying to clean it up

In conversation about 7 months ago from poster.place permalink
Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 06:25:37 JST Vivi Nella Verita
in reply to
@mint @colonelj @i

Ah is that why deletes are always slow and takes days like with the original commands you gave me ?

In conversation about 7 months ago from poster.place permalink
Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 06:24:29 JST Vivi Nella Verita
in reply to
@mint @colonelj @i

We did follow a lot. I just recently turned it off . Database grew form 60gb to 93gb in a ween

In conversation about 7 months ago from poster.place permalink
Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 06:13:07 JST Vivi Nella Verita
in reply to
- :blank:
- J上校👮🇺🇦🏳️‍⚧️
@i @colonelj

Running:

```
detroitriotcity=# delete from activities where data->>'type' = 'Create' and local = 'f' and inserted_at < now() - interval '365 days';
```

Now

In conversation about 7 months ago from poster.place permalink
Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 06:11:02 JST Vivi Nella Verita
in reply to
- :blank:
- J上校👮🇺🇦🏳️‍⚧️
@i @colonelj

lol yeah I been doing that daily since you told me via cron. I have no idea how to do the Activities table safely. Your suggestion for said tables does not really do much. It's yuge!

In conversation about 7 months ago from poster.place permalink
Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 06:11:00 JST Vivi Nella Verita
in reply to
- :blank:
- J上校👮🇺🇦🏳️‍⚧️
@i @colonelj

Ty. DRC almost 90 GB and is growing fast. Local posts would not be deleted? Only Federated?

In conversation about 7 months ago from poster.place permalink
Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 05:33:37 JST Vivi Nella Verita
- :blank:
- J上校👮🇺🇦🏳️‍⚧️
@i @colonelj

Ah, there still is not a good way to even maintain the Pleroma/Akkoma database. It took me two days to delete 157354 old posts using it's built-in commands and they just let the Activities table grow and grow without a way to clean it

In conversation about 7 months ago from poster.place permalink
Vivi Nella Verita (verita84eva@poster.place)'s status on Wednesday, 24-Apr-2024 19:17:58 JST Vivi Nella Verita
- burner
@burner

Check out what awesome thing Alex did

https://ditto.poster.place

If you switched to his Soapbox/Nostr relay called Ditto w Soapbox, you can use it to post to Nostr and Fedi all at the same time through the bridge.

Probably a better plan than just leavinng akkoma to soapbox.pub?

You can do both?
In conversation about 7 months ago from poster.place permalink
Attachments
1. No result found on File_thumbnail lookup.
  
  https://ditto.poster.place/
Vivi Nella Verita (verita84eva@poster.place)'s status on Sunday, 21-Apr-2024 11:23:58 JST Vivi Nella Verita

Can linux ever look this good?
In conversation about 7 months ago from poster.place permalink
Attachments
1. Untitled attachment
  https://poster.place/media/d810e1c7268f294a3482e0f4feae417563e5b9405f956f2e9242867502a8c740.png
Vivi Nella Verita (verita84eva@poster.place)'s status on Saturday, 20-Apr-2024 11:29:05 JST Vivi Nella Verita
in reply to
- Christi Junior
- Rasterman
@ChristiJunior @Rasterman

Oy vay stop persecuting me or ill squirt
In conversation about 7 months ago from poster.place permalink
Attachments
1. Untitled attachment
  https://poster.place/media/74d36810d911055d93f0c2f9d4820bafc00d947dc459b914aeab54b1110d2ef3.gif
Vivi Nella Verita (verita84eva@poster.place)'s status on Saturday, 20-Apr-2024 06:12:36 JST Vivi Nella Verita
in reply to
@admin @ins0mniak @Hyperhidrosis

Did you get dem free AOL hours my nigga? You are 8 years older than me? Wow. I started the Internet in 1995 or 1994....

In conversation about 7 months ago from poster.place permalink

After
Before

Public

Notices by Vivi Nella Verita (verita84eva@poster.place), page 2

User actions

Following 0

Followers 0

Groups 0

Statistics

Feeds