Rafael HenglesOriginal post
Rank 2: Process
When I start my server and print some logs, I get a torrent (not the p2p file kind) of queries to the influxdb service.
They are like this (dozens and dozens of repeated queries per second:
appwrite-influxdb | ts=2023-02-15T19:03:03.955327Z lvl=info msg="Executing query" log_id=0g1blzn0000 service=query query="SELECT sum(value) AS value FROM telegraf.autogen.\"appwrite_usage_project_{scope}_network_requests\" WHERE time > '2023-02-14T19:03:03+00:00' AND time < '2023-02-15T19:03:03+00:00' AND metric_type = 'counter' GROUP BY time(1h), projectId, projectInternalId"
appwrite-influxdb | ts=2023-02-15T19:03:03.958221Z lvl=info msg="Executing query" log_id=0g1blzn0000 service=query query="SELECT sum(value) AS value FROM telegraf.autogen.\"appwrite_usage_project_{scope}_network_bandwidth\" WHERE time > '2023-02-14T19:03:03+00:00' AND time < '2023-02-15T19:03:03+00:00' AND metric_type = 'counter' GROUP BY time(1h), projectId, projectInternalId"
// etc
Is this normal ? I'm not even accessing any usage or admin panel from appwrite. I ran these commands two or three seconds apart:
root@myserver:~/appwrite# docker compose logs 2>&1 | grep "appwrite-influxdb" | wc -l
82502
root@myserver:~/appwrite# docker compose logs 2>&1 | grep "appwrite-influxdb" | wc -l
83134
Summary
When starting the server and checking the logs, the user noticed a high volume of queries being sent to the InfluxDB service, even though they were not accessing any usage or admin panel from Appwrite. They provided an example of the repeated queries they observed.
A possible solution mentioned in a comment is to configure the interval by modifying the `_APP_USAGE_AGGREGATION_INTERVAL` environment variable. More information on how to do this can be found in the provided link: <https://appwrite.io/docs/environment-variables#general>.