时序数据库

influxdb

measurement和tags共同称为key,如果在tag value中的空格,应以“\”加上空格表示。
tag中的值必须是string类型,其实是起到索引的作用。

field中的值可以为Integer、float、Boolean、string类型。若为Integer类型,则值后必须加“i”,否则该值为float类型,Boolean类型的值的表示方式有很多,直接写成:t、T、true、TRUE, 和 f、F、false、FALSE。
插入数据时,时间戳部分如果被省略,则默认将当前时间的时间戳插入数据库,否则按照用户输入的时间戳插入。

influxDB属于时序数据库,没有提供修改和删除数据的方法。但是删除可以通过InfluxDB的数据保存策略(Retention Policies)来实现。
测试发现,重写同一条记录可覆盖上一条记录,可以做到修改这条记录。
另外分析,从系统整体上来看,updateTime并没有使用到,因为实时数据并不再从数据库中查询获得,而是使用内存中的最新采集数据。查询统计时使用的时间是createTime。
如果不记录updateTime,并且如果最新采集数据一直没有特征变化,最终数据库中存储的可能是较早期采集插入的数据。
如果不记录updateTime,并且如果要存储最后一次采集时间,可额外记录。一般情况下,当前时间即是最新一条记录的修改时间,下一条数据的创建时间减去采集周期是上一条数据的最后修改时间。

wget https://dl.influxdata.com/influxdb/releases/influxdb-1.5.2.x86_64.rpm
sudo yum localinstall influxdb-1.5.2.x86_64.rpm
service influxdb start

#命令行连接
influx -precision rfc3339
drop database mydb1
CREATE DATABASE mydb1
SHOW DATABASES 
USE mydb1
SHOW MEASUREMENTS
drop measurement measurement1

#增加数据采用insert的方式,表名与数据之间用逗号(,)分隔,tag和field之间用 空格分隔,多个tag或者多个field之间用逗号(,)分隔。
INSERT measurement1,field1=serverA,field1=us_west field3=0.64

select * from "measurement1"
select * from measurement1 limit 1
select * from "measurement1" where "value">0.9  

#series表示表里面的数据,series主要通过tags排列组合算出来。
show series from measurement1

InfluxDB简明手册
https://legacy.gitbook.com/book/xtutu/influxdb-handbook/details

使用influxdb和grafana快速开发监控系统
http://0x0010.com/2017/07/monitor-system-based-on-influxdb-grafana/
https://github.com/miwurster/spring-data-influxdb
https://docs.influxdata.com/influxdb/v1.5/guides/writing_data/
https://docs.influxdata.com/influxdb/v1.5/tools/api_client_libraries/
一篇文章告诉你,为什么时序数据库会成为新趋势?
http://www.tuicool.com/articles/r6R3aaY
http://flacro.me/influxdb/
Grafana的安装(CentOS )- 千月带你美化监控数据 grafana(1)
https://blog.csdn.net/syshzbtt/article/details/71574204
### NOT starting grafana-server by default on bootup, please execute
sudo /sbin/chkconfig –add grafana-server
### In order to start grafana-server, execute
sudo service grafana-server start

InfluxDB系列学习教程目录
https://www.linuxdaxue.com/influxdb-study-series-manual.html
使用 InfluxDB 有感
https://toutiao.io/posts/viqzdg/preview
https://www.jianshu.com/p/d71646c08317
https://www.jianshu.com/p/a1344ca86e9b

What does early voting tell us?North Carolina has voted for

Thursday, county election workers blew that up bytwo dozen,for a total of 25 sites.”I wasn’t going to mess with that,” said Benny Sloan Cheap Jerseys free shipping, an African American resident living on the southeastern edge of the county’s largestcity, Greensboro, who said he saw lines going out the door and wrapping around the building when there was a single site.USA TODAYBlack police group unhappy with political endorsementsSloan, 44, manages disadvantaged business enterprises for the Department of Transportation in Raleighand spends two hours a day commuting. He said he and his wife, Sonja, planto vote Saturday at one of the expanded sites and thought others might too have been waiting.”I think that is kind of the consensus. Why are you going to to it today and wait three hours when you may go later and wait 30 minutes? Time is valuable to me.”Sloan said he planned to vote for Clinton.What does early voting tell us?North Carolina has voted for Republican presidents twice in 40 years.

wholesale jerseys Gus Garcia chuckles when he thinks about that boundary. Garreau drew it in 1981. That was before Garcia became the first Hispanic elected mayor of Austin. Olson became real estate reporter in March 2013 after spending four years as online reporter for IBJ Daily. He joined IBJ in 1999 and spent three years previously at IBJ sister publication Indiana Lawyer. Scott is an Illinois native and graduate of Western Illinois University of the mighty Leathernecks. wholesale jerseys

wholesale nfl jerseys from china She even sent me a video of the town where she lived, and photos of alpine ski trips with her family.Though there’s a good chance those letters are sitting in a drawer in my childhood bedroom at my parents’ home in Greenville, my memory of their exact content is hazy. I do know we wrote about our friends, our annoying younger siblings, about what we were learning in school, and about our dogs. Also: there’s the fact that she got to spend the dreadful middle school years in a town near Paris. wholesale nfl jerseys from china

wholesale jerseys But we didn’t know it was all in depth like this.”Smith’s visits with NFL teams are nearly at double digits after a busy week. He visited Denver on Monday and Pittsburgh on Tuesday.The meetings usually span the entire day. Players meet with the general manager the coaching staff specifically the offensive or defensive coordinator and are tested. wholesale jerseys

wholesale nfl jerseys from china If the Blue Jays do make the tournament, then just about anything is possible. We’ll see. Wrote:Coach Pietramala recently said that the Blue Jays had changed their warmup routine in order to get off to a faster start in games. Basketball seems to be a recurrent theme in the presidential race. We have seen many video clips and photos of Barack Obama shooting hoops and playing pickup basketball. He often makes references to his love of the sport, the media never miss an opportunity to comment on his skill and even ‘s brother, the coach of the men’s basketball team, spoke at the wholesale nfl jerseys from china.