ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo

InfiniFlux vs influxdb ?? ??? ?? 2016 12?-v2

?Download as DOCX, PDF?
?
Andrew Sungjin Kim
Andrew Sungjin Kim

Performance comparison between InfiniFlux vs InfluxDB

1 of 14
Downloaded 50 times
InfiniFlux DBMS VS Influx DBMS ?? ? ?? ?? ??? ?? ?? ??(Technical Note) 2016-12-05 INFINIFLUX www.infiniflux.com
? ? 1. ?? .....................................................................................1 1.1 H/W ??.......................................................................................1 1.2 S/W ??.......................................................................................1 1.3 ??? ?? ???.....................................................................1 1.3.1 InfiniFlux ???.........................................................................................2 1.3.2 Influxdb ???...........................................................................................2 1.4 ?? ??? ??.........................................................................3 2. ?? ???.........................................................................4 2.1 ??? ??..................................................................................4 2.1.1 InfiniFlux ??? ??...............................................................................4 2.1.2 Influxdb ??? ??.................................................................................4 2.1.3 InfinFlux VS Influxdb..................................................................................4 2.2 DISK ?? ??............................................................................5 2.3 ??? ?? ??.........................................................................5 2.3.1 CPU ??? ................................................................................................5 2.3.2 Memory ??? ..........................................................................................6 2.4 ?? ???..................................................................................6
3. ??? ??.........................................................................9
Error! Use the Home tab to apply ?? 1 to the text that you want to appear here. 1 1. ?? 1.1 H/W ?? ? CPU : Intel(R) Core(TM) i7-4790 CPU @ 3.60GHz * 8 CORE ? MEM : 32GB ? DISK: HDD 3.6 TB * 5 1.2 S/W ?? ? OS : CentOS 6.7 ? DB : InfiniFlux 3.1.1 VS Influxdb 1.0.2 1.3 ??? ?? ??? InfiniFlux ?? ?? ?? ??? ? ???? ???? ?? ? ???? weblog? ??? ?? ??? ???? ??? ?? ? ??, IP, port, ??? ???? ?? ? InfiniFlux ?? ??? 2015-05-20 06:00:00,219.229.142.218,2762,7.234.88.67,593,62,GET /twiki/bin/view/Main/MikeMannix HTTP/1.1,200,3686 2015-05-20 06:00:11,100.46.183.122,11989,227.106.13.91,4709,50,GET /mailman/listinfo/administration HTTP/1.1,200,6459 2015-05-20 06:00:11,214.153.107.182,7586,5.114.66.53,5213,6,GET /twiki/bin/view/Main/SpamAssassin HTTP/1.1,200,4081 ? Influxdb ?? ??? ? ?? ???? ??? ??? ?? ??? ?? ??? ??? ??? ?? ? ?? ?? ??? test_influxdb? table??? ??? ????? ???? tag key? field key? ???? ??. ? ???? date ?? ??? ???? ????. ¨C precision rfc3339/n/ns/m ???? ?? ? ? ?? ??? ?? ????. ? ? data ? ??? column?? ?? ??? ??. test_influxdb,srcip=123.198.82.192 dstip="50.230.44.173",srcport=9978,dstport=782,protocol=16,eventlog="GET /twiki/bin/view/TWiki/KlausWriessnegger HTTP/1.1",evencod=200,eventsize=3848 1479265350401897972 test_influxdb,srcip=58.208.78.121
Error! Use the Home tab to apply ?? 1 to the text that you want to appear here. 2 dstip="231.146.69.51",srcport=2330,dstport=3082,protocol=46,eventlog="GET /twiki/bin/view/TWiki/ManagingWebs?rev=1.22 HTTP/1.1",evencod=200,eventsize=9310 1479265197208287210 1.3.1 InfiniFlux ??? ? ??? ?? create table sampletable ( AT1 datetime property (MINMAX_CACHE_SIZE=1048576) not null, SRCIP ipv4, SCRPORT integer, DSTIP ipv4, DSTPORT integer, PROTOCOL short, eventlog varchar(1024), eventcode short, eventsize long ); ? Index ?? create index idx2 on sampletable(srcip) index_type lsm max_level=3; create index idx3 on sampletable(dstip) index_type lsm max_level=3; create keyword index idx4 on sampletable(eventlog) index_type lsm max_level=3; - ???? ??? ? ??? ??? ?? ?? - datetime ??? ?? minmax_cache ?? - ?? ??? ?? index ?? 1.3.2 InfluxDB ??? ? ??? ? Influxdb? tag key? field key? ??? tag key? ???? indexing? ??. ? ??? ??? ?? ? influxdb ?? ?? table field ? ?? ? ?? name: test_influxdb -------------------
Error! Use the Home tab to apply ?? 1 to the text that you want to appear here. 3 tagKey srcip evencod name: test_influxdb fieldKey fieldType dstip string dstport float eventlog string eventsize float protocol float srcport float - ???? ??? ? ?? ???? ?? ?? ?? ?? - tag key? srcip ? ???? ?? (group by ?? ???) - ??? ?? ??? ?? ? table ?? column??? ?? ?? ??? ??? ??? ?? ???? ?? ???? 1.4 ?? ??? ?? ? InfiniFlux ?? ??? (1?? 13GB) -rw-rw-r--. 1 demo demo 13045863917 May 20 11:15 sampletable100m.csv ? Influxdb ?? ??? (1?? 20GB) ? ??? ??? ??? ?? ?? ? ?? ?? ??? data ?? ??? ?? -rw-rw-r-- 1 perf perf 21253641580 Nov 16 13:37 sampletable100m.csv
Error! Use the Home tab to apply ?? 1 to the text that you want to appear here. 4 2. ?? ??? 2.1 ??? ?? 2.1.1 InfiniFlux ??? ?? InfiniFlux ? ???? ?? ?? ??? InfiniFlux ?? ???? ifluxloader tool? ???? CSV ??? ???? ?? ?? ??? ?? ??? ?? ??? ?? ?? ?? EPS sampletable100m.csv sampletable 1?? 13GB 4.96 min 336,022 - ?? 1??? ??? ?? 33??? ???? ??. 2.1.2 Influxdb ??? ?? Influxdb? ??? ???? ??? influx -import -path=sampletable100m.csv -precision=ns ???? ?? ??? txt ??? ??? ?? ?? ??? ?? ??? ?? ??? ?? ?? ?? EPS sampletable100m.csv test_influxdb 1?? 20GB 48.18 min 39,117 - ?? 1??? ??? ?? ?3.9??? ??? ?? 2.1.3 InfiniFlux vs Influxdb - ??? ?? InfiniFlux ? ?? ??? Influxdb?? 10? ?? ?? - Influxdb? ??? ???? ????? ?? ?? ??? ???? ?? ?? 39,117 336022 0 100,000 200,000 300,000 400,000 ?? ?? ?? Influxdb InfiniFlux
Error! Use the Home tab to apply ?? 1 to the text that you want to appear here. 5 2.2 DISK ?? ?? InfiniFlux? ???? ?? ? ? ???? ?? ?? ??? ??? ??? ??? ??? ?? ? ? ??. - 13GB ? ???? ??? InfiniFlux ? 5GB? , 20GB? ???? Influxdb? 20GB ? ?? ??? ????. - InfiniFlux? ???? 62%?? Influxdb? ???? 0%?? ???. 2.3 ??? ?? ?? ? ??? ??? ??? dstat ? 5? ???? ?? ? ?? ? ??? ??? ??? ?? ????? ?? ?? ??? ????? ?? 2.3.1 CPU ??? Influxdb ? ?? ??? ?? ?? ?? 35% ? CPU? ???? ??? ?? ? InfiniFlux ? ?? 24% ? CPU ? ?? 0 5 10 15 20 25 ?? ?? Influxdb InfiniFlux 0 50 100 100 235 370 505 640 775 910 1045 1180 1315 1450 1585 1720 1855 1990 2125 2260 2395 2530 2665 2800 CPU ??? influxdb InfinFlux
Error! Use the Home tab to apply ?? 1 to the text that you want to appear here. 6 2.3.2 Memory ??? - Influxdb ? ??? ???? ??? ?? ? ?? 1.4GB? ????, Influxdb ? ?? ?? ??? ?? ??? ??? ??. - InfiniFlux ? ?? 1.5GB? ??????, ??? ?? ??? ??? ????? ??. 2.4 ?? ??? ? Influxdb ??? ?? GROUP BY? tag key? ? ???? ?? ??? ??? ? ?? ?? ??. ? Test? srcip???? tag key ???? ?? ??? ? group by? ??. ? group by? ?? select? ?? ??? ???? ?? ?? ????. ? Influxdb???? ??? ?? ??? ?? ??? ??? ??? ns ?? ?? ? ?? ??? ?? ??? select count(*) from test_cli..test_influxdb ? ?? ?? ?? select count(*) from test_cli..test_influxdb where (srcip='31.224.72.52' and dstip='86.45.186.17'); 0 1000000 2000000 65 165 265 365 465 565 665 765 865 965 1065 1165 1265 1365 1465 1565 1665 1765 1865 1965 2065 2165 2265 2365 2465 2565 2665 2765 2865 Memory ??? Influxdb InfinFlux
Error! Use the Home tab to apply ?? 1 to the text that you want to appear here. 7 ? ?? ?? ?? select count(dstip), min(dstport),max(dstport), mean("eventsize") from test_cli..test_influxdb where (dstport <= 1000 and dstport >= 100) and evencod=200 group by srcip ? Group by average ?? select mean(eventsize) from test_cli..test_influxdb group by evencod ? Group by count ?? select count(*) from test_cli..test_influxdb group by evencod ? Group by ?? ?? select sum(eventsize) from test_cli..test_influxdb group by evencod ? Group by STDDEV ?? ?? Select stddev(eventsize) from test_cli..test_influxdb group by evencod ? ?? ?? InfiniFlux Influxdb ???(??) ?? ??? 0.000 ? 34.957 ? 1?? ?? ?? ?? 0.214 ? 4.245 ? 17,640 Group by AVERAGE for full-scan 11.076 ? 8.36 ? (?? ??, Full scan? ???? ??) 401 12848 200 9599.9949 Group by count 7.738 ? 40.673 ? 401 19998781 200 80001219 Group by SUM 11.838 ? 6.49 ? 401
Error! Use the Home tab to apply ?? 1 to the text that you want to appear here. 8 For full-scan (?? ??, Full scan? ???? ??) 256944328701 200 768010626424 Group by STDDEV 14.869 ? 303.034 ? 401 2.44939 200 12544.2 ?? ?? ?? 30.852 ? 52.126 ? 75ROWS
Error! Use the Home tab to apply ?? 1 to the text that you want to appear here. 9 3. ??? ?? ? InfiniFlux VS Influxdb??? ?? ?? InfiniFlux Influxdb ?? ?? ??? sampletable100m.csv (1??, 13GB) ???? ????? CPU ???(%) 24% 35% 100% = 8 core ?? 1.5? ?? ?? ??? ???(GB) 1.5GB 1.4GB 1.1? ?? ?? DISK ???(GB) 5GB 20GB ???? Infiniflux 65%?? Influxdb 0%?? ?? ?? ??(EPS) 336,022 EPS 39,117 EPS 9? ?? ?? ?? ??? 0.000 ? 34.957 ? ???? 1?? ?? ?? 0.214 ? 4.245 ? ???? 1.7?? ?? ?? 30.852 ? 52.126 ? 75ROWS GROUP BY AVERAGE 11.076 ? 8.36 ? 401 12848 200 9599.99 GROUP BY COUNT 7.738 ? 40.673 ? 401 19998781 200 80001219 GROUP BY SUM 11.83 ? 6.49 ? 401 256944328701 200 768010626424 GROUP BY STDDEV 14.869 ? 303.034 ? 401 2.44939 200 12544.2 - InfiniFlux ? Influxdb? ????? SQL ?? ???? ?? ?????, ???? ?? ???? ?? ??? ?? - db??? database?? ??? ?? ? ?? table ???? ?? - database ?? table?? ? ?? ?? ??? ?? - InfiniFlux ? Column ? DB? ?? ????? ?????, Influxdb? key-values ??? ??? ???? ??, case? ?? ? DB? ?? ? ????? ?? ??? ?? - ???? ???? ??? ??? InfiniFlux ? ?? DB? ?? Table schema ? ??? ??? ?? ???? ?? ?? ??? Influxdb? ?? ??? ??? ??? ?? - ?? ?? ??? ??? ??? ?? Influxdb? GROUP BY ??? tag key??? ???? ??? ??? ??, ORDER BY ? LIMIT ??? ??? ??. - ?? LIKE ??? ?? ?? ??? ??? ???(??? ¡®=¡¯ ??? ?? ). - Influxdb? ?? ?? ? ?? ?? ??? ?? ??? ??? ???? ??? ?? ??? ?? ? ? Equal ??? ??? ?? ??? ???? tag key??? ?? ?? ??? ?? ??? ? ?? ??? ?? ??? ?? ?? - ???? ?? ? ? ? ??? ?? tag key? ?? ???? ??? ??? ?? ? ?? ??? ??? ???? ???? ?? ?? ??
Error! Use the Home tab to apply ?? 1 to the text that you want to appear here. 10 - ?? ??? ? ??? ?? 1000,000 row ???? ?? ? ? ??? ??? ?????. Conf ??? ???? ? ??? ?? ?? - Tag key? ?? ?? ??? ??? ?? ??? ????, ?? ??? ?? ????.
Error! Use the Home tab to apply ?? 1 to the text that you want to appear here. 11 ? ???? ??? InfiniFlux ? Influxdb? ??? ?? ???. ? ??? ?? Influxdb? ???? ?????? ??? ???? ??? InfiniFlux?? ?? ??? ????. Influxdb ?? ???? ?? ???? ??? ?? ??? ????? ???? ??. ? ??? ?? tag key? ???? ? tag key? ??? ???? ?? ???? ???? ??? ?? ?? ? ??. ?? ???? ?? ?? row? ??? ?? ??? ? ???? ?? ???? ??? ?? ??? ???? ? ??. ??? tag key??? ? ??? ???? ??, ??? ?? ?? ?? ??? ???? ???? ??? ?? ??? ?? ????. ?? ???? tag key? ???? ?? ??? ?? ??? ?? ???? ??? ?? ??? ? ??? ?? ?? ??? ? ? ???? ?? ?? ???. ??? InfiniFlux ? ?? ??? ??? ?? ?? ?? ??? ????, ??? ??? ???? ???? ??? ???? ??? ??? ??? ????.

