#influxdb

Hello

I'm trying to query a database like this : influx -execute 'SELECT * FROM "cockpit3"."autogen"."metrics.Linux-Memory" WHERE "host"=\'Centreon\''

I can't get right the "host"='Centreon', gotta despecialize the simple quote, but no success so far. Any hints ?

The select .... where "host"='Centreon' does return data in the influx console or Chronograf data explorer

lyr: i don't think this is your issue, but the docs recommend always double-quoting identifiers: https://docs.influxdata.com/influxdb/v1.6/query...

xginn8 that's what I'm doing for "host"

AH, got it working like this : influx -execute "SELECT * FROM \"cockpit3\".\"autogen\".\"metrics.Linux-Memory\" WHERE host='Centreon'"

Q: I'm saving data in influxdb every second, however, when choosing a 24 (or more) hours graph, cpu usage goes @ 80-90%.. The query is: SELECT last("value") FROM "expire_policy"."total_http" WHERE ("dest_ip" =~ /^$IPaddr$/) AND $timeFilter GROUP BY time($__interval), "dest_ip" fill(linear)

Is there a way to still get a 24 hour graph but avoid the high cpu usage?

Hey everyone. Is this the right place to ask questions about Telegraf?

yes, the whole TICK stack is in scope in this channel

Excellent. I have a question concerning MySQL metrics.

I have grafana and telegraf running on two nodes. I'm receiving general MySQL stats, but not InnoDB (which is more important to our Org than MySQL)

I'm inheriting this project from an admin whos out on paternity leave. I wanted to know...

Where should I begin looking to determine why the MySQL instances are not reporting InnoDB data?