THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
其它类似，不再赘述。
二、实验结果
改变压缩方式
人工数据实验结果
RLCompressionSynExpScripts.sh| 压缩方式 | GZIP | LZ4 | SNAPPY | UNCOMPRESSED |
| dataset | synthetic | synthetic | synthetic | synthetic |
| pagePointNum(ppn) | 10000 | 10000 | 10000 | 10000 |
| numOfPagesInChunk(pic) | 1000 | 1000 | 1000 | 1000 |
| chunksWritten(cw) | 10 | 10 | 10 | 10 |
| timeEncoding(te) | TS_2DIFF | TS_2DIFF | TS_2DIFF | TS_2DIFF |
| valueDataType(vt) | INT64 | INT64 | INT64 | INT64 |
| valueEncoding(ve) | PLAIN | PLAIN | PLAIN | PLAIN |
| compression(co) | GZIP | LZ4 | SNAPPY | UNCOMPRESSED |
| totalPointNum | 100000000 | 100000000 | 100000000 | 100000000 |
| tsfileSize(MB) | 767.1312866 | 770.8444319 | 767.9423904 | 781.4226151 |
| chunkDataSize_stats_mean(MB) | 76.71300761 | 77.08436436 | 76.7941264 | 78.14216614 |
| compressedPageSize_stats_mean(B) | 80375.41867 | 80764.81444 | 80460.47789 | 81874 |
| uncompressedPageSize_stats_mean(B) | 81874 | 81874 | 81874 | 81874 |
| timeBufferSize_stats_mean(B) | 1872 | 1872 | 1872 | 1872 |
| valueBufferSize_stats_mean(B) | 80000 | 80000 | 80000 | 80000 |
| [1] each step | ||||
| [Avg&Per] (A)1_index_read_deserialize_MagicString_FileMetadataSize(us) | 26642.8733 us - 0.24422388846191903% | 11918.6528 us - 0.16062988779113208% | 10188.2737 us - 0.1309325873262339% | 10953.8906 us - 0.14619657707769018% |
| [Avg&Per] (A)2_index_read_deserialize_IndexRootNode_MetaOffset_BloomFilter(us) | 5777.7715 us - 0.05296237408352104% | 5484.9663 us - 0.07392190510886776% | 5140.9507 us - 0.0660679126109081% | 6219.5857 us - 0.08300997092132265% |
| [Avg&Per] (A)3_2_index_read_deserialize_IndexRootNode_exclude_to_TimeseriesMetadata_forExactGet(us) | 69234.1118 us - 0.6346396579532295% | 69331.4945 us - 0.9343933722044904% | 67589.2748 us - 0.8686102165735712% | 76722.6646 us - 1.0239823783523703% |
| [Avg&Per] (B)4_data_read_deserialize_ChunkHeader(us) | 8684.7625 us - 0.07960952425196037% | 10008.712599999999 us - 0.13488927052826724% | 4487.9059 us - 0.05767543633654741% | 7069.0819 us - 0.09434780888370882% |
| [Avg&Per] (B)5_data_read_ChunkData(us) | 5940909.1292 us - 54.457787348789346% | 4839621.4844 us - 65.22447369141621% | 5082130.2731 us - 65.31199351132103% | 4844317.4031 us - 64.65489281142766% |
| [Avg&Per] (C)6_data_deserialize_PageHeader(us) | 6613.381399999991 us - 0.060622054656159316% | 7120.158900000014 us - 0.09595969816001626% | 7692.346500000014 us - 0.09885667184764595% | 7605.696300000007 us - 0.10150975630087579% |
| [Avg&Per] (D-1)7_data_decompress_PageData(us) | 2859428.0031000106 us - 26.211160404158996% | 521804.2723000004 us - 7.032452670194604% | 605202.8143000009 us - 7.777644443672276% | 498170.42259999976 us - 6.648853201570805% |
| [Avg&Per] (D-2)8_data_decode_PageData(us) | 1991910.319299996 us - 18.25899474764487% | 1954657.4198999994 us - 26.343279504596413% | 1998880.5966999987 us - 25.68821922031179% | 2041517.9070999995 us - 27.247207495465567% |
| [2] category: (A)get ChunkStatistic->(B)load on-disk Chunk->(C)get PageStatistics->(D)load in-memory PageData | ||||
| [Avg&Per] (A)get_chunkMetadatas | 101654.7566 us - 0.9318259204986696% | 86735.1136 us - 1.1689451651044902% | 82918.49919999999 us - 1.0656107165107132% | 93896.1409 us - 1.2531889263513831% |
| [Avg&Per] (B)load_on_disk_chunk | 5949593.8917000005 us - 54.53739687304131% | 4849630.197000001 us - 65.35936296194448% | 5086618.179 us - 65.36966894765757% | 4851386.484999999 us - 64.74924062031137% |
| [Avg&Per] (C)get_pageHeader | 6613.381399999991 us - 0.060622054656159316% | 7120.158900000014 us - 0.09595969816001626% | 7692.346500000014 us - 0.09885667184764595% | 7605.696300000007 us - 0.10150975630087579% |
| [Avg&Per] (D_1)decompress_pageData | 2859428.0031000106 us - 26.211160404158996% | 521804.2723000004 us - 7.032452670194604% | 605202.8143000009 us - 7.777644443672276% | 498170.42259999976 us - 6.648853201570805% |
| [Avg&Per] (D_2)decode_pageData | 1991910.319299996 us - 18.25899474764487% | 1954657.4198999994 us - 26.343279504596413% | 1998880.5966999987 us - 25.68821922031179% | 2041517.9070999995 us - 27.247207495465567% |
| [3] D_1 compare each step inside | ||||
| [Avg&Per] (D-1)7_1_data_ByteBuffer_to_ByteArray(us) | 65952.37819999998 us - 2.5136549346918415% | 108809.34350000018 us - 59.6896105506002% | 108132.35939999981 us - 43.622622294156905% | 110765.11740000003 us - 63.813731447511664% |
| [Avg&Per] (D-1)7_2_data_decompress_PageDataByteArray(us) | 2554687.926599999 us - 97.36728361519128% | 68904.38600000006 us - 37.79892271446546% | 135345.91170000008 us - 54.601079805416944% | 57547.215800000035 us - 33.15396273496119% |
| [Avg&Per] (D-1)7_3_data_ByteArray_to_ByteBuffer(us) | 811.8335000000624 us - 0.03094155721322126% | 1239.949800000022 us - 0.680200047933345% | 1184.7460000000272 us - 0.47794876167766753% | 1229.1439000000355 us - 0.7081314098345313% |
| [Avg&Per] (D-1)7_4_data_split_time_value_Buffer(us) | 2312.0582000000422 us - 0.08811989290364733% | 3338.2513999999974 us - 1.8312666870009688% | 3218.3657999999955 us - 1.29834913874849% | 4034.201500000018 us - 2.3241744076926314% |
| [3] D_2 compare each step inside | ||||
| [Avg&Per] (D-2)8_1_createBatchData(us) | 5384.7852 us - 0.053292019060348375% | 5848.7599 us - 0.05759123169122766% | 5913.4963 us - 0.058362326692940975% | 6019.3023 us - 0.05943520403215091% |
| [Avg&Per] (D-2)8_2_timeDecoder_hasNext(us) | 1859842.2956 us - 18.406444711361424% | 1862234.7849 us - 18.336946086748988% | 1864092.3926 us - 18.397368271414525% | 1857778.6739 us - 18.343895858133802% |
| [Avg&Per] (D-2)8_3_timeDecoder_readLong(us) | 2074757.7936 us - 20.533415498567617% | 2084700.4377 us - 20.527508047369906% | 2063043.8916 us - 20.360888969091857% | 2069930.4964 us - 20.43870456313607% |
| [Avg&Per] (D-2)8_4_valueDecoder_read(us) | 1876012.952 us - 18.56648209392724% | 1881471.5433999998 us - 18.526365490982297% | 1877809.2412 us - 18.532744562964893% | 1876843.1276 us - 18.53214021585961% |
| [Avg&Per] (D-2)8_5_checkValueSatisfyOrNot(us) | 1780379.6374 us - 17.620020492363725% | 1780782.3133 us - 17.534904586680103% | 1781949.2049 us - 17.586668929952697% | 1780599.5789 us - 17.5818216126948% |
| [Avg&Per] (D-2)8_6_putIntoBatchData(us) | 2507922.0072 us - 24.82034518471963% | 2540605.1784 us - 25.016684556527476% | 2539577.912 us - 25.063966939883077% | 2536332.2055 us - 25.044002546143567% |
...
RLCompressionRealExpScripts.shZT11529传感器数据如下图所示，共12,780,287个点。
...
| 压缩方式 | GZIP | LZ4 | SNAPPY | UNCOMPRESSED |
| dataset | /disk/rl/zc_data/ZT11529.csv | /disk/rl/zc_data/ZT11529.csv | /disk/rl/zc_data/ZT11529.csv | /disk/rl/zc_data/ZT11529.csv |
| pagePointNum(ppn) | 10000 | 10000 | 10000 | 10000 |
| numOfPagesInChunk(pic) | 100 | 100 | 100 | 100 |
| chunksWritten(cw) | 13 | 13 | 13 | 13 |
| timeEncoding(te) | TS_2DIFF | TS_2DIFF | TS_2DIFF | TS_2DIFF |
| valueDataType(vt) | DOUBLE | DOUBLE | DOUBLE | DOUBLE |
| valueEncoding(ve) | GORILLA | GORILLA | GORILLA | GORILLA |
| compression(co) | GZIP | LZ4 | SNAPPY | UNCOMPRESSED |
| totalPointNum | 12780287 | 12780287 | 12780287 | 12780287 |
| tsfileSize(MB) | 19.34862614 | 23.77741051 | 23.15641212 | 36.30773735 |
| chunkDataSize_stats_mean(MB) | 1.515139659 | 1.86007007 | 1.813184341 | 2.837062438 |
| compressedPageSize_stats_mean(B) | 15824.16667 | 19440.275 | 18948.69 | 29684.7575 |
| uncompressedPageSize_stats_mean(B) | 29684.7575 | 29684.7575 | 29684.7575 | 29684.7575 |
| timeBufferSize_stats_mean(B) | 11461.4625 | 11461.4625 | 11461.4625 | 11461.4625 |
| valueBufferSize_stats_mean(B) | 18221.26833 | 18221.26833 | 18221.26833 | 18221.26833 |
| [1] each step | ||||
| [Avg&Per] (A)1_index_read_deserialize_MagicString_FileMetadataSize(us) | 10294.8866 us - 0.9666637540862395% | 17480.267 us - 2.1945906166045948% | 10013.4112 us - 1.2534900973847278% | 12118.2366 us - 1.4111012934589997% |
| [Avg&Per] (A)2_index_read_deserialize_IndexRootNode_MetaOffset_BloomFilter(us) | 5024.5339 us - 0.4717909959598364% | 8883.9004 us - 1.115344774578661% | 4736.353 us - 0.5929020055841159% | 5782.8723 us - 0.6733833355290506% |
| [Avg&Per] (A)3_2_index_read_deserialize_IndexRootNode_exclude_to_TimeseriesMetadata_forExactGet(us) | 71997.4296 us - 6.760376125143112% | 73925.4742 us - 9.281102628888053% | 74716.8403 us - 9.353138261607208% | 70859.6681 us - 8.251214480330036% |
| [Avg&Per] (B)4_data_read_deserialize_ChunkHeader(us) | 8457.0026 us - 0.7940911055429293% | 4862.6532 us - 0.6104902793831642% | 4758.252799999999 us - 0.5956434472253724% | 2203.0548 us - 0.25653348589027036% |
| [Avg&Per] (B)5_data_read_ChunkData(us) | 152242.5999 us - 14.295194193900432% | 171922.22919999997 us - 21.584276200590327% | 101044.6856 us - 12.648887603152982% | 189315.798 us - 22.04477237472181% |
| [Avg&Per] (C)6_data_deserialize_PageHeader(us) | 2436.5129999999995 us - 0.22878239411203669% | 2198.3668000000007 us - 0.27599779517870476% | 2319.9517000000005 us - 0.29041416798711567% | 3134.228800000001 us - 0.3649635223062446% |
| [Avg&Per] (D-1)7_data_decompress_PageData(us) | 356587.5454999999 us - 33.482666568996265% | 31158.160799999983 us - 3.911805656191469% | 115629.7179 us - 14.474658381255693% | 29640.983400000016 us - 3.4515277590088287% |
| [Avg&Per] (D-2)8_data_decode_PageData(us) | 457950.96670000016 us - 43.000434862259155% | 486085.0215000002 us - 61.02639204858503% | 485623.25309999986 us - 60.790866035802786% | 545723.8052999998 us - 63.54650374875476% |
| [2] category: (A)get ChunkStatistic->(B)load on-disk Chunk->(C)get PageStatistics->(D)load in-memory PageData | ||||
| [Avg&Per] (A)get_chunkMetadatas | 87316.85010000001 us - 8.19883087518919% | 100289.6416 us - 12.59103802007131% | 89466.6045 us - 11.199530364576052% | 88760.777 us - 10.335699109318087% |
| [Avg&Per] (B)load_on_disk_chunk | 160699.6025 us - 15.089285299443361% | 176784.88239999997 us - 22.19476647997349% | 105802.9384 us - 13.244531050378352% | 191518.85280000002 us - 22.301305860612082% |
| [Avg&Per] (C)get_pageHeader | 2436.5129999999995 us - 0.22878239411203669% | 2198.3668000000007 us - 0.27599779517870476% | 2319.9517000000005 us - 0.29041416798711567% | 3134.228800000001 us - 0.3649635223062446% |
| [Avg&Per] (D_1)decompress_pageData | 356587.5454999999 us - 33.482666568996265% | 31158.160799999983 us - 3.911805656191469% | 115629.7179 us - 14.474658381255693% | 29640.983400000016 us - 3.4515277590088287% |
| [Avg&Per] (D_2)decode_pageData | 457950.96670000016 us - 43.000434862259155% | 486085.0215000002 us - 61.02639204858503% | 485623.25309999986 us - 60.790866035802786% | 545723.8052999998 us - 63.54650374875476% |
| [3] D_1 compare each step inside | ||||
| [Avg&Per] (D-1)7_1_data_ByteBuffer_to_ByteArray(us) | ||||
| [Avg&Per] (D-1)7_2_data_decompress_PageDataByteArray(us) | ||||
| [Avg&Per] (D-1)7_3_data_ByteArray_to_ByteBuffer(us) | ||||
| [Avg&Per] (D-1)7_4_data_split_time_value_Buffer(us) | ||||
| [3] D_2 compare each step inside | ||||
| [Avg&Per] (D-2)8_1_createBatchData(us) | ||||
| [Avg&Per] (D-2)8_2_timeDecoder_hasNext(us) | ||||
| [Avg&Per] (D-2)8_3_timeDecoder_readLong(us) | ||||
| [Avg&Per] (D-2)8_4_valueDecoder_read(us) | ||||
| [Avg&Per] (D-2)8_5_checkValueSatisfyOrNot(us) | ||||
| [Avg&Per] (D-2)8_6_putIntoBatchData(us) | ||||
改变编码方式
人工数据实验结果
RLValueEncodingSynExpScripts.shRLValueEncodingRealExpScripts.sh