#influxdb

hi, not sure this is the best place but I have question about a config option for Kapacitor

I am trying to understand what the "snapshot-interval" config option is doing in better detail

hm apparently I'm supposed to use the centos/redhat repo for fedora. Doesn't matter one bit anyway because go is all statically linked :-)

i have a test mysql db with >100M rows, how can i import data _fast_ to influxdb?

calling http api 100M times is not the best solution...

Elbandi: maybe the HTTP API you're using has some batching option?

is there another way to remotely pull stats from a remote telegraf instance other than prometheus client output+inputs.prometheus? can't connect to the influxdb server directly from the remote telegraf and the prometheus combo seem to mess with typical series names

hi there!

i try to query from cli with "tags". it seems it doesnt work when my tag has colon characters

is this a known bug?

it says: error parsing query: found :, expected ; at line 1, char 64

my query looks like this: influx -database MessageDatabase -format 'csv' -execute 'SELECT "SOC" FROM "Values" WHERE "MAC_ADR" = '2c:f7:f1:01:1d:92' ' > socdata.csv

can anybody help me with this problem plz?

double quotes in the mac field value?

doesnt work :(

if i use double quotes or leave them blank, there is no error. but nothing is stored... influxdb says u have to use single quotes

i cant test right know if the query works when i dont use colon and just store the tag without them

you can try to do a pipe if the problem is shell interpreting/messing with the quotes, i.e. echo "your query" | influx -database etc

i am sorry, i dont know exactly what do you mean?

your command line have a mix of ' and ", and the shell don't know where commands and parameters end. If influx don't support \' inside the quotes, you can echo the "right" query with i.e. echo "SELECT \"SOC\" FROM \"Values\" WHERE \"MAC_ADR\" = '2c:f7:f1:01:1d:92' " and pipe it to influx

if need to use double quotes and single ones in the query, of course

just covering the case that influx dont like the \ around

ok, and how does the "pipe it to influx" command look like?

echo "that from above" | influx -database MessageDatabase -format csv

ok, thx! i will try

ok, this works! how can i save the output to a *.csv file now?