LevelDB初体验

原创 2012年10月19日 22:25:19

        最近工作需要找一个能使用磁盘存储数据,对写要求比较苛刻,需要每秒达100000TPS,读的时候需要能10000TPS左右,不能占用太多内存。单节点满足这个要求的常见有Redis、Memcached等,但是这个东西太费内存了,代价比较高,不太合适。找来找去,找到Leveldb这个神器了,在写的时候对内存要求不高,读的时候根据性能要求的不同需要对应的内存,如果使用SSD就是完美搭配了。

         目前主要测试写入性能,发现Leveldb还是使用单线程插入最为高效,但是写入性能非常惊人。

         测试数据:

         key=timeline+【0,20亿】

         value=128字节

        测试环境:

        CPU:16核,Mem:32G  磁盘:SSD  

       写入客户端:

        leveldbjni+1Java thread ,write_buffer_size=512MB

      插入20亿条数据的统计数据如下:

         插入数据过程中,CPU消耗比较小,多的时候在160%,少的时候在80%左右,插入过程中对内存消耗比较小,与设定的512MB比较接近,没有大的变化,load小于1;

         插入完成之后,磁盘文件总个数为14913个,占用磁盘存储空间31G。

         全局的avgTps=149594,以插入500W条数据的时候,阶段性的minTps=84631,maxTps=234796。


      插入50亿条数据的统计数据如下:

         插入数据过程中,CPU消耗比较小,多的时候在160%,少的时候在80%左右,插入过程中对内存消耗比较小,与设定的512MB比较接近,没有大的变化,load小于1;

         插入完成之后,磁盘文件总个数为32318个,占用磁盘存储空间77G。

         全局的avgTps=158272,以插入1000W条数据的为基准阶段性的minTps=100000,maxTps=232558。



     附注(1)以下为插入20亿条数据,以每插入500W记录为周期统计的消耗时长、阶段性TPS

 time=1350637138963;value length=128;threadcount=1;writeBufferSize=536870912 userId=105000000;time=28702;tps=174203
