InfluxDB Performance - earthcubeprojects-chords/chords GitHub Wiki
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 |