Self hosted instance is very slow on login and other operations

[vocal tendon]

I'm running appwrite self hosted on a contabo vps, version 1.6.0. I experience very slow login in my web app (>10s), and the appwrite admin panel also seems very slow.

I ran top during the login process and php was using > 100% CPU.

Failed to initialize logging provider: Unable to parse DSN: scheme is required
[Error] Timestamp: 2024-11-12T11:21:03+00:00
[Error] Method: 
[Error] URL: /apple-touch-icon-precomposed.png
[Error] Type: Appwrite\Extend\Exception
[Error] Message: The requested route was not found. Please refer to the API docs and try again.
[Error] File: /usr/src/code/app/controllers/general.php
[Error] Line: 1051
Failed to initialize logging provider: Unable to parse DSN: scheme is required
[Error] Timestamp: 2024-11-12T11:21:03+00:00
[Error] Method: 
[Error] URL: /apple-touch-icon.png
[Error] Type: Appwrite\Extend\Exception
[Error] Message: The requested route was not found. Please refer to the API docs and try again.
[Error] File: /usr/src/code/app/controllers/general.php
[Error] Line: 1051
Failed to initialize logging provider: Unable to parse DSN: scheme is required
185.177.116.106 is not a publicly accessible domain. Skipping SSL certificate generation.

Maybe it is because I have signed up with email addresses, then deleted the users from appwrite admin panel and then signed up with the same email addresses again a few times?

[neat crag]

Contabo is to blame here. They oversell their server too much

Look for a different provider

[vocal tendon]

I never had problems before and I have 0 users, I'm during development.

[neat crag]

You do have a problem now. If you ever consider starting a serious project you should change your server provider.

They have among the highest cpu steal in the industry

They are utter garbage

[vocal tendon]

So what would you recommend instead? Hetzner?

[neat crag]

Hetzner is great. Alternatively you could also consider Netcup. They offer a lot more power but it is contract based.

Anything but Contabo

[vocal tendon]

Ok will do that, let's see if it fixes my problem.

But I still think there is some performance bottleneck maybe in the new appwrite version as I've been using 1.5.x for some time on the same server and never really had an issue.

[neat crag]

It is contabo

Trust me

[vocal tendon]

Thx for your help so far.

[neat crag]

I ran Appwrite on a few low spec server and never had that kind of issue

Simply google 'contabo cpu steal' and you will understand

cpu steal up to 5% is fine but on contabo it is constantly in the two digit area and also often over 50%

Your server has to constantly wait to get its turn to use the cpu

https://www.reddit.com/r/VPS/comments/1dakm9j/do_not_use_contabo/?show=original 70% cpu steal in this case

[azure haven]

@vocal tendon To double check that the cause is that. Do you can run topand share an screenshot?
Censor if there is some sensitive process or data you don't want to share

[thorny quail]

Found this from the same error, I'm also on Contabo, netcup looks sick but they are all sold out in the US.

[azure haven]

What do you get after running the top command?

[thorny quail]

Cpu averages anywhere from 5-15%, nothin crazy. I just realized my errors are about different routes. Though they seem to have gone away so I assume maybe somethin wierd happened with my servers internet for a few seconds or something.

[neat crag]

You have to check on the CPU steal since we are talking about Contabo

[thorny quail]

learning new things... that's averaging 5%-25%

[neat crag]

LMAO

😂

classic contabo

It never should go beyond 5%

Even 5% is high

[thorny quail]

Glad I know ab this now ty

[thorny quail]

So I got a Hetzner VPS, very happy

Contabo right now:

Hetzner:

[neat crag]

Appwrite should run a lot smoother now without that stupid Contabo tax 😜

[azure haven]

Oh, that's it 😅

@thorny quail Does it run faster in Hetzner now?

[thorny quail]

I believe so, VPS in general (ssh, ftp) def feels faster, and reports half the ram usage contabo was reporting with the exact same docker stacks running, wierd. Cancelling Contabo right now

[neat crag]

If your server has already 25% cpu steal when idling, it only gets worse from there on when it does any cpu heavy tasks. Especially the login process is resource intensive since Appwrite uses Argon2id under the hood. If Contabo can't even handle a simple ssh session smoothly then it certainly can't handle Appwrite.

[azure haven]

Appwrite or a wordpress 😂

[neat crag]

Wordpress is way more demanding lol

[azure haven]

I thought not 😮

[neat crag]

well maybe when you do a fresh install and use it without any plugins and whatnot, but most people do not use vanilla wordpress. They choose wordpress for its vast ecosystem and plugins and all that can be resource heavy

[vocal tendon]

how do you check this?

[neat crag]

Enter top in the ssh shell as @azure haven said and look for the stvalue

[thorny quail]

My server is better so ty, but seems my issue stems from elsewhere, getting the same logs - https://discord.com/channels/564160730845151244/1304970774171353170

[vocal tendon]

Yes I definitely had high steal, constantly between 5-30%, but this still shouldn't be that slow for 1 active user I'd think.
But TBH I don't really know how to interpret steal time, I'll switch to another VPS provider and see if the issue persists.

[neat crag]

@vocal tendon

Login is very resource intense. To put it into perspective, I have a server cluster where Appwrite runs on which can handle thousands of thousands of requests, but Login? It can handle login in the two digits. Login is very heavy on the systems

And you chose by far the shittiest provider in existence and that does really not help