userId=110000000;time=22627;tps=220974
userId=115000000;time=22378;tps=223433
userId=120000000;time=21954;tps=227748
userId=125000000;time=24661;tps=202749
userId=130000000;time=24621;tps=203078
userId=135000000;time=22419;tps=223025
userId=140000000;time=22577;tps=221464
userId=145000000;time=22672;tps=220536
userId=150000000;time=22060;tps=226654
userId=155000000;time=23259;tps=214970
userId=160000000;time=25119;tps=199052
userId=165000000;time=21295;tps=234796
userId=170000000;time=23003;tps=217362
userId=175000000;time=31368;tps=159398
userId=180000000;time=28736;tps=173997
userId=185000000;time=31988;tps=156308
userId=190000000;time=32608;tps=153336
userId=195000000;time=29368;tps=170253
userId=200000000;time=33736;tps=148209
userId=205000000;time=31692;tps=157768
userId=210000000;time=28926;tps=172854
userId=215000000;time=26534;tps=188437
userId=220000000;time=34175;tps=146305
userId=225000000;time=30050;tps=166389
userId=230000000;time=28801;tps=173605
userId=235000000;time=34200;tps=146198
userId=240000000;time=34519;tps=144847
userId=245000000;time=30616;tps=163313
userId=250000000;time=32274;tps=154923
userId=255000000;time=36475;tps=137080
userId=260000000;time=30212;tps=165497
userId=265000000;time=33675;tps=148478
userId=270000000;time=34482;tps=145003
userId=275000000;time=31272;tps=159887
userId=280000000;time=31560;tps=158428
userId=285000000;time=34383;tps=145420
userId=290000000;time=30656;tps=163100
userId=295000000;time=29920;tps=167112
userId=300000000;time=35273;tps=141751
userId=305000000;time=34326;tps=145662
userId=310000000;time=30582;tps=163494
userId=315000000;time=32718;tps=152821
userId=320000000;time=36229;tps=138010
userId=325000000;time=27864;tps=179443
userId=330000000;time=33688;tps=148420
userId=335000000;time=34432;tps=145213
userId=340000000;time=30738;tps=162665
userId=345000000;time=31541;tps=158523
userId=350000000;time=35115;tps=142389
userId=355000000;time=31672;tps=157868
userId=360000000;time=29653;tps=168617
userId=365000000;time=35518;tps=140773
userId=370000000;time=35205;tps=142025
userId=375000000;time=30074;tps=166256
userId=380000000;time=35801;tps=139660
userId=385000000;time=33817;tps=147854
userId=390000000;time=30200;tps=165562
userId=395000000;time=32035;tps=156079
userId=400000000;time=36775;tps=135961
userId=405000000;time=31807;tps=157198
userId=410000000;time=28805;tps=173580
userId=415000000;time=34873;tps=143377
userId=420000000;time=31935;tps=156568
userId=425000000;time=32728;tps=152774
userId=430000000;time=34386;tps=145408
userId=435000000;time=34962;tps=143012
userId=440000000;time=30370;tps=164636
userId=445000000;time=35149;tps=142251
userId=450000000;time=33206;tps=150575
userId=455000000;time=29053;tps=172099
userId=460000000;time=34907;tps=143237
userId=465000000;time=35040;tps=142694
userId=470000000;time=31500;tps=158730
userId=475000000;time=31686;tps=157798
userId=480000000;time=37053;tps=134941
userId=485000000;time=31729;tps=157584
userId=490000000;time=31866;tps=156907
userId=495000000;time=35823;tps=139575
userId=500000000;time=32696;tps=152923
userId=505000000;time=28951;tps=172705
userId=510000000;time=34913;tps=143213
userId=515000000;time=33884;tps=147562
userId=520000000;time=29208;tps=171185
userId=525000000;time=33237;tps=150434
userId=530000000;time=36608;tps=136582
userId=535000000;time=30892;tps=161854
userId=540000000;time=33490;tps=149298
userId=545000000;time=35049;tps=142657
userId=550000000;time=31721;tps=157624
userId=555000000;time=30321;tps=164902
userId=560000000;time=32762;tps=152615
userId=565000000;time=32414;tps=154254
userId=570000000;time=33051;tps=151281
userId=575000000;time=33819;tps=147845
userId=580000000;time=33859;tps=147671
userId=585000000;time=28958;tps=172663
userId=590000000;time=34050;tps=146842
userId=595000000;time=34223;tps=146100
userId=600000000;time=31439;tps=159038
userId=605000000;time=33123;tps=150952
userId=610000000;time=32838;tps=152262
userId=615000000;time=30054;tps=166367
userId=620000000;time=31932;tps=156582
userId=625000000;time=35260;tps=141803
userId=630000000;time=32853;tps=152193
userId=635000000;time=28055;tps=178221
userId=640000000;time=32883;tps=152054
userId=645000000;time=33659;tps=148548
userId=650000000;time=30843;tps=162111
userId=655000000;time=33767;tps=148073
userId=660000000;time=35561;tps=140603
userId=665000000;time=29081;tps=171933
userId=670000000;time=30721;tps=162755
userId=675000000;time=35277;tps=141735
userId=680000000;time=32928;tps=151846
userId=685000000;time=31103;tps=160756
userId=690000000;time=34783;tps=143748
userId=695000000;time=33415;tps=149633
userId=700000000;time=29759;tps=168016
userId=705000000;time=32788;tps=152494
userId=710000000;time=33461;tps=149427
userId=715000000;time=30305;tps=164989
userId=720000000;time=33783;tps=148003
userId=725000000;time=33044;tps=151313
userId=730000000;time=31392;tps=159276
userId=735000000;time=35156;tps=142223
userId=740000000;time=34658;tps=144266
userId=745000000;time=31909;tps=156695
userId=750000000;time=33009;tps=151473
userId=755000000;time=35631;tps=140327
userId=760000000;time=34438;tps=145188
userId=765000000;time=30656;tps=163100
userId=770000000;time=34348;tps=145568
userId=775000000;time=34512;tps=144877
userId=780000000;time=29456;tps=169744
userId=785000000;time=33151;tps=150825
userId=790000000;time=37063;tps=134905
userId=795000000;time=30531;tps=163767
userId=800000000;time=32747;tps=152685
userId=805000000;time=35159;tps=142211
userId=810000000;time=29371;tps=170235
userId=815000000;time=28618;tps=174715
userId=820000000;time=35237;tps=141896
userId=825000000;time=33882;tps=147570
userId=830000000;time=28971;tps=172586
userId=835000000;time=35485;tps=140904
userId=840000000;time=34224;tps=146096
userId=845000000;time=30354;tps=164722
userId=850000000;time=32211;tps=155226
userId=855000000;time=34024;tps=146955
userId=860000000;time=31852;tps=156976
userId=865000000;time=32739;tps=152723
userId=870000000;time=35553;tps=140635
userId=875000000;time=31557;tps=158443
userId=880000000;time=31335;tps=159565
userId=885000000;time=37602;tps=132971
userId=890000000;time=33602;tps=148800
userId=895000000;time=30080;tps=166223
userId=900000000;time=35045;tps=142673
userId=905000000;time=33272;tps=150276
userId=910000000;time=29433;tps=169877
userId=915000000;time=36635;tps=136481
userId=920000000;time=34563;tps=144663
userId=925000000;time=29863;tps=167431
userId=930000000;time=33920;tps=147405
userId=935000000;time=35229;tps=141928
userId=940000000;time=30953;tps=161535
userId=945000000;time=30155;tps=165809
userId=950000000;time=37350;tps=133868
userId=955000000;time=32373;tps=154449
userId=960000000;time=29294;tps=170683
userId=965000000;time=34465;tps=145074
userId=970000000;time=35298;tps=141651
userId=975000000;time=27480;tps=181950
userId=980000000;time=32417;tps=154240
userId=985000000;time=34378;tps=145441
userId=990000000;time=30751;tps=162596
userId=995000000;time=31766;tps=157400
userId=1000000000;time=36091;tps=138538
userId=1005000000;time=25639;tps=195015
userId=1010000000;time=32895;tps=151998
userId=1015000000;time=48094;tps=103963
userId=1020000000;time=55090;tps=90760
userId=1025000000;time=45586;tps=109682
userId=1030000000;time=47333;tps=105634
userId=1035000000;time=40203;tps=124368
userId=1040000000;time=39471;tps=126675
userId=1045000000;time=43462;tps=115043
userId=1050000000;time=40104;tps=124675
userId=1055000000;time=36350;tps=137551
userId=1060000000;time=44028;tps=113564
userId=1065000000;time=42966;tps=116371
userId=1070000000;time=40150;tps=124533
userId=1075000000;time=37139;tps=134629
userId=1080000000;time=37487;tps=133379
userId=1085000000;time=32120;tps=155666
userId=1090000000;time=30394;tps=164506
userId=1095000000;time=33210;tps=150557
userId=1100000000;time=33076;tps=151167
userId=1105000000;time=27400;tps=182481
userId=1110000000;time=32822;tps=152336
userId=1115000000;time=35184;tps=142110
userId=1120000000;time=30721;tps=162755
userId=1125000000;time=30270;tps=165180
userId=1130000000;time=35749;tps=139864
userId=1135000000;time=30347;tps=164760
userId=1140000000;time=30831;tps=162174
userId=1145000000;time=32440;tps=154130
userId=1150000000;time=32239;tps=155091
userId=1155000000;time=30278;tps=165136
userId=1160000000;time=32241;tps=155082
userId=1165000000;time=33918;tps=147414
userId=1170000000;time=29459;tps=169727
userId=1175000000;time=34843;tps=143500
userId=1180000000;time=34564;tps=144659
userId=1185000000;time=30312;tps=164951
userId=1190000000;time=30550;tps=163666
userId=1195000000;time=33171;tps=150734
userId=1200000000;time=32894;tps=152003
userId=1205000000;time=30539;tps=163725
userId=1210000000;time=34075;tps=146735
userId=1215000000;time=33284;tps=150222
userId=1220000000;time=28248;tps=177003
userId=1225000000;time=35039;tps=142698
userId=1230000000;time=34042;tps=146877
userId=1235000000;time=29676;tps=168486
userId=1240000000;time=33208;tps=150566
userId=1245000000;time=36943;tps=135343
userId=1250000000;time=31042;tps=161072
userId=1255000000;time=30162;tps=165771
userId=1260000000;time=33851;tps=147706
userId=1265000000;time=32130;tps=155617
userId=1270000000;time=30464;tps=164128
userId=1275000000;time=32878;tps=152077
userId=1280000000;time=30705;tps=162839
userId=1285000000;time=30610;tps=163345
userId=1290000000;time=33527;tps=149133
userId=1295000000;time=32086;tps=155831
userId=1300000000;time=30098;tps=166123
userId=1305000000;time=33462;tps=149423
userId=1310000000;time=36674;tps=136336
userId=1315000000;time=32003;tps=156235
userId=1320000000;time=34164;tps=146352
userId=1325000000;time=33083;tps=151135
userId=1330000000;time=31204;tps=160235
userId=1335000000;time=30051;tps=166383
userId=1340000000;time=34148;tps=146421
userId=1345000000;time=34210;tps=146156
userId=1350000000;time=28439;tps=175814
userId=1355000000;time=35371;tps=141358
userId=1360000000;time=35163;tps=142194
userId=1365000000;time=26939;tps=185604
userId=1370000000;time=32980;tps=151607
userId=1375000000;time=33834;tps=147780
userId=1380000000;time=30270;tps=165180
userId=1385000000;time=33202;tps=150593
userId=1390000000;time=33723;tps=148266
userId=1395000000;time=29446;tps=169802
userId=1400000000;time=30629;tps=163243
userId=1405000000;time=34986;tps=142914
userId=1410000000;time=33075;tps=151171
userId=1415000000;time=29396;tps=170091
userId=1420000000;time=33998;tps=147067
userId=1425000000;time=32730;tps=152765
userId=1430000000;time=30869;tps=161974
userId=1435000000;time=32435;tps=154154
userId=1440000000;time=30372;tps=164625
userId=1445000000;time=31953;tps=156479
userId=1450000000;time=31207;tps=160220
userId=1455000000;time=34718;tps=144017
userId=1460000000;time=31096;tps=160792
userId=1465000000;time=29505;tps=169462
userId=1470000000;time=33668;tps=148508
userId=1475000000;time=32211;tps=155226
userId=1480000000;time=26621;tps=187821
userId=1485000000;time=35733;tps=139926
userId=1490000000;time=33501;tps=149249
userId=1495000000;time=29207;tps=171191
userId=1500000000;time=32710;tps=152858
userId=1505000000;time=33970;tps=147188
userId=1510000000;time=30276;tps=165147
userId=1515000000;time=34758;tps=143851
userId=1520000000;time=34871;tps=143385
userId=1525000000;time=29980;tps=166777
userId=1530000000;time=30719;tps=162765
userId=1535000000;time=34163;tps=146357
userId=1540000000;time=32986;tps=151579
userId=1545000000;time=30820;tps=162232
userId=1550000000;time=31942;tps=156533
userId=1555000000;time=31439;tps=159038
userId=1560000000;time=29810;tps=167728
userId=1565000000;time=33300;tps=150150
userId=1570000000;time=33319;tps=150064
userId=1575000000;time=29614;tps=168839
userId=1580000000;time=33449;tps=149481
userId=1585000000;time=35726;tps=139954
userId=1590000000;time=29993;tps=166705
userId=1595000000;time=32766;tps=152597
userId=1600000000;time=34218;tps=146121
userId=1605000000;time=30652;tps=163121
userId=1610000000;time=28266;tps=176890
userId=1615000000;time=33446;tps=149494
userId=1620000000;time=32739;tps=152723
userId=1625000000;time=30259;tps=165240
userId=1630000000;time=33155;tps=150806
userId=1635000000;time=34792;tps=143711
userId=1640000000;time=30043;tps=166428
userId=1645000000;time=33068;tps=151203
userId=1650000000;time=32324;tps=154683
userId=1655000000;time=30835;tps=162153
userId=1660000000;time=32070;tps=155908
userId=1665000000;time=34448;tps=145146
userId=1670000000;time=33289;tps=150199
userId=1675000000;time=31618;tps=158137
userId=1680000000;time=34107;tps=146597
userId=1685000000;time=32916;tps=151901
userId=1690000000;time=29417;tps=169969
userId=1695000000;time=32967;tps=151666
userId=1700000000;time=34569;tps=144638
userId=1705000000;time=29646;tps=168656
userId=1710000000;time=31983;tps=156333
userId=1715000000;time=36345;tps=137570
userId=1720000000;time=43676;tps=114479
userId=1725000000;time=49378;tps=101259
userId=1730000000;time=50457;tps=99094
userId=1735000000;time=46364;tps=107842
userId=1740000000;time=52806;tps=94686
userId=1745000000;time=49885;tps=100230
userId=1750000000;time=54333;tps=92025
userId=1755000000;time=51185;tps=97684
userId=1760000000;time=45970;tps=108766
userId=1765000000;time=49856;tps=100288
userId=1770000000;time=54337;tps=92018
userId=1775000000;time=59080;tps=84631
userId=1780000000;time=48226;tps=103678
userId=1785000000;time=55823;tps=89568
userId=1790000000;time=51885;tps=96366
userId=1795000000;time=51071;tps=97902
userId=1800000000;time=49644;tps=100717
userId=1805000000;time=51576;tps=96944
userId=1810000000;time=49447;tps=101118
userId=1815000000;time=46819;tps=106794
userId=1820000000;time=53348;tps=93724
userId=1825000000;time=51505;tps=97077
userId=1830000000;time=52656;tps=94955
userId=1835000000;time=52150;tps=95877
userId=1840000000;time=53672;tps=93158
userId=1845000000;time=48107;tps=103934
userId=1850000000;time=54508;tps=91729
userId=1855000000;time=51382;tps=97310
userId=1860000000;time=47672;tps=104883
userId=1865000000;time=48916;tps=102216
userId=1870000000;time=48723;tps=102620
userId=1875000000;time=48147;tps=103848
userId=1880000000;time=50313;tps=99377
userId=1885000000;time=54073;tps=92467
userId=1890000000;time=43315;tps=115433
userId=1895000000;time=47960;tps=104253
userId=1900000000;time=52739;tps=94806
userId=1905000000;time=50603;tps=98808
userId=1910000000;time=47678;tps=104870
userId=1915000000;time=54362;tps=91976
userId=1920000000;time=50804;tps=98417
userId=1925000000;time=48548;tps=102990
userId=1930000000;time=52075;tps=96015
userId=1935000000;time=54644;tps=91501
userId=1940000000;time=50038;tps=99924
userId=1945000000;time=52062;tps=96039
userId=1950000000;time=46245;tps=108119
userId=1955000000;time=44196;tps=113132
userId=1960000000;time=47842;tps=104510
userId=1965000000;time=52230;tps=95730
userId=1970000000;time=49557;tps=100893
userId=1975000000;time=50596;tps=98822
userId=1980000000;time=49156;tps=101716
userId=1985000000;time=51486;tps=97113
userId=1990000000;time=47772;tps=104663
userId=1995000000;time=50100;tps=99800
userId=2000000000;time=53010;tps=94321

