false true true continue false 1 1 1 false true true false create database if not exists db1; = http://172.26.10.86:6041/rest/sql POST true false true false true false create database if not exists db2; = http://172.26.10.85:6041/rest/sqlt POST true false true false true false create database if not exists 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 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 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 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 stb14,arch=x64,datacenter=us-west-1b,hostname=host_5,os=Ubuntu16,rack=13,region=us-west-1,service=10,service_environment=staging,service_version=0,team=NYC col_value=32.261068 1626006833640 = http://172.26.10.86:6041/influxdb/v1/write?db=db1&precision=ms POST true false true false true false stb15 1626006833640 32.261068286779754 arch=x64 datacenter=us-west-1b hostname=host_5 os=Ubuntu16 rack=13 region=us-west-1 service=10 service_environment=staging service_version=0 team=NYC = http://172.26.10.86:6041/opentsdb/v1/put/telnet/db1 POST true false true false true false {"metric": "stb16", "timestamp":1626006833640, "value":32.261068286779754, "tags":{"arch":"x64","datacenter":"us-west-1b","hostname":"host_5","os":"Ubuntu16","rack":"13","region":"us-west-1","service":"10","service_environment":"staging","service_version":"0","team":"NYC"}} = http://172.26.10.86:6041/opentsdb/v1/put/json/db1 POST true false true false true false CREATE TABLE if not exists 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 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 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 stb24,arch=x64,datacenter=us-west-1b,hostname=host_5,os=Ubuntu16,rack=13,region=us-west-1,service=10,service_environment=staging,service_version=0,team=NYC col_value=32.261068 1626006833640 = http://172.26.10.85:6041/influxdb/v1/write?db=db2&precision=ms POST true false true false true false stb25 1626006833640 32.261068286779754 arch=x64 datacenter=us-west-1b hostname=host_5 os=Ubuntu16 rack=13 region=us-west-1 service=10 service_environment=staging service_version=0 team=NYC = http://172.26.10.85:6041/opentsdb/v1/put/telnet/db2 POST true false true false true false {"metric": "stb26", "timestamp":1626006833640, "value":32.261068286779754, "tags":{"arch":"x64","datacenter":"us-west-1b","hostname":"host_5","os":"Ubuntu16","rack":"13","region":"us-west-1","service":"10","service_environment":"staging","service_version":"0","team":"NYC"}} = http://172.26.10.85:6041/opentsdb/v1/put/json/db2 POST true false true false true false CREATE TABLE if not exists 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 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 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 true false stb34,arch=x64,datacenter=us-west-1b,hostname=host_5,os=Ubuntu16,rack=13,region=us-west-1,service=10,service_environment=staging,service_version=0,team=NYC col_value=32.261068 1626006833640 = http://172.26.10.84:6041/influxdb/v1/write?db=db3&precision=ms POST true false true false true false stb35 1626006833640 32.261068286779754 arch=x64 datacenter=us-west-1b hostname=host_5 os=Ubuntu16 rack=13 region=us-west-1 service=10 service_environment=staging service_version=0 team=NYC = http://172.26.10.84:6041/opentsdb/v1/put/telnet/db3 POST true false true false true false {"metric": "stb36", "timestamp":1626006833640, "value":32.261068286779754, "tags":{"arch":"x64","datacenter":"us-west-1b","hostname":"host_5","os":"Ubuntu16","rack":"13","region":"us-west-1","service":"10","service_environment":"staging","service_version":"0","team":"NYC"}} = http://172.26.10.84:6041/opentsdb/v1/put/json/db3 POST true false true false continue false 500 2 false true true false CREATE TABLE if not exists db1.tb${tb_counter1000} using 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 db1.tb${tb_counter2000} using 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 db1.tb${tb_counter3000} using 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 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 1626006833640 = http://172.26.10.86:6041/influxdb/v1/write?db=db1&precision=ms POST true false true false true false stb15 1626006833640 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/db1 POST true false true false true false {"metric": "stb16", "timestamp":1626006833640, "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/db1 POST true false true false true false CREATE TABLE if not exists db2.tb${tb_counter1000} using 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 db2.tb${tb_counter2000} using 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 db2.tb${tb_counter3000} using 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 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 1626006833640 = http://172.26.10.85:6041/influxdb/v1/write?db=db2&precision=ms POST true false true false true false stb25 1626006833640 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/db2 POST true false true false true false {"metric": "stb26", "timestamp":1626006833640, "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/db2 POST true false true false true false CREATE TABLE if not exists db3.tb${tb_counter1000} using 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 db3.tb${tb_counter2000} using 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 db3.tb${tb_counter3000} using 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 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 1626006833640 = http://172.26.10.84:6041/influxdb/v1/write?db=db3&precision=ms POST true false true false true false stb35 1626006833640 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/db3 POST true false true false true false {"metric": "stb36", "timestamp":1626006833640, "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/db3 POST true false true false true false select count(tbname) from db1.stb11; = http://172.26.10.86:6041/rest/sql POST true false true false true false select count(*) from db2.stb22; = http://172.26.10.85:6041/rest/sqlt POST true false true false true false select * from db3.stb33 limit 100; = http://172.26.10.84:6041/rest/sqlutc POST true false true false continue false 125000 8 false true true false insert into 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 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 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=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/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/db1 POST true false true false true false insert into 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 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 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=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/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/db2 POST true false true false true false insert into 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 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 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=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/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/db3 POST true false true false true false select count(tbname) from db1.tb1; = http://172.26.10.86:6041/rest/sql POST true false true false true false select count(*) from db2.tb2; = http://172.26.10.85:6041/rest/sqlt POST true false true false true false select * from db3.tb3 limit 1000; = http://172.26.10.84:6041/rest/sqlutc POST true false true false continue false 1 1 1 false true true false drop table if exists db2.tb2; = http://172.26.10.86:6041/rest/sql POST true false true false true false drop table if exists db2.stb22; = http://172.26.10.86:6041/rest/sql POST true false true false true false drop table if exists db3.tb3; = http://172.26.10.85:6041/rest/sqlt POST true false true false true false drop table if exists db3.stb33; = http://172.26.10.85:6041/rest/sqlt POST true false true false true false drop table if exists db1.tb1; = http://172.26.10.84:6041/rest/sqlutc POST true false true false true false drop table if exists db1.stb11; = 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 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 continue false 1 1 1 false true true false drop database if exists db1; = http://172.26.10.86:6041/rest/sql POST true false true false true false drop database if exists db2; = http://172.26.10.85:6041/rest/sqlt POST true false true false true false drop database if exists db3; = http://172.26.10.84:6041/rest/sqlutc POST true false true false