Ways to reduce the size that appwrite takes

Hi,

Forgive me for the strange question because I'm not an expert.

I have an appwrite selfhosted instance with 200 milion+ docs, the disk usage is 120+ gb

Is there a way to reduce the size of the db?

Are you sure that the DB is really using more than 120GB?

Docker stats are showing that?

Yes the docker volume is now at 120gb

The database volume?

Ok I'm gonna test this....

@jesus
Also, you could try a different engine such as myrocks that has a better compression:
https://mariadb.com/kb/en/about-myrocks-for-mariadb/

However the DB could behave differently and unstable

But you could try

Aso, @jesus Do you have document level permissions

No

@jesus Did it work? 🙂

No 😭

I just did this... created 1 tb cloud storage in vultr.

It's cheaper than upgrading the whole server.

You were not able to migrate? 😅

I see. What about Hetzner?

My account got blocked the next second it was created😅 contacted them, no answer, no explanation, nothing

Contabo is sh*t

Linode servers are not stable, i get abnormal crashes with them

You can't use a Gmail account I think

Weird. Never heard about it and they are not precisely cheap I think

They are cheaper than vultr on the cloud storage, and they offer up to 100tb on a single instance, vultr the max is 10tb

Interesting. I'm going to try Hetzner soon and move from Ionos.
Hope they don't delete my production data or similar 😆

He failed fraud check