附注(2) :以下为插入50亿条数据,以每插入1000W记录为周期统计的消耗时长、阶段性TPS、全局TPS记录

time=1350646540415;value length=128;threadcount=1;writeBufferSize=536870912;insertCount=5000000000
userID=10000000;time=:47423;tps= 212765;avgTps=212765
userID=20000000;time=:67479;tps= 149253;avgTps=175438
userID=30000000;time=:88298;tps= 113636;avgTps=147783
userID=40000000;time=:55291;tps= 181818;avgTps=155038
userID=50000000;time=:56025;tps= 178571;avgTps=159235
userID=60000000;time=:66435;tps= 151515;avgTps=157894
userID=70000000;time=:61119;tps= 163934;avgTps=158371
userID=80000000;time=:60048;tps= 166666;avgTps=159362
userID=90000000;time=:67276;tps= 149253;avgTps=158172
userID=100000000;time=:60478;tps= 166666;avgTps=158982
userID=110000000;time=:78369;tps= 128205;avgTps=155367
userID=120000000;time=:63152;tps= 158730;avgTps=155642
userID=130000000;time=:61378;tps= 163934;avgTps=156250
userID=140000000;time=:65759;tps= 153846;avgTps=155902
userID=150000000;time=:58627;tps= 172413;avgTps=156739
userID=160000000;time=:62241;tps= 161290;avgTps=157016
userID=170000000;time=:66616;tps= 151515;avgTps=156537
userID=180000000;time=:91225;tps= 109890;avgTps=152931
userID=190000000;time=:94582;tps= 106382;avgTps=149488
userID=200000000;time=:94685;tps= 106382;avgTps=146412
userID=210000000;time=:100432;tps= 100000;avgTps=143246
userID=220000000;time=:90215;tps= 111111;avgTps=141297
userID=230000000;time=:85963;tps= 117647;avgTps=139987
userID=240000000;time=:74456;tps= 135135;avgTps=139778
userID=250000000;time=:78973;tps= 128205;avgTps=139198
userID=260000000;time=:74851;tps= 135135;avgTps=138963
userID=270000000;time=:83926;tps= 120481;avgTps=138107
userID=280000000;time=:77595;tps= 129870;avgTps=137795
userID=290000000;time=:70899;tps= 142857;avgTps=137898
userID=300000000;time=:65097;tps= 153846;avgTps=138376
userID=310000000;time=:60278;tps= 166666;avgTps=139075
userID=320000000;time=:66207;tps= 151515;avgTps=139433
userID=330000000;time=:62780;tps= 161290;avgTps=139949
userID=340000000;time=:60873;tps= 166666;avgTps=140553
userID=350000000;time=:68152;tps= 147058;avgTps=140731
userID=360000000;time=:61745;tps= 163934;avgTps=141287
userID=370000000;time=:63036;tps= 158730;avgTps=141708
userID=380000000;time=:63629;tps= 158730;avgTps=142056
userID=390000000;time=:62511;tps= 161290;avgTps=142439
userID=400000000;time=:67835;tps= 149253;avgTps=142602
userID=410000000;time=:64287;tps= 156250;avgTps=142857
userID=420000000;time=:68234;tps= 147058;avgTps=142954
userID=430000000;time=:65476;tps= 153846;avgTps=143190
userID=440000000;time=:64909;tps= 156250;avgTps=143415
userID=450000000;time=:64844;tps= 156250;avgTps=143632
userID=460000000;time=:62887;tps= 161290;avgTps=143929
userID=470000000;time=:66562;tps= 151515;avgTps=144039
userID=480000000;time=:66390;tps= 151515;avgTps=144187
userID=490000000;time=:56916;tps= 178571;avgTps=144713
userID=500000000;time=:65692;tps= 153846;avgTps=144843
userID=510000000;time=:68287;tps= 147058;avgTps=144886
userID=520000000;time=:62217;tps= 161290;avgTps=145170
userID=530000000;time=:65816;tps= 153846;avgTps=145285
userID=540000000;time=:59998;tps= 169491;avgTps=145631
userID=550000000;time=:60049;tps= 166666;avgTps=145966
userID=560000000;time=:66403;tps= 151515;avgTps=146061
userID=570000000;time=:61183;tps= 163934;avgTps=146303
userID=580000000;time=:62422;tps= 161290;avgTps=146538
userID=590000000;time=:62190;tps= 161290;avgTps=146766
userID=600000000;time=:63360;tps= 158730;avgTps=146914
userID=610000000;time=:64656;tps= 156250;avgTps=147058
userID=620000000;time=:62475;tps= 161290;avgTps=147233
userID=630000000;time=:63454;tps= 158730;avgTps=147402
userID=640000000;time=:65770;tps= 153846;avgTps=147465
userID=650000000;time=:58575;tps= 172413;avgTps=147760
userID=660000000;time=:68807;tps= 147058;avgTps=147750
userID=670000000;time=:59319;tps= 169491;avgTps=148000
userID=680000000;time=:60740;tps= 166666;avgTps=148245
userID=690000000;time=:65467;tps= 153846;avgTps=148291
userID=700000000;time=:58814;tps= 172413;avgTps=148556
userID=710000000;time=:63704;tps= 158730;avgTps=148691
userID=720000000;time=:59497;tps= 169491;avgTps=148914
userID=730000000;time=:60400;tps= 166666;avgTps=149131
userID=740000000;time=:66830;tps= 151515;avgTps=149133
userID=750000000;time=:58881;tps= 172413;avgTps=149372
userID=760000000;time=:65901;tps= 153846;avgTps=149400
userID=770000000;time=:65568;tps= 153846;avgTps=149456
userID=780000000;time=:56845;tps= 178571;avgTps=149740
userID=790000000;time=:65207;tps= 153846;avgTps=149791
userID=800000000;time=:66265;tps= 151515;avgTps=149784
userID=810000000;time=:63740;tps= 158730;avgTps=149888
userID=820000000;time=:67948;tps= 149253;avgTps=149853
userID=830000000;time=:62663;tps= 161290;avgTps=149954
userID=840000000;time=:67192;tps= 149253;avgTps=149946
userID=850000000;time=:62051;tps= 161290;avgTps=150070
userID=860000000;time=:59932;tps= 169491;avgTps=150244
userID=870000000;time=:67689;tps= 149253;avgTps=150207
userID=880000000;time=:60167;tps= 166666;avgTps=150375
userID=890000000;time=:66118;tps= 151515;avgTps=150388
userID=900000000;time=:63524;tps= 158730;avgTps=150451
userID=910000000;time=:58569;tps= 172413;avgTps=150662
userID=920000000;time=:65752;tps= 153846;avgTps=150671
userID=930000000;time=:62739;tps= 161290;avgTps=150753
userID=940000000;time=:61959;tps= 163934;avgTps=150858
userID=950000000;time=:64592;tps= 156250;avgTps=150913
userID=960000000;time=:60939;tps= 166666;avgTps=151038
userID=970000000;time=:61774;tps= 163934;avgTps=151137
userID=980000000;time=:66080;tps= 151515;avgTps=151141
userID=990000000;time=:61680;tps= 163934;avgTps=151237
userID=1000000000;time=:66072;tps= 151515;avgTps=151240
userID=1010000000;time=:60929;tps= 166666;avgTps=151356
userID=1020000000;time=:96619;tps= 104166;avgTps=150686
userID=1030000000;time=:90644;tps= 111111;avgTps=150145
userID=1040000000;time=:74721;tps= 135135;avgTps=149963
userID=1050000000;time=:85647;tps= 117647;avgTps=149572
userID=1060000000;time=:81553;tps= 123456;avgTps=149253
userID=1070000000;time=:75288;tps= 133333;avgTps=149087
userID=1080000000;time=:47995;tps= 212765;avgTps=149480
userID=1090000000;time=:47220;tps= 212765;avgTps=149869
userID=1100000000;time=:46782;tps= 217391;avgTps=150293
userID=1110000000;time=:45632;tps= 222222;avgTps=150712
userID=1120000000;time=:46416;tps= 217391;avgTps=151126
userID=1130000000;time=:49246;tps= 204081;avgTps=151454
userID=1140000000;time=:44562;tps= 227272;avgTps=151898
userID=1150000000;time=:48967;tps= 208333;avgTps=152237
userID=1160000000;time=:46074;tps= 217391;avgTps=152631
userID=1170000000;time=:43816;tps= 232558;avgTps=153061
userID=1180000000;time=:49761;tps= 204081;avgTps=153366
userID=1190000000;time=:47321;tps= 212765;avgTps=153726
userID=1200000000;time=:49231;tps= 204081;avgTps=154043
userID=1210000000;time=:46237;tps= 217391;avgTps=154395
userID=1220000000;time=:46446;tps= 217391;avgTps=154763
userID=1230000000;time=:46889;tps= 217391;avgTps=155107
userID=1240000000;time=:46390;tps= 217391;avgTps=155466
userID=1250000000;time=:46954;tps= 217391;avgTps=155802
userID=1260000000;time=:48455;tps= 208333;avgTps=156095
userID=1270000000;time=:47839;tps= 212765;avgTps=156403
userID=1280000000;time=:48281;tps= 208333;avgTps=156709
userID=1290000000;time=:46850;tps= 217391;avgTps=157029
userID=1300000000;time=:46360;tps= 217391;avgTps=157365
userID=1310000000;time=:49749;tps= 204081;avgTps=157622
userID=1320000000;time=:48540;tps= 208333;avgTps=157913
userID=1330000000;time=:49622;tps= 204081;avgTps=158163
userID=1340000000;time=:45949;tps= 222222;avgTps=158486
userID=1350000000;time=:45550;tps= 222222;avgTps=158823
userID=1360000000;time=:49238;tps= 204081;avgTps=159064
userID=1370000000;time=:45881;tps= 222222;avgTps=159376
userID=1380000000;time=:46448;tps= 217391;avgTps=159685
userID=1390000000;time=:48608;tps= 208333;avgTps=159935
userID=1400000000;time=:48385;tps= 208333;avgTps=160201
userID=1410000000;time=:48939;tps= 208333;avgTps=160446
userID=1420000000;time=:48240;tps= 208333;avgTps=160706
userID=1430000000;time=:47108;tps= 212765;avgTps=160981
userID=1440000000;time=:48828;tps= 208333;avgTps=161218
userID=1450000000;time=:46694;tps= 217391;avgTps=161487
userID=1460000000;time=:47673;tps= 212765;avgTps=161737
userID=1470000000;time=:48077;tps= 208333;avgTps=161983
userID=1480000000;time=:46146;tps= 217391;avgTps=162262
userID=1490000000;time=:51289;tps= 196078;avgTps=162450
userID=1500000000;time=:45875;tps= 222222;avgTps=162725
userID=1510000000;time=:50530;tps= 200000;avgTps=162926
userID=1520000000;time=:48087;tps= 208333;avgTps=163142
userID=1530000000;time=:47103;tps= 212765;avgTps=163391
userID=1540000000;time=:49182;tps= 204081;avgTps=163603
userID=1550000000;time=:47988;tps= 212765;avgTps=163830
userID=1560000000;time=:49023;tps= 204081;avgTps=164037
userID=1570000000;time=:48309;tps= 208333;avgTps=164260
userID=1580000000;time=:46400;tps= 217391;avgTps=164497
userID=1590000000;time=:50926;tps= 200000;avgTps=164681
userID=1600000000;time=:47229;tps= 212765;avgTps=164897
userID=1610000000;time=:47206;tps= 212765;avgTps=165128
userID=1620000000;time=:49072;tps= 204081;avgTps=165322
userID=1630000000;time=:48163;tps= 208333;avgTps=165532
userID=1640000000;time=:46614;tps= 217391;avgTps=165757
userID=1650000000;time=:47589;tps= 212765;avgTps=165979
userID=1660000000;time=:46995;tps= 217391;avgTps=166199
userID=1670000000;time=:48419;tps= 208333;avgTps=166384
userID=1680000000;time=:47747;tps= 212765;avgTps=166600
userID=1690000000;time=:47478;tps= 212765;avgTps=166798
userID=1700000000;time=:49891;tps= 204081;avgTps=166961
userID=1710000000;time=:53144;tps= 188679;avgTps=167073
userID=1720000000;time=:80018;tps= 125000;avgTps=166747
userID=1730000000;time=:91209;tps= 109890;avgTps=166250
userID=1740000000;time=:88856;tps= 113636;avgTps=165793
userID=1750000000;time=:88321;tps= 113636;avgTps=165359
userID=1760000000;time=:80177;tps= 125000;avgTps=165041
userID=1770000000;time=:77772;tps= 129870;avgTps=164789
userID=1780000000;time=:85451;tps= 117647;avgTps=164403
userID=1790000000;time=:65723;tps= 153846;avgTps=164325
userID=1800000000;time=:62868;tps= 161290;avgTps=164308
userID=1810000000;time=:65464;tps= 153846;avgTps=164231
userID=1820000000;time=:65191;tps= 153846;avgTps=164171
userID=1830000000;time=:71279;tps= 140845;avgTps=164022
userID=1840000000;time=:62836;tps= 161290;avgTps=163992
userID=1850000000;time=:64807;tps= 156250;avgTps=163934
userID=1860000000;time=:73882;tps= 136986;avgTps=163746
userID=1870000000;time=:60968;tps= 166666;avgTps=163747
userID=1880000000;time=:63162;tps= 158730;avgTps=163720
userID=1890000000;time=:67081;tps= 149253;avgTps=163636
userID=1900000000;time=:60468;tps= 166666;avgTps=163637
userID=1910000000;time=:66304;tps= 151515;avgTps=163569
userID=1920000000;time=:68114;tps= 147058;avgTps=163473
userID=1930000000;time=:62915;tps= 161290;avgTps=163448
userID=1940000000;time=:69160;tps= 144927;avgTps=163340
userID=1950000000;time=:60833;tps= 166666;avgTps=163343
userID=1960000000;time=:65131;tps= 153846;avgTps=163292
userID=1970000000;time=:60733;tps= 166666;avgTps=163295
userID=1980000000;time=:66712;tps= 151515;avgTps=163231
userID=1990000000;time=:70267;tps= 142857;avgTps=163101
userID=2000000000;time=:60954;tps= 166666;avgTps=163105
userID=2010000000;time=:65660;tps= 153846;avgTps=163056
userID=2020000000;time=:63763;tps= 158730;avgTps=163021
userID=2030000000;time=:63014;tps= 158730;avgTps=162999
userID=2040000000;time=:68170;tps= 147058;avgTps=162913
userID=2050000000;time=:62956;tps= 161290;avgTps=162892
userID=2060000000;time=:63356;tps= 158730;avgTps=162858
userID=2070000000;time=:61775;tps= 163934;avgTps=162863
userID=2080000000;time=:61992;tps= 163934;avgTps=162856
userID=2090000000;time=:66373;tps= 151515;avgTps=162785
userID=2100000000;time=:60183;tps= 166666;avgTps=162803
userID=2110000000;time=:57918;tps= 175438;avgTps=162846
userID=2120000000;time=:65728;tps= 153846;avgTps=162788
userID=2130000000;time=:60991;tps= 166666;avgTps=162794
userID=2140000000;time=:63722;tps= 158730;avgTps=162774
userID=2150000000;time=:62067;tps= 161290;avgTps=162767
userID=2160000000;time=:60358;tps= 166666;avgTps=162773
userID=2170000000;time=:64742;tps= 156250;avgTps=162741
userID=2180000000;time=:58000;tps= 172413;avgTps=162783
userID=2190000000;time=:63283;tps= 158730;avgTps=162752
userID=2200000000;time=:64556;tps= 156250;avgTps=162721
userID=2210000000;time=:62073;tps= 161290;avgTps=162715
userID=2220000000;time=:59495;tps= 169491;avgTps=162732
userID=2230000000;time=:59997;tps= 169491;avgTps=162749
userID=2240000000;time=:59180;tps= 169491;avgTps=162778
userID=2250000000;time=:64365;tps= 156250;avgTps=162748
userID=2260000000;time=:62384;tps= 161290;avgTps=162730
userID=2270000000;time=:61017;tps= 163934;avgTps=162735
userID=2280000000;time=:63871;tps= 158730;avgTps=162706
userID=2290000000;time=:59344;tps= 169491;avgTps=162734
userID=2300000000;time=:66848;tps= 151515;avgTps=162670
userID=2310000000;time=:62712;tps= 161290;avgTps=162653
userID=2320000000;time=:61290;tps= 163934;avgTps=162658
userID=2330000000;time=:66000;tps= 151515;avgTps=162607
userID=2340000000;time=:61870;tps= 163934;avgTps=162601
userID=2350000000;time=:63259;tps= 158730;avgTps=162584
userID=2360000000;time=:63351;tps= 158730;avgTps=162568
userID=2370000000;time=:59789;tps= 169491;avgTps=162584
userID=2380000000;time=:64659;tps= 156250;avgTps=162546
userID=2390000000;time=:60593;tps= 166666;avgTps=162562
userID=2400000000;time=:62228;tps= 161290;avgTps=162546
userID=2410000000;time=:65790;tps= 153846;avgTps=162508
userID=2420000000;time=:61165;tps= 163934;avgTps=162503
userID=2430000000;time=:62465;tps= 161290;avgTps=162498
userID=2440000000;time=:61353;tps= 163934;avgTps=162504
userID=2450000000;time=:59393;tps= 169491;avgTps=162520
userID=2460000000;time=:67994;tps= 149253;avgTps=162451
userID=2470000000;time=:59519;tps= 169491;avgTps=162478
userID=2480000000;time=:63642;tps= 158730;avgTps=162452
userID=2490000000;time=:59481;tps= 169491;avgTps=162479
userID=2500000000;time=:59517;tps= 169491;avgTps=162495
userID=2510000000;time=:65953;tps= 153846;avgTps=162449
userID=2520000000;time=:61973;tps= 163934;avgTps=162444
userID=2530000000;time=:59918;tps= 169491;avgTps=162460
userID=2540000000;time=:63662;tps= 158730;avgTps=162445
userID=2550000000;time=:58652;tps= 172413;avgTps=162472
userID=2560000000;time=:63723;tps= 158730;avgTps=162446
userID=2570000000;time=:63605;tps= 158730;avgTps=162432
userID=2580000000;time=:61465;tps= 163934;avgTps=162427
userID=2590000000;time=:67806;tps= 149253;avgTps=162362
userID=2600000000;time=:58935;tps= 172413;avgTps=162388
userID=2610000000;time=:62103;tps= 161290;avgTps=162384
userID=2620000000;time=:63050;tps= 158730;avgTps=162369
userID=2630000000;time=:60690;tps= 166666;avgTps=162385
userID=2640000000;time=:66642;tps= 151515;avgTps=162331
userID=2650000000;time=:63348;tps= 158730;avgTps=162317
userID=2660000000;time=:62162;tps= 161290;avgTps=162303
userID=2670000000;time=:63710;tps= 158730;avgTps=162290
userID=2680000000;time=:62800;tps= 161290;avgTps=162276
userID=2690000000;time=:65251;tps= 153846;avgTps=162243
userID=2700000000;time=:63406;tps= 158730;avgTps=162220
userID=2710000000;time=:66369;tps= 151515;avgTps=162178
userID=2720000000;time=:66544;tps= 151515;avgTps=162126
userID=2730000000;time=:60563;tps= 166666;avgTps=162142
userID=2740000000;time=:64759;tps= 156250;avgTps=162110
userID=2750000000;time=:61066;tps= 163934;avgTps=162117
userID=2760000000;time=:62029;tps= 161290;avgTps=162114
userID=2770000000;time=:65241;tps= 153846;avgTps=162083
userID=2780000000;time=:62272;tps= 161290;avgTps=162070
userID=2790000000;time=:63068;tps= 158730;avgTps=162058
userID=2800000000;time=:64162;tps= 156250;avgTps=162037
userID=2810000000;time=:59584;tps= 169491;avgTps=162062
userID=2820000000;time=:67009;tps= 149253;avgTps=162013
userID=2830000000;time=:61907;tps= 163934;avgTps=162010
userID=2840000000;time=:61413;tps= 163934;avgTps=162007
userID=2850000000;time=:65537;tps= 153846;avgTps=161977
userID=2860000000;time=:61486;tps= 163934;avgTps=161975
userID=2870000000;time=:66371;tps= 151515;avgTps=161936
userID=2880000000;time=:66189;tps= 151515;avgTps=161897
userID=2890000000;time=:63491;tps= 158730;avgTps=161877
userID=2900000000;time=:66430;tps= 151515;avgTps=161839
userID=2910000000;time=:61008;tps= 163934;avgTps=161846
userID=2920000000;time=:66494;tps= 151515;avgTps=161799
userID=2930000000;time=:67347;tps= 149253;avgTps=161753
userID=2940000000;time=:63190;tps= 158730;avgTps=161742
userID=2950000000;time=:63475;tps= 158730;avgTps=161723
userID=2960000000;time=:61541;tps= 163934;avgTps=161730
userID=2970000000;time=:64066;tps= 156250;avgTps=161711
userID=2980000000;time=:68491;tps= 147058;avgTps=161649
userID=2990000000;time=:64110;tps= 156250;avgTps=161630
userID=3000000000;time=:66894;tps= 151515;avgTps=161585
userID=3010000000;time=:67544;tps= 149253;avgTps=161541
userID=3020000000;time=:61059;tps= 163934;avgTps=161549
userID=3030000000;time=:65536;tps= 153846;avgTps=161513
userID=3040000000;time=:62042;tps= 161290;avgTps=161513
userID=3050000000;time=:62364;tps= 161290;avgTps=161512
userID=3060000000;time=:65038;tps= 153846;avgTps=161486
userID=3070000000;time=:60612;tps= 166666;avgTps=161493
userID=3080000000;time=:67514;tps= 149253;avgTps=161442
userID=3090000000;time=:65353;tps= 153846;avgTps=161416
userID=3100000000;time=:65558;tps= 153846;avgTps=161391
userID=3110000000;time=:66961;tps= 151515;avgTps=161348
userID=3120000000;time=:66323;tps= 151515;avgTps=161307
userID=3130000000;time=:64331;tps= 156250;avgTps=161290
userID=3140000000;time=:66320;tps= 151515;avgTps=161257
userID=3150000000;time=:58722;tps= 172413;avgTps=161282
userID=3160000000;time=:66976;tps= 151515;avgTps=161240
userID=3170000000;time=:59086;tps= 169491;avgTps=161265
userID=3180000000;time=:61851;tps= 163934;avgTps=161265
userID=3190000000;time=:67935;tps= 149253;avgTps=161216
userID=3200000000;time=:62571;tps= 161290;avgTps=161209
userID=3210000000;time=:65738;tps= 153846;avgTps=161185
userID=3220000000;time=:62320;tps= 161290;avgTps=161177
userID=3230000000;time=:59171;tps= 169491;avgTps=161201
userID=3240000000;time=:64021;tps= 156250;avgTps=161186
userID=3250000000;time=:60812;tps= 166666;avgTps=161194
userID=3260000000;time=:59736;tps= 169491;avgTps=161218
userID=3270000000;time=:67095;tps= 149253;avgTps=161179
userID=3280000000;time=:61408;tps= 163934;avgTps=161179
userID=3290000000;time=:66236;tps= 151515;avgTps=161148
userID=3300000000;time=:60601;tps= 166666;avgTps=161156
userID=3310000000;time=:64144;tps= 156250;avgTps=161141
userID=3320000000;time=:64422;tps= 156250;avgTps=161125
userID=3330000000;time=:61731;tps= 163934;avgTps=161126
userID=3340000000;time=:61651;tps= 163934;avgTps=161126
userID=3350000000;time=:66834;tps= 151515;avgTps=161096
userID=3360000000;time=:63101;tps= 158730;avgTps=161081
userID=3370000000;time=:63737;tps= 158730;avgTps=161074
userID=3380000000;time=:60729;tps= 166666;avgTps=161082
userID=3390000000;time=:65565;tps= 153846;avgTps=161052
userID=3400000000;time=:65488;tps= 153846;avgTps=161030
userID=3410000000;time=:59137;tps= 169491;avgTps=161054
userID=3420000000;time=:67818;tps= 149253;avgTps=161009
userID=3430000000;time=:62450;tps= 161290;avgTps=161002
userID=3440000000;time=:65016;tps= 153846;avgTps=160980
userID=3450000000;time=:67392;tps= 149253;avgTps=160944
userID=3460000000;time=:62499;tps= 161290;avgTps=160945
userID=3470000000;time=:71503;tps= 140845;avgTps=160871
userID=3480000000;time=:67959;tps= 149253;avgTps=160828
userID=3490000000;time=:58950;tps= 172413;avgTps=160851
userID=3500000000;time=:69562;tps= 144927;avgTps=160801
userID=3510000000;time=:61594;tps= 163934;avgTps=160802
userID=3520000000;time=:68200;tps= 147058;avgTps=160759
userID=3530000000;time=:65862;tps= 153846;avgTps=160732
userID=3540000000;time=:60062;tps= 166666;avgTps=160748
userID=3550000000;time=:63965;tps= 158730;avgTps=160735
userID=3560000000;time=:60898;tps= 166666;avgTps=160744
userID=3570000000;time=:65949;tps= 153846;avgTps=160716
userID=3580000000;time=:69630;tps= 144927;avgTps=160660
userID=3590000000;time=:59822;tps= 169491;avgTps=160683
userID=3600000000;time=:67933;tps= 149253;avgTps=160642
userID=3610000000;time=:69352;tps= 144927;avgTps=160587
userID=3620000000;time=:59480;tps= 169491;avgTps=160610
userID=3630000000;time=:67725;tps= 149253;avgTps=160569
userID=3640000000;time=:63755;tps= 158730;avgTps=160557
userID=3650000000;time=:67187;tps= 149253;avgTps=160524
userID=3660000000;time=:63243;tps= 158730;avgTps=160519
userID=3670000000;time=:63089;tps= 158730;avgTps=160514
userID=3680000000;time=:68734;tps= 147058;avgTps=160467
userID=3690000000;time=:65750;tps= 153846;avgTps=160441
userID=3700000000;time=:63055;tps= 158730;avgTps=160437
userID=3710000000;time=:70642;tps= 142857;avgTps=160383
userID=3720000000;time=:59737;tps= 169491;avgTps=160400
userID=3730000000;time=:61698;tps= 163934;avgTps=160402
userID=3740000000;time=:62265;tps= 161290;avgTps=160404
userID=3750000000;time=:64576;tps= 156250;avgTps=160386
userID=3760000000;time=:70332;tps= 142857;avgTps=160334
userID=3770000000;time=:61648;tps= 163934;avgTps=160336
userID=3780000000;time=:67159;tps= 149253;avgTps=160305
userID=3790000000;time=:67816;tps= 149253;avgTps=160267
userID=3800000000;time=:64351;tps= 156250;avgTps=160256
userID=3810000000;time=:69760;tps= 144927;avgTps=160205
userID=3820000000;time=:62651;tps= 161290;avgTps=160208
userID=3830000000;time=:61903;tps= 163934;avgTps=160210
userID=3840000000;time=:68091;tps= 147058;avgTps=160173
userID=3850000000;time=:59789;tps= 169491;avgTps=160189
userID=3860000000;time=:70346;tps= 142857;avgTps=160139
userID=3870000000;time=:65808;tps= 153846;avgTps=160115
userID=3880000000;time=:67164;tps= 149253;avgTps=160085
userID=3890000000;time=:75966;tps= 133333;avgTps=159996
userID=3900000000;time=:64210;tps= 156250;avgTps=159980
userID=3910000000;time=:68918;tps= 147058;avgTps=159944
userID=3920000000;time=:70212;tps= 142857;avgTps=159889
userID=3930000000;time=:61918;tps= 163934;avgTps=159892
userID=3940000000;time=:69572;tps= 144927;avgTps=159850
userID=3950000000;time=:65535;tps= 153846;avgTps=159828
userID=3960000000;time=:63641;tps= 158730;avgTps=159825
userID=3970000000;time=:67651;tps= 149253;avgTps=159790
userID=3980000000;time=:63995;tps= 158730;avgTps=159781
userID=3990000000;time=:69025;tps= 144927;avgTps=159740
userID=4000000000;time=:63695;tps= 158730;avgTps=159731
userID=4010000000;time=:65549;tps= 153846;avgTps=159716
userID=4020000000;time=:70621;tps= 142857;avgTps=159663
userID=4030000000;time=:60401;tps= 166666;avgTps=159679
userID=4040000000;time=:63539;tps= 158730;avgTps=159671
userID=4050000000;time=:66037;tps= 151515;avgTps=159649
userID=4060000000;time=:66489;tps= 151515;avgTps=159628
userID=4070000000;time=:70593;tps= 142857;avgTps=159576
userID=4080000000;time=:67623;tps= 149253;avgTps=159543
userID=4090000000;time=:64871;tps= 156250;avgTps=159535
userID=4100000000;time=:74305;tps= 135135;avgTps=159458
userID=4110000000;time=:62967;tps= 161290;avgTps=159456
userID=4120000000;time=:64515;tps= 156250;avgTps=159448
userID=4130000000;time=:67877;tps= 149253;avgTps=159416
userID=4140000000;time=:62749;tps= 161290;avgTps=159414
userID=4150000000;time=:71901;tps= 140845;avgTps=159357
userID=4160000000;time=:64482;tps= 156250;avgTps=159350
userID=4170000000;time=:63236;tps= 158730;avgTps=159348
userID=4180000000;time=:68691;tps= 147058;avgTps=159310
userID=4190000000;time=:60939;tps= 166666;avgTps=159321
userID=4200000000;time=:67566;tps= 149253;avgTps=159290
userID=4210000000;time=:65504;tps= 153846;avgTps=159276
userID=4220000000;time=:68965;tps= 147058;avgTps=159239
userID=4230000000;time=:73385;tps= 136986;avgTps=159172
userID=4240000000;time=:60925;tps= 166666;avgTps=159189
userID=4250000000;time=:62681;tps= 161290;avgTps=159187
userID=4260000000;time=:64043;tps= 156250;avgTps=159180
userID=4270000000;time=:65409;tps= 153846;avgTps=159162
userID=4280000000;time=:74987;tps= 135135;avgTps=159090
userID=4290000000;time=:63671;tps= 158730;avgTps=159089
userID=4300000000;time=:61084;tps= 163934;avgTps=159100
userID=4310000000;time=:67340;tps= 149253;avgTps=159069
userID=4320000000;time=:62504;tps= 161290;avgTps=159075
userID=4330000000;time=:65219;tps= 153846;avgTps=159062
userID=4340000000;time=:64840;tps= 156250;avgTps=159050
userID=4350000000;time=:65498;tps= 153846;avgTps=159031
userID=4360000000;time=:74043;tps= 135135;avgTps=158967
userID=4370000000;time=:62916;tps= 161290;avgTps=158966
userID=4380000000;time=:62675;tps= 161290;avgTps=158972
userID=4390000000;time=:68395;tps= 147058;avgTps=158937
userID=4400000000;time=:64746;tps= 156250;avgTps=158925
userID=4410000000;time=:69469;tps= 144927;avgTps=158890
userID=4420000000;time=:62111;tps= 161290;avgTps=158895
userID=4430000000;time=:69213;tps= 144927;avgTps=158861
userID=4440000000;time=:73218;tps= 136986;avgTps=158798
userID=4450000000;time=:66510;tps= 151515;avgTps=158781
userID=4460000000;time=:70077;tps= 142857;avgTps=158741
userID=4470000000;time=:63751;tps= 158730;avgTps=158735
userID=4480000000;time=:63922;tps= 158730;avgTps=158730
userID=4490000000;time=:73781;tps= 136986;avgTps=158668
userID=4500000000;time=:61820;tps= 163934;avgTps=158679
userID=4510000000;time=:62751;tps= 161290;avgTps=158679
userID=4520000000;time=:66273;tps= 151515;avgTps=158663
userID=4530000000;time=:62885;tps= 161290;avgTps=158663
userID=4540000000;time=:69070;tps= 144927;avgTps=158630
userID=4550000000;time=:65909;tps= 153846;avgTps=158613
userID=4560000000;time=:63146;tps= 158730;avgTps=158614
userID=4570000000;time=:69967;tps= 144927;avgTps=158575
userID=4580000000;time=:61229;tps= 163934;avgTps=158581
userID=4590000000;time=:63066;tps= 158730;avgTps=158582
userID=4600000000;time=:66804;tps= 151515;avgTps=158566
userID=4610000000;time=:61763;tps= 163934;avgTps=158571
userID=4620000000;time=:72190;tps= 138888;avgTps=158523
userID=4630000000;time=:60433;tps= 166666;avgTps=158534
userID=4640000000;time=:65365;tps= 153846;avgTps=158524
userID=4650000000;time=:65619;tps= 153846;avgTps=158508
userID=4660000000;time=:65445;tps= 153846;avgTps=158498
userID=4670000000;time=:64404;tps= 156250;avgTps=158487
userID=4680000000;time=:62416;tps= 161290;avgTps=158493
userID=4690000000;time=:65010;tps= 153846;avgTps=158483
userID=4700000000;time=:69881;tps= 144927;avgTps=158446
userID=4710000000;time=:61004;tps= 163934;avgTps=158457
userID=4720000000;time=:68981;tps= 147058;avgTps=158426
userID=4730000000;time=:63946;tps= 158730;avgTps=158421
userID=4740000000;time=:62081;tps= 161290;avgTps=158427
userID=4750000000;time=:66268;tps= 151515;avgTps=158412
userID=4760000000;time=:57679;tps= 175438;avgTps=158439
userID=4770000000;time=:63884;tps= 158730;avgTps=158434
userID=4780000000;time=:69470;tps= 144927;avgTps=158404
userID=4790000000;time=:61998;tps= 163934;avgTps=158409
userID=4800000000;time=:67009;tps= 149253;avgTps=158389
userID=4810000000;time=:63371;tps= 158730;avgTps=158385
userID=4820000000;time=:65286;tps= 153846;avgTps=158375
userID=4830000000;time=:62930;tps= 161290;avgTps=158376
userID=4840000000;time=:63722;tps= 158730;avgTps=158371
userID=4850000000;time=:67938;tps= 149253;avgTps=158346
userID=4860000000;time=:64155;tps= 156250;avgTps=158342
userID=4870000000;time=:63548;tps= 158730;avgTps=158343
userID=4880000000;time=:70409;tps= 142857;avgTps=158302
userID=4890000000;time=:62488;tps= 161290;avgTps=158308
userID=4900000000;time=:68979;tps= 147058;avgTps=158278
userID=4910000000;time=:62845;tps= 161290;avgTps=158279
userID=4920000000;time=:61607;tps= 163934;avgTps=158285
userID=4930000000;time=:67227;tps= 149253;avgTps=158266
userID=4940000000;time=:62176;tps= 161290;avgTps=158272
userID=4950000000;time=:63264;tps= 158730;avgTps=158273
userID=4960000000;time=:68029;tps= 147058;avgTps=158249
userID=4970000000;time=:61289;tps= 163934;avgTps=158255
userID=4980000000;time=:64453;tps= 156250;avgTps=158250

