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?
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:
[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
Could it be caused because I had changed the _APP_USAGE_AGGREGATION_INTERVAL to 60 and disabled the usage container? Not sure how to fix this now π
That's weird π
If you disabled usage, then that's why it's not working, unless you started it again
Hm I still wouldn't expect an internal server error when disabling usage but I will enable it again to see if the problem resolves itself that way
ya...looks like a regression π
Here's a PR: https://github.com/appwrite/appwrite/pull/7087
Ah great a PR is open for that π
