InfluxDB Performance

Performance

Note: the Docker performance numbers were measured when the influx database was located within the docker image, which imposes a severe penalty. We have since located the database in a docker volume, which should provide near-native performance.

Times are determined from the total time reported in the Rails log:

 tail -f log/production.log | grep Completed
I, [2016-11-25T23:29:44.694482 #48]  INFO -- : Completed 200 OK in 4573ms (Views: 11.7ms | ActiveRecord: 4535.9ms)

Dashboard Refresh

System	Branch	N Inst	N Samples	Time(s)
11/25/2016
AWS t2.small	influx	4	1.49M	1.225
AWS t2.small	docker	4	1.57M	4.573
OSX	influx	4	5.93M	4.624
11/28/2016
AWS t2.small	influx	4	2.77M	5.499
AWS t2.small	docker	4	2.87M	8.692
OSX	influx	4	7.15M	5.735
11/28/2016 InfluxDB V1.1
11/28/2016
AWS t2.small	influx	4	2.77M	4.971
AWS t2.small	docker	4	2.87M	8.597
OSX	influx	4	7.15M	4.676
12/05/2016
AWS t2.small	influx	4	5.28M	10.029
AWS t2.small	docker	4	5.72M	14.214
OSX	influx	4	10.00M	6.972
12/05/2016
AWS t2.medium	influx	4	5.28M	9.521
AWS t2.medium	docker	4	5.72M	16.660
OSX	influx	4	10.00M	6.972
12/10/2016
AWS t2.medium	influx	4	6.83M	6.515
AWS t2.medium	docker	4	6.98M	15.085
12/21/2016
AWS t2.small	influx	4	11.14M	9.468
AWS t2.small	docker	4	10.75M	22.266

Package and Download One CSV File

System	Branch	N Vars	N Inst	N Samples	Time(s)
11/24/2016
AWS t2.small	influx	5	4	1.06M	3.172
AWS t2.small	docker	5	4	1.15M	9.192
OSX	influx	5	4	5.50M	2.501
11/28/2016
AWS t2.small	influx	5	4	2.77M	3.211
AWS t2.small	docker	5	4	2.87M	failed
OSX	influx	5	4	7.15M	2.516
11/28/2016 InfluxDB V1.1
11/28/2016
AWS t2.small	influx	5	4	2.77M	3.065
AWS t2.small	docker	5	4	2.87M	failed, > 25
OSX	influx	5	4	7.15M	1.968
12/05/2016
AWS t2.small	influx	5	4	5.28M	3.278
AWS t2.small	docker	5	4	5.72M	failed, > 25
OSX	influx	5	4	10.00M	2.525
12/05/2016
AWS t2.medium	influx	5	4	5.28M	2.737
AWS t2.medium	docker	5	4	5.72M	failed, > 52
OSX	influx	5	4	10.00M	2.525
12/10/2016
AWS t2.medium	influx	5	4	6.83M	1.887
AWS t2.medium	docker	5	4	6.98M	failed, > 52