userID=4990000000;time=:60806;tps= 166666;avgTps=158261

userID=5000000000;time=:60980;tps= 166666;avgTps=158272


附注(3) :以下为从50亿条记录中以单线程随机读1000W条数据,以每读取5W记录为周期的阶段性使用时长

time=1350745562032;threadcount=1;bufferSize=1073741824

userID=50000;440722
userID=100000;296943
userID=150000;260771
userID=200000;240832
userID=250000;224553
userID=300000;204812
userID=350000;198579
userID=400000;198718
userID=450000;201308
userID=500000;207610
userID=550000;213382
userID=600000;210778
userID=650000;213960
userID=700000;215290
userID=750000;211777
userID=800000;213954
userID=850000;215475
userID=900000;212187
userID=950000;215517
userID=1000000;211976
MaxUserId=1000001:4609869

       


把leveldb嵌入到redis.实现真正的数据持久存储

目前最新版RedisStorage 是基于 redis 2.6.2基础上,加上 leveldb存储引擎。 这个项目是源于 公司项目的passport 用户认证改造。公司一个项目运行了N年。积累了几千万...
  • kaosini
  • kaosini
  • 2013年05月31日 17:00
  • 2392

leveldb原理和使用

LevelDB是一个基于本地文件的存储引擎,非分布式存储引擎,原理基于BigTable(LSM文件树),无索引机制,存储条目为Key-value。适用于保存数据缓存、日志存储、高速缓存等应用,主要是避...
  • chary8088
  • chary8088
  • 2017年02月09日 11:24
  • 2062

SSDB与Redis的区别

SSDB 是一个 C++ 开发的 NoSQL 数据库, 使用 Google 公司开源的 LevelDB 引擎作为底层的存储引擎. Redis 是一个 C 语言开发的内存 NoSQL 数据库。SSD...
  • wwd0501
  • wwd0501
  • 2014年12月11日 11:23
  • 2330

【神经网络与深度学习】leveldb的实现原理

郑重声明:本篇博客是自己学习 Leveldb 实现原理时参考了郎格科技系列博客整理的,原文地址:http://www.samecity.com/blog/Index.asp?SortID=12,只是为...
  • LG1259156776
  • LG1259156776
  • 2016年09月18日 21:09
  • 581

LevelDB设计与实现

转载自http://www.cnblogs.com/haippy/archive/2011/12/04/2276064.html PS: Google BigTable的设计已总所周知,但许多细节...
  • AndersCloud
  • AndersCloud
  • 2012年01月06日 18:19
  • 11386

Redis、SSDB、Memcache和MongoDB的区别

Redis、Memcache和MongoDB的区别 摘要: Memcached可以利用多核优势,单实例吞吐量极高,可以达到几十万QPS(取决于key、value的字节大小以及服务器硬件性能,日常环...
  • apple9005
  • apple9005
  • 2017年02月23日 17:55
  • 2209

leveldb 性能、使用场景评估

http://www.cnblogs.com/lulu/p/4231810.html leveldb 性能、使用场景评估   最近有个业务写远远大于读,读也集中在最近写入,这不...
  • onlyForCloud
  • onlyForCloud
  • 2015年07月29日 14:51
  • 1238

LevelDB详解

LevelDB   一、LevelDB入门 LevelDB是Google开源的持久化KV单机数据库,具有很高的随机写,顺序读/写性能,但是随机读的性能很一般,也就是说,Level...
  • linuxheik
  • linuxheik
  • 2016年10月09日 16:42
  • 18262

LevelDB原理探究与代码分析

1. 概述 Level DB(http://code.google.com/p/leveldb/)是google开源的Key/Value存储系统,它的committer阵容相当强大,基本上是bigt...
  • icefireelf
  • icefireelf
  • 2012年05月03日 23:40
  • 18155

level db实现解析

  • 2012年03月29日 12:08
  • 664KB
  • 下载
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:LevelDB初体验
举报原因:
原因补充:

(最多只允许输入30个字)