InfluxDB: Performance Monitoring: Unterschied zwischen den Versionen
Aus Wiki-WebPerfect
Admin (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „''On this page you find informations about the performance of your InfluxDB instance.'' == Query limits == With the InfluxDB configuration: '''max-concurrent-…“) |
Admin (Diskussion | Beiträge) K |
||
Zeile 2: | Zeile 2: | ||
== Query limits == | == Query limits == | ||
− | With the InfluxDB configuration: '''max-concurrent-queries''' you can limit the maximum number of running queries (Default = 0 -> unlimited number of queries). | + | With the InfluxDB configuration: '''max-concurrent-queries''' you can limit the maximum number of running queries (Default = 0 -> unlimited number of queries). <br> |
With the InfluxDB configuration: '''query-timeout''' you can limit the duration of queries (Default = 0 -> no duration limit). | With the InfluxDB configuration: '''query-timeout''' you can limit the duration of queries (Default = 0 -> no duration limit). | ||
Aktuelle Version vom 15. März 2021, 14:09 Uhr
On this page you find informations about the performance of your InfluxDB instance.
Inhaltsverzeichnis
Query limits
With the InfluxDB configuration: max-concurrent-queries you can limit the maximum number of running queries (Default = 0 -> unlimited number of queries).
With the InfluxDB configuration: query-timeout you can limit the duration of queries (Default = 0 -> no duration limit).
Useful performance metrics commands
To see node statistics
SHOW STATS
The statistics returned by SHOW STATS are stored in memory only, and are reset to zero when the node is restarted.
Number of points per second being written to the instance (monitor service must have enabled)
influx -execute 'select derivative(pointReq, 1s) from "write" where time > now() - 5m' -database '_internal' -precision 'rfc3339'
Identify currently running queries
SHOW QUERIES
Stop currently running queries
qid = Query-ID from the SHOW QUERIES command.
KILL QUERY <qid>