Influxdb Version 1.2.0
I am witnessing severe query degradation when my database gets to a certain size (~140G as measured in the influxdb/data directory).
My database is quite simple. Series cardinality is around 5900. Retention is 7 days only.
What I am seeing is the following:
- Select queries in some time-ranges respond within 2 seconds or less.
- Select queries in other time-ranges either take many seconds to complete or never complete.
- For the queries that take many seconds to complete, I can improve response times significantly by reducing the result set to return a single field (as opposed to all tags and fields).
- trace-logging and query-log both enabled but no interesting messages are shown, except for slow query notifications.
This behavior makes no sense to me and if anyone has any insights then I would be grateful to hear them.