Back
Nonstop telegraf influxdb requests
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:
TypeScript
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:
TypeScript
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
TL;DR
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>.
it's normal for it to run. you can configure the interval by modifying the _APP_USAGE_AGGREGATION_INTERVAL env var. See https://appwrite.io/docs/environment-variables#general
