InfluxDB: Performance Monitoring: Unterschied zwischen den Versionen

Aus Wiki-WebPerfect
Wechseln zu: Navigation, Suche
(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-…“)
 
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.

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>