appwrite-usage container high cpu usage

Hi, i'm running a t2.small EC2 instance with Appwrite but i'm currently bumping into cpu usage issues. Apprently the appwrite-usage container is using more than 50% cpu. The total cpu usage went to 100%.

Is there anything I can do about this cpu usage? I'm currently running Appwrite 1.4.5. Is a t2.small EC2 instance sufficient to run Appwrite or do I need to upgrade?

TL;DR

The user is experiencing high CPU usage with the appwrite-usage container. They tried disabling usage and upgrading the server, but now they are getting an internal server error when trying to view usage. The error message indicates a TypeError. The user also mentions changing the _APP_USAGE_AGGREGATION_INTERVAL and disabling the usage container. They are unsure how to fix the issue. Suggestions from other users include modifying the interval, disabling usage via the _APP_USAGE_STATS environment variable, and checking if the amount of requests is abnormally high. There is no definitive solution provided in the thread.

CPU usage went back to normal levels but I sometimes see spikes from the appwrite usage container :/

It sadly happened again, I stopped the appwrite-usage container for now but it would definitely be nice to know why this is happening

yes, the usage container does a lot of work every _APP_USAGE_AGGREGATION_INTERVAL seconds. this container is responsible for aggregating a lot of data for the usage data you see in the project overview

you can try tweaking the interval

you can also try disabling usage via the _APP_USAGE_STATS env var if you don't need it

Thank you @Steven! I didn't know about those env variables. If I enable usage stats the usage container will just claim 50% cpu and keeps doing that. Could it be that amount of requests is very high? In the dashboard it shows 22k requests on a single day even though we don't have any users. We are just using this instance for development. Is 22k requests on a single day normal usage for a small development team of 4 devs?

If this was during peak hours, I think it's a normal usage, having in mind you just have 1 core server. You could just modify the interval as Steven said to distribute load having

Thank you for your response. I upgraded to a 2 core server now. The CPU is fine but usage is now broken. Whenever I try to view usage of anything I get an internal server error back This is the error on the server:

TypeScript

[Error] Method: GET
[Error] URL: /v1/functions/:functionId/usage
[Error] Type: TypeError
[Error] Message: Appwrite\Utopia\Response::dynamic(): Argument #1 ($document) must be of type Utopia\Database\Document, array given, called in /usr/src/code/app/controllers/api/functions.php on line 542
[Error] File: /usr/src/code/src/Appwrite/Utopia/Response.php
[Error] Line: 481
[Error] Timestamp: 2023-11-06T13:03:34+00:00