More Related Content

InfiniFlux vs influxdb ?? ??? ?? 2016 12?-v2

  • 1. InfiniFlux DBMS VS Influx DBMS ?? ? ?? ?? ??? ?? ?? ??(Technical Note) 2016-12-05 INFINIFLUX www.infiniflux.com
  • 2. ? ? 1. ?? .....................................................................................1 1.1 H/W ??.......................................................................................1 1.2 S/W ??.......................................................................................1 1.3 ??? ?? ???.....................................................................1 1.3.1 InfiniFlux ???.........................................................................................2 1.3.2 Influxdb ???...........................................................................................2 1.4 ?? ??? ??.........................................................................3 2. ?? ???.........................................................................4 2.1 ??? ??..................................................................................4 2.1.1 InfiniFlux ??? ??...............................................................................4 2.1.2 Influxdb ??? ??.................................................................................4 2.1.3 InfinFlux VS Influxdb..................................................................................4 2.2 DISK ?? ??............................................................................5 2.3 ??? ?? ??.........................................................................5 2.3.1 CPU ??? ................................................................................................5 2.3.2 Memory ??? ..........................................................................................6 2.4 ?? ???..................................................................................6
  • 4. Error! Use the Home tab to apply ?? 1 to the text that you want to appear here. 1 1. ?? 1.1 H/W ?? ? CPU : Intel(R) Core(TM) i7-4790 CPU @ 3.60GHz * 8 CORE ? MEM : 32GB ? DISK: HDD 3.6 TB * 5 1.2 S/W ?? ? OS : CentOS 6.7 ? DB : InfiniFlux 3.1.1 VS Influxdb 1.0.2 1.3 ??? ?? ??? InfiniFlux ?? ?? ?? ??? ? ???? ???? ?? ? ???? weblog? ??? ?? ??? ???? ??? ?? ? ??, IP, port, ??? ???? ?? ? InfiniFlux ?? ??? 2015-05-20 06:00:00,219.229.142.218,2762,7.234.88.67,593,62,GET /twiki/bin/view/Main/MikeMannix HTTP/1.1,200,3686 2015-05-20 06:00:11,100.46.183.122,11989,227.106.13.91,4709,50,GET /mailman/listinfo/administration HTTP/1.1,200,6459 2015-05-20 06:00:11,214.153.107.182,7586,5.114.66.53,5213,6,GET /twiki/bin/view/Main/SpamAssassin HTTP/1.1,200,4081 ? Influxdb ?? ??? ? ?? ???? ??? ??? ?? ??? ?? ??? ??? ??? ?? ? ?? ?? ??? test_influxdb? table??? ??? ????? ???? tag key? field key? ???? ??. ? ???? date ?? ??? ???? ????. ¨C precision rfc3339/n/ns/m ???? ?? ? ? ?? ??? ?? ????. ? ? data ? ??? column?? ?? ??? ??. test_influxdb,srcip=123.198.82.192 dstip="50.230.44.173",srcport=9978,dstport=782,protocol=16,eventlog="GET /twiki/bin/view/TWiki/KlausWriessnegger HTTP/1.1",evencod=200,eventsize=3848 1479265350401897972 test_influxdb,srcip=58.208.78.121
  • 5. Error! Use the Home tab to apply ?? 1 to the text that you want to appear here. 2 dstip="231.146.69.51",srcport=2330,dstport=3082,protocol=46,eventlog="GET /twiki/bin/view/TWiki/ManagingWebs?rev=1.22 HTTP/1.1",evencod=200,eventsize=9310 1479265197208287210 1.3.1 InfiniFlux ??? ? ??? ?? create table sampletable ( AT1 datetime property (MINMAX_CACHE_SIZE=1048576) not null, SRCIP ipv4, SCRPORT integer, DSTIP ipv4, DSTPORT integer, PROTOCOL short, eventlog varchar(1024), eventcode short, eventsize long ); ? Index ?? create index idx2 on sampletable(srcip) index_type lsm max_level=3; create index idx3 on sampletable(dstip) index_type lsm max_level=3; create keyword index idx4 on sampletable(eventlog) index_type lsm max_level=3; - ???? ??? ? ??? ??? ?? ?? - datetime ??? ?? minmax_cache ?? - ?? ??? ?? index ?? 1.3.2 InfluxDB ??? ? ??? ? Influxdb? tag key? field key? ??? tag key? ???? indexing? ??. ? ??? ??? ?? ? influxdb ?? ?? table field ? ?? ? ?? name: test_influxdb -------------------
  • 6. Error! Use the Home tab to apply ?? 1 to the text that you want to appear here. 3 tagKey srcip evencod name: test_influxdb fieldKey fieldType dstip string dstport float eventlog string eventsize float protocol float srcport float - ???? ??? ? ?? ???? ?? ?? ?? ?? - tag key? srcip ? ???? ?? (group by ?? ???) - ??? ?? ??? ?? ? table ?? column??? ?? ?? ??? ??? ??? ?? ???? ?? ???? 1.4 ?? ??? ?? ? InfiniFlux ?? ??? (1?? 13GB) -rw-rw-r--. 1 demo demo 13045863917 May 20 11:15 sampletable100m.csv ? Influxdb ?? ??? (1?? 20GB) ? ??? ??? ??? ?? ?? ? ?? ?? ??? data ?? ??? ?? -rw-rw-r-- 1 perf perf 21253641580 Nov 16 13:37 sampletable100m.csv
  • 7. Error! Use the Home tab to apply ?? 1 to the text that you want to appear here. 4 2. ?? ??? 2.1 ??? ?? 2.1.1 InfiniFlux ??? ?? InfiniFlux ? ???? ?? ?? ??? InfiniFlux ?? ???? ifluxloader tool? ???? CSV ??? ???? ?? ?? ??? ?? ??? ?? ??? ?? ?? ?? EPS sampletable100m.csv sampletable 1?? 13GB 4.96 min 336,022 - ?? 1??? ??? ?? 33??? ???? ??. 2.1.2 Influxdb ??? ?? Influxdb? ??? ???? ??? influx -import -path=sampletable100m.csv -precision=ns ???? ?? ??? txt ??? ??? ?? ?? ??? ?? ??? ?? ??? ?? ?? ?? EPS sampletable100m.csv test_influxdb 1?? 20GB 48.18 min 39,117 - ?? 1??? ??? ?? ?3.9??? ??? ?? 2.1.3 InfiniFlux vs Influxdb - ??? ?? InfiniFlux ? ?? ??? Influxdb?? 10? ?? ?? - Influxdb? ??? ???? ????? ?? ?? ??? ???? ?? ?? 39,117 336022 0 100,000 200,000 300,000 400,000 ?? ?? ?? Influxdb InfiniFlux
  • 8. Error! Use the Home tab to apply ?? 1 to the text that you want to appear here. 5 2.2 DISK ?? ?? InfiniFlux? ???? ?? ? ? ???? ?? ?? ??? ??? ??? ??? ??? ?? ? ? ??. - 13GB ? ???? ??? InfiniFlux ? 5GB? , 20GB? ???? Influxdb? 20GB ? ?? ??? ????. - InfiniFlux? ???? 62%?? Influxdb? ???? 0%?? ???. 2.3 ??? ?? ?? ? ??? ??? ??? dstat ? 5? ???? ?? ? ?? ? ??? ??? ??? ?? ????? ?? ?? ??? ????? ?? 2.3.1 CPU ??? Influxdb ? ?? ??? ?? ?? ?? 35% ? CPU? ???? ??? ?? ? InfiniFlux ? ?? 24% ? CPU ? ?? 0 5 10 15 20 25 ?? ?? Influxdb InfiniFlux 0 50 100 100 235 370 505 640 775 910 1045 1180 1315 1450 1585 1720 1855 1990 2125 2260 2395 2530 2665 2800 CPU ??? influxdb InfinFlux
  • 9. Error! Use the Home tab to apply ?? 1 to the text that you want to appear here. 6 2.3.2 Memory ??? - Influxdb ? ??? ???? ??? ?? ? ?? 1.4GB? ????, Influxdb ? ?? ?? ??? ?? ??? ??? ??. - InfiniFlux ? ?? 1.5GB? ??????, ??? ?? ??? ??? ????? ??. 2.4 ?? ??? ? Influxdb ??? ?? GROUP BY? tag key? ? ???? ?? ??? ??? ? ?? ?? ??. ? Test? srcip???? tag key ???? ?? ??? ? group by? ??. ? group by? ?? select? ?? ??? ???? ?? ?? ????. ? Influxdb???? ??? ?? ??? ?? ??? ??? ??? ns ?? ?? ? ?? ??? ?? ??? select count(*) from test_cli..test_influxdb ? ?? ?? ?? select count(*) from test_cli..test_influxdb where (srcip='31.224.72.52' and dstip='86.45.186.17'); 0 1000000 2000000 65 165 265 365 465 565 665 765 865 965 1065 1165 1265 1365 1465 1565 1665 1765 1865 1965 2065 2165 2265 2365 2465 2565 2665 2765 2865 Memory ??? Influxdb InfinFlux
  • 10. Error! Use the Home tab to apply ?? 1 to the text that you want to appear here. 7 ? ?? ?? ?? select count(dstip), min(dstport),max(dstport), mean("eventsize") from test_cli..test_influxdb where (dstport <= 1000 and dstport >= 100) and evencod=200 group by srcip ? Group by average ?? select mean(eventsize) from test_cli..test_influxdb group by evencod ? Group by count ?? select count(*) from test_cli..test_influxdb group by evencod ? Group by ?? ?? select sum(eventsize) from test_cli..test_influxdb group by evencod ? Group by STDDEV ?? ?? Select stddev(eventsize) from test_cli..test_influxdb group by evencod ? ?? ?? InfiniFlux Influxdb ???(??) ?? ??? 0.000 ? 34.957 ? 1?? ?? ?? ?? 0.214 ? 4.245 ? 17,640 Group by AVERAGE for full-scan 11.076 ? 8.36 ? (?? ??, Full scan? ???? ??) 401 12848 200 9599.9949 Group by count 7.738 ? 40.673 ? 401 19998781 200 80001219 Group by SUM 11.838 ? 6.49 ? 401
  • 11. Error! Use the Home tab to apply ?? 1 to the text that you want to appear here. 8 For full-scan (?? ??, Full scan? ???? ??) 256944328701 200 768010626424 Group by STDDEV 14.869 ? 303.034 ? 401 2.44939 200 12544.2 ?? ?? ?? 30.852 ? 52.126 ? 75ROWS
  • 12. Error! Use the Home tab to apply ?? 1 to the text that you want to appear here. 9 3. ??? ?? ? InfiniFlux VS Influxdb??? ?? ?? InfiniFlux Influxdb ?? ?? ??? sampletable100m.csv (1??, 13GB) ???? ????? CPU ???(%) 24% 35% 100% = 8 core ?? 1.5? ?? ?? ??? ???(GB) 1.5GB 1.4GB 1.1? ?? ?? DISK ???(GB) 5GB 20GB ???? Infiniflux 65%?? Influxdb 0%?? ?? ?? ??(EPS) 336,022 EPS 39,117 EPS 9? ?? ?? ?? ??? 0.000 ? 34.957 ? ???? 1?? ?? ?? 0.214 ? 4.245 ? ???? 1.7?? ?? ?? 30.852 ? 52.126 ? 75ROWS GROUP BY AVERAGE 11.076 ? 8.36 ? 401 12848 200 9599.99 GROUP BY COUNT 7.738 ? 40.673 ? 401 19998781 200 80001219 GROUP BY SUM 11.83 ? 6.49 ? 401 256944328701 200 768010626424 GROUP BY STDDEV 14.869 ? 303.034 ? 401 2.44939 200 12544.2 - InfiniFlux ? Influxdb? ????? SQL ?? ???? ?? ?????, ???? ?? ???? ?? ??? ?? - db??? database?? ??? ?? ? ?? table ???? ?? - database ?? table?? ? ?? ?? ??? ?? - InfiniFlux ? Column ? DB? ?? ????? ?????, Influxdb? key-values ??? ??? ???? ??, case? ?? ? DB? ?? ? ????? ?? ??? ?? - ???? ???? ??? ??? InfiniFlux ? ?? DB? ?? Table schema ? ??? ??? ?? ???? ?? ?? ??? Influxdb? ?? ??? ??? ??? ?? - ?? ?? ??? ??? ??? ?? Influxdb? GROUP BY ??? tag key??? ???? ??? ??? ??, ORDER BY ? LIMIT ??? ??? ??. - ?? LIKE ??? ?? ?? ??? ??? ???(??? ¡®=¡¯ ??? ?? ). - Influxdb? ?? ?? ? ?? ?? ??? ?? ??? ??? ???? ??? ?? ??? ?? ? ? Equal ??? ??? ?? ??? ???? tag key??? ?? ?? ??? ?? ??? ? ?? ??? ?? ??? ?? ?? - ???? ?? ? ? ? ??? ?? tag key? ?? ???? ??? ??? ?? ? ?? ??? ??? ???? ???? ?? ?? ??
  • 13. Error! Use the Home tab to apply ?? 1 to the text that you want to appear here. 10 - ?? ??? ? ??? ?? 1000,000 row ???? ?? ? ? ??? ??? ?????. Conf ??? ???? ? ??? ?? ?? - Tag key? ?? ?? ??? ??? ?? ??? ????, ?? ??? ?? ????.
  • 14. Error! Use the Home tab to apply ?? 1 to the text that you want to appear here. 11 ? ???? ??? InfiniFlux ? Influxdb? ??? ?? ???. ? ??? ?? Influxdb? ???? ?????? ??? ???? ??? InfiniFlux?? ?? ??? ????. Influxdb ?? ???? ?? ???? ??? ?? ??? ????? ???? ??. ? ??? ?? tag key? ???? ? tag key? ??? ???? ?? ???? ???? ??? ?? ?? ? ??. ?? ???? ?? ?? row? ??? ?? ??? ? ???? ?? ???? ??? ?? ??? ???? ? ??. ??? tag key??? ? ??? ???? ??, ??? ?? ?? ?? ??? ???? ???? ??? ?? ??? ?? ????. ?? ???? tag key? ???? ?? ??? ?? ??? ?? ???? ??? ?? ??? ? ??? ?? ?? ??? ? ? ???? ?? ?? ???. ??? InfiniFlux ? ?? ??? ??? ?? ?? ?? ??? ????, ??? ??? ???? ???? ??? ???? ??? ??? ??? ????.