Skip to content
Start project
Back

Nonstop telegraf influxdb requests

  • 0
  • Self Hosted
  • General
View on Discord
Rafael Hengles
15 Feb, 2023, 19:22

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>.
Drake
15 Feb, 2023, 19:30

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

Reply

Reply to this thread by joining our Discord

Reply on Discord

Recommended threads

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more