false true true continue false 1 1 1 false true true false create database if not exists long_db1; = http://172.26.10.86:6041/rest/sql POST true false true false true false create database if not exists long_db2; = http://172.26.10.85:6041/rest/sqlt POST true false true false true false create database if not exists long_db3; = http://172.26.10.84:6041/rest/sqlutc POST true false true false continue false 1 1 false true true false CREATE TABLE if not exists long_db1.stb11 (ts timestamp, c1 tinyint, c2 smallint, c3 int, c4 bigint, c5 float, c6 double, c7 binary(16), c8 nchar(16), c9 bool) tags (t1 tinyint, t2 smallint, t3 int, t4 bigint, t5 float, t6 double, t7 binary(16), t8 nchar(16), t9 bool); = http://172.26.10.86:6041/rest/sql POST true false true false true false CREATE TABLE if not exists long_db1.stb12 (ts timestamp, c1 tinyint, c2 smallint, c3 int, c4 bigint, c5 float, c6 double, c7 binary(16), c8 nchar(16), c9 bool) tags (t1 tinyint, t2 smallint, t3 int, t4 bigint, t5 float, t6 double, t7 binary(16), t8 nchar(16), t9 bool); = http://172.26.10.86:6041/rest/sqlt POST true false true false true false CREATE TABLE if not exists long_db1.stb13 (ts timestamp, c1 tinyint, c2 smallint, c3 int, c4 bigint, c5 float, c6 double, c7 binary(16), c8 nchar(16), c9 bool) tags (t1 tinyint, t2 smallint, t3 int, t4 bigint, t5 float, t6 double, t7 binary(16), t8 nchar(16), t9 bool); = http://172.26.10.86:6041/rest/sqlutc POST true false true false true false CREATE TABLE if not exists long_db2.stb21 (ts timestamp, c1 tinyint, c2 smallint, c3 int, c4 bigint, c5 float, c6 double, c7 binary(16), c8 nchar(16), c9 bool) tags (t1 tinyint, t2 smallint, t3 int, t4 bigint, t5 float, t6 double, t7 binary(16), t8 nchar(16), t9 bool); = http://172.26.10.85:6041/rest/sql POST true false true false true false CREATE TABLE if not exists long_db2.stb22 (ts timestamp, c1 tinyint, c2 smallint, c3 int, c4 bigint, c5 float, c6 double, c7 binary(16), c8 nchar(16), c9 bool) tags (t1 tinyint, t2 smallint, t3 int, t4 bigint, t5 float, t6 double, t7 binary(16), t8 nchar(16), t9 bool); = http://172.26.10.85:6041/rest/sqlt POST true false true false true false CREATE TABLE if not exists long_db2.stb23 (ts timestamp, c1 tinyint, c2 smallint, c3 int, c4 bigint, c5 float, c6 double, c7 binary(16), c8 nchar(16), c9 bool) tags (t1 tinyint, t2 smallint, t3 int, t4 bigint, t5 float, t6 double, t7 binary(16), t8 nchar(16), t9 bool); = http://172.26.10.85:6041/rest/sqlutc POST true false true false true false CREATE TABLE if not exists long_db3.stb31 (ts timestamp, c1 tinyint, c2 smallint, c3 int, c4 bigint, c5 float, c6 double, c7 binary(16), c8 nchar(16), c9 bool) tags (t1 tinyint, t2 smallint, t3 int, t4 bigint, t5 float, t6 double, t7 binary(16), t8 nchar(16), t9 bool); = http://172.26.10.84:6041/rest/sql POST true false true false true false CREATE TABLE if not exists long_db3.stb32 (ts timestamp, c1 tinyint, c2 smallint, c3 int, c4 bigint, c5 float, c6 double, c7 binary(16), c8 nchar(16), c9 bool) tags (t1 tinyint, t2 smallint, t3 int, t4 bigint, t5 float, t6 double, t7 binary(16), t8 nchar(16), t9 bool); = http://172.26.10.84:6041/rest/sqlt POST true false true false true false CREATE TABLE if not exists long_db3.stb33 (ts timestamp, c1 tinyint, c2 smallint, c3 int, c4 bigint, c5 float, c6 double, c7 binary(16), c8 nchar(16), c9 bool) tags (t1 tinyint, t2 smallint, t3 int, t4 bigint, t5 float, t6 double, t7 binary(16), t8 nchar(16), t9 bool); = http://172.26.10.84:6041/rest/sqlutc POST true false true false continue false 500 2 false true true false CREATE TABLE if not exists long_db1.tb${tb_counter1000} using long_db1.stb11 tags (1, 2, 3, 4, 5.5, 6.6, "binary10", "nchar10", true) = http://172.26.10.86:6041/rest/sql POST true false true false true false CREATE TABLE if not exists long_db1.tb${tb_counter2000} using long_db1.stb12 tags (1, 2, 3, 4, 5.5, 6.6, "binary10", "nchar10", true) = http://172.26.10.86:6041/rest/sqlt POST true false true false true false CREATE TABLE if not exists long_db1.tb${tb_counter3000} using long_db1.stb13 tags (1, 2, 3, 4, 5.5, 6.6, "binary10", "nchar10", true) = http://172.26.10.86:6041/rest/sqlutc POST true false true false true false CREATE TABLE if not exists long_db2.tb${tb_counter1000} using long_db2.stb21 tags (1, 2, 3, 4, 5.5, 6.6, "binary10", "nchar10", true) = http://172.26.10.85:6041/rest/sql POST true false true false true false CREATE TABLE if not exists long_db2.tb${tb_counter2000} using long_db2.stb22 tags (1, 2, 3, 4, 5.5, 6.6, "binary10", "nchar10", true) = http://172.26.10.85:6041/rest/sqlt POST true false true false true false CREATE TABLE if not exists long_db2.tb${tb_counter3000} using long_db2.stb23 tags (1, 2, 3, 4, 5.5, 6.6, "binary10", "nchar10", true) = http://172.26.10.85:6041/rest/sqlutc POST true false true false true false CREATE TABLE if not exists long_db3.tb${tb_counter1000} using long_db3.stb31 tags (1, 2, 3, 4, 5.5, 6.6, "binary10", "nchar10", true) = http://172.26.10.84:6041/rest/sql POST true false true false true false CREATE TABLE if not exists long_db3.tb${tb_counter2000} using long_db3.stb32 tags (1, 2, 3, 4, 5.5, 6.6, "binary10", "nchar10", true) = http://172.26.10.84:6041/rest/sqlt POST true false true false true false CREATE TABLE if not exists long_db3.tb${tb_counter3000} using long_db3.stb33 tags (1, 2, 3, 4, 5.5, 6.6, "binary10", "nchar10", true) = http://172.26.10.84:6041/rest/sqlutc POST true false true false true false select count(tbname) from long_db1.stb11; = http://172.26.10.86:6041/rest/sql POST true false true false true false select count(*) from long_db2.stb22; = http://172.26.10.85:6041/rest/sqlt POST true false true false true false select * from long_db3.stb33 limit 100; = http://172.26.10.84:6041/rest/sqlutc POST true false true false continue false -1 2 false true true false insert into long_db1.tb${tb_counter1000} values (${ts_counter}, ${value_counter}, ${value_counter}, ${value_counter}, ${value_counter}, ${value_counter}.${value_counter}, ${value_counter}.${value_counter}, "binary10", "nchar10", true); = http://172.26.10.86:6041/rest/sql POST true false true false true false insert into long_db1.tb${tb_counter2000} values (${ts_counter}, ${value_counter}, ${value_counter}, ${value_counter}, ${value_counter}, ${value_counter}.${value_counter}, ${value_counter}.${value_counter}, "binary10", "nchar10", true); = http://172.26.10.86:6041/rest/sqlt POST true false true false true false insert into long_db1.tb${tb_counter3000} values (${ts_counter}, ${value_counter}, ${value_counter}, ${value_counter}, ${value_counter}, ${value_counter}.${value_counter}, ${value_counter}.${value_counter}, "binary10", "nchar10", true); = http://172.26.10.86:6041/rest/sqlutc POST true false true false true false stb14,arch=x64,datacenter=us-west-1b,hostname=host_5,os=Ubuntu16,rack=${tb_counter1000},region=us-west-1,service=10,service_environment=staging,service_version=${tb_counter1000},team=NYC col_value=32.261068 ${ts_counter} = http://172.26.10.86:6041/influxdb/v1/write?db=long_db1&precision=ms POST true false true false true false stb15 ${ts_counter} 32.261068286779754 arch=x64 datacenter=us-west-1b hostname=host_5 os=Ubuntu16 rack=${tb_counter2000} region=us-west-1 service=10 service_environment=staging service_version=${tb_counter2000} team=NYC = http://172.26.10.86:6041/opentsdb/v1/put/telnet/long_db1 POST true false true false true false {"metric": "stb16", "timestamp":${ts_counter}, "value":32.261068286779754, "tags":{"arch":"x64","datacenter":"us-west-1b","hostname":"host_5","os":"Ubuntu16","rack":"${tb_counter3000}","region":"us-west-1","service":"10","service_environment":"staging","service_version":"${tb_counter3000}","team":"NYC"}} = http://172.26.10.86:6041/opentsdb/v1/put/json/long_db1 POST true false true false true false insert into long_db2.tb${tb_counter1000} values (${ts_counter}, ${value_counter}, ${value_counter}, ${value_counter}, ${value_counter}, ${value_counter}.${value_counter}, ${value_counter}.${value_counter}, "binary10", "nchar10", true); = http://172.26.10.85:6041/rest/sql POST true false true false true false insert into long_db2.tb${tb_counter2000} values (${ts_counter}, ${value_counter}, ${value_counter}, ${value_counter}, ${value_counter}, ${value_counter}.${value_counter}, ${value_counter}.${value_counter}, "binary10", "nchar10", true); = http://172.26.10.85:6041/rest/sqlt POST true false true false true false insert into long_db2.tb${tb_counter3000} values (${ts_counter}, ${value_counter}, ${value_counter}, ${value_counter}, ${value_counter}, ${value_counter}.${value_counter}, ${value_counter}.${value_counter}, "binary10", "nchar10", true); = http://172.26.10.85:6041/rest/sqlutc POST true false true false true false stb24,arch=x64,datacenter=us-west-1b,hostname=host_5,os=Ubuntu16,rack=${tb_counter1000},region=us-west-1,service=10,service_environment=staging,service_version=${tb_counter1000},team=NYC col_value=32.261068 ${ts_counter} = http://172.26.10.85:6041/influxdb/v1/write?db=long_db2&precision=ms POST true false true false true false stb25 ${ts_counter} 32.261068286779754 arch=x64 datacenter=us-west-1b hostname=host_5 os=Ubuntu16 rack=${tb_counter2000} region=us-west-1 service=10 service_environment=staging service_version=${tb_counter2000} team=NYC = http://172.26.10.85:6041/opentsdb/v1/put/telnet/long_db2 POST true false true false true false {"metric": "stb26", "timestamp":${ts_counter}, "value":32.261068286779754, "tags":{"arch":"x64","datacenter":"us-west-1b","hostname":"host_5","os":"Ubuntu16","rack":"${tb_counter3000}","region":"us-west-1","service":"10","service_environment":"staging","service_version":"${tb_counter3000}","team":"NYC"}} = http://172.26.10.85:6041/opentsdb/v1/put/json/long_db2 POST true false true false true false insert into long_db3.tb${tb_counter1000} values (${ts_counter}, ${value_counter}, ${value_counter}, ${value_counter}, ${value_counter}, ${value_counter}.${value_counter}, ${value_counter}.${value_counter}, "binary10", "nchar10", true); = http://172.26.10.84:6041/rest/sql POST true false true false true false insert into long_db3.tb${tb_counter2000} values (${ts_counter}, ${value_counter}, ${value_counter}, ${value_counter}, ${value_counter}, ${value_counter}.${value_counter}, ${value_counter}.${value_counter}, "binary10", "nchar10", true); = http://172.26.10.84:6041/rest/sqlt POST true false true false true false insert into long_db3.tb${tb_counter3000} values (${ts_counter}, ${value_counter}, ${value_counter}, ${value_counter}, ${value_counter}, ${value_counter}.${value_counter}, ${value_counter}.${value_counter}, "binary10", "nchar10", true); = http://172.26.10.84:6041/rest/sqlutc POST true false true false true false stb34,arch=x64,datacenter=us-west-1b,hostname=host_5,os=Ubuntu16,rack=${tb_counter1000},region=us-west-1,service=10,service_environment=staging,service_version=${tb_counter1000},team=NYC col_value=32.261068 ${ts_counter} = http://172.26.10.84:6041/influxdb/v1/write?db=long_db3&precision=ms POST true false true false true false stb35 ${ts_counter} 32.261068286779754 arch=x64 datacenter=us-west-1b hostname=host_5 os=Ubuntu16 rack=${tb_counter2000} region=us-west-1 service=10 service_environment=staging service_version=${tb_counter2000} team=NYC = http://172.26.10.84:6041/opentsdb/v1/put/telnet/long_db3 POST true false true false true false {"metric": "stb36", "timestamp":${ts_counter}, "value":32.261068286779754, "tags":{"arch":"x64","datacenter":"us-west-1b","hostname":"host_5","os":"Ubuntu16","rack":"${tb_counter3000}","region":"us-west-1","service":"10","service_environment":"staging","service_version":"${tb_counter3000}","team":"NYC"}} = http://172.26.10.84:6041/opentsdb/v1/put/json/long_db3 POST true false true false true false select count(tbname) from long_db1.tb1; = http://172.26.10.86:6041/rest/sql POST true false true false true false select count(*) from long_db2.tb2; = http://172.26.10.85:6041/rest/sqlt POST true false true false true false select * from long_db3.tb3 limit 10; = http://172.26.10.84:6041/rest/sqlutc POST true false true false true false select * from db2.stb25 limit 10000; = http://172.26.10.86:6041/rest/sql POST true false true false true false select * from db3.stb31 limit 100000; = http://172.26.10.85:6041/rest/sqlt POST true false true false true false select * from db1.stb16 limit 1000000; = http://172.26.10.84:6041/rest/sqlutc POST true false true false true false select avg(c1), max(c2), count(c3), sum(c4) from db3.stb31 where ts>"2021-03-01 00:00:00" and ts < "2021-03-01 00:35:00" group by c7; = http://172.26.10.86:6041/rest/sql POST true false true false true false select avg(c1), max(c2), count(c3), sum(c4) from db2.stb23 where ts>"2021-03-01 00:00:00" and ts < "2021-03-01 00:35:00" interval (1s); = http://172.26.10.85:6041/rest/sqlt POST true false true false true false select avg(c1), max(c2), count(c3), sum(c4) from db2.stb23 where ts>"2021-03-01 00:00:00" and ts < "2021-03-01 00:35:00" interval (10s); = http://172.26.10.84:6041/rest/sqlutc POST true false true false throughput 50000.0 0.0 0 false saveConfig true true true true true true true true true false true true false false false true false false false true 0 true true true true true true false saveConfig true true true true true true true true true false true true false false false true false false false true 0 true true true true true true Authorization Basic cm9vdDp0YW9zZGF0YQ== 1 1000 1 tb_counter1000 false 1001 2000 1 tb_counter2000 false 2001 3000 1 tb_counter3000 false 1614530008000 1 ts_counter false 1 10 1 value_counter false