远程登录influxdb服务
influx -ssl -username matrix-billing -password UqLLAGllPse2ZDhn -host ts-k2jti1sv93rj8gg4m.influxdata.tsdb.aliyuncs.com -port 8086
查看SQL执行时间
time influx -database graphitedb -execute "SELECT mean(system) FROM cpu WHERE env='prod' AND time > now() - 6h GROUP BY time(10m)"
查看解释计划
EXPLAIN ANALYZE select sum(order_payed_amount) as delivered_num from quota_pool group by record_date
数据迁移
group by 的是tag,select的是field值
SELECT order_all_num,order_delivered_amount,order_delivered_num,order_gmv_amount,order_payed_amount,order_payed_num,order_rpc_num INTO tongji..quota_pool FROM tongji_sandbox..quota_pool GROUP BY from_node_id,from_node_type,record_date,to_node_id,to_node_type
docker安装
docker run -d -p 8083:8083 -p8086:8086 --expose 8090 --expose 8099 --name my_influxdb docker.io/influxdb:1.8
curl -i -XPOST http://localhost:8086/query --data-urlencode "db=tongji" --data-urlencode "db=tongji" --data-urlencode "q=select count(amount) from order_pool"
通过api查询influxdb中数据
curl -i -XPOST http://localhost:8086/query --data-urlencode "q=select count(amount) from order_pool"
docker exec -it xxxxx bash 进入控制台
influx数据库操作
influx (进入db)
show databases;
show measurements;
show tag keys from order_pool
创建表 tag并且插入数据
insert rpc_pool,method=oms.update,shop_node_id=8237384,shop_node_type=dangdang,sys_node_id=23423444,sys_node_type=shopex msg_id="123123" 1488821368327436809
insert rpc_pool,method=oms.update,shop_node_id=8237324,shop_node_type=dangdang,sys_node_id=23423444,sys_node_type=shopex,tid=x1232233 msg_id="123123" 1488821368327436810
drop measurement rpc_pool