观看《中国数据库前世今生》，体验腾讯数据库技术的崛起，

馃憠鐩綍TencentDB for MySQLTencentDB鏋舵瀯TencentDB浣撻獙鍘嬫祴鍑嗗TencentDB sysbench涓嬭浇sysbench瀹夎sysbench鐗堟湰sysbench鏋勫缓鏁版嵁鐩戞帶鏁版嵁sysbench鍘嬫祴瑙ｈ鎶ュ憡姹囨?诲垎鏋愯皥璋堜綘鐨勬劅鍙桰DC鍙戝竷鎶ュ憡銆婁腑鍥介噾铻嶈涓氬垎甯冨紡浜嬪姟鍨嬫暟鎹簱甯傚満浠介锛岋細鎶?鏈獙璇佺粨鏉燂紝杩庢帴楂橀?熷闀裤?嬶細鍦ㄦ暣浣撻噾铻嶅競鍦轰笌閾惰缁嗗垎甯傚満涓紝鑵捐浜戞暟鎹簱TDSQL鑽ｈ幏鈥滃弻鏁版嵁鈥濈涓?鍚嶏紒鍥剧墖绠?浠?鍦ㄦ暟瀛楀寲娴疆甯嵎鍏ㄧ悆鐨勪粖澶╋紝鏁版嵁搴撴妧鏈綔涓鸿绠楁満绉戝鐨勯噸瑕佹敮鏌憋紝鎵胯浇鐫?鏁版嵁瀛樺偍銆佹绱€?佸垎鏋愮瓑鏍稿績浠诲姟銆傚叾閲嶈鎬т笉瑷?鑰屽柣銆傚湪浼楀鏁版嵁搴撴妧鏈腑锛孧ySQL鍥犲叾寮?婧愩?佺ǔ瀹氥?侀珮鏁堢殑鐗圭偣鍦ㄥ叏鐞冨崰鎹潃涓捐冻杞婚噸鐨勫湴浣嶃?傝鍒颁腑鍥芥暟鎹簱鎶?鏈殑鍙戝睍锛屽氨涓嶅緱涓嶆彁鍒拌吘璁簯鏃椾笅鐨凾encentDB for MySQL鈥斺?斾竴鏀湪鏈湡甯傚満宕涜捣鐨勬妧鏈姏閲忋??銆婁腑鍥芥暟鎹簱鍓嶄笘浠婄敓銆嬭繖閮ㄧ邯褰曠墖鍚戞垜浠睍绀轰簡涓浗鏁版嵁搴撴妧鏈粠鏃犲埌鏈夈?佷粠灏忓埌澶х殑鍙戝睍鍘嗙▼銆傚叾涓紝TencentDB for MySQL鎶?鏈殑宕涜捣鏃犵枒鏄腑鍥芥暟鎹簱鎶?鏈彂灞曞彶涓婄殑涓?澶т寒鐐广?傚畠涓嶄粎鏄吘璁簯鍦ㄦ暟鎹簱棰嗗煙澶氬勾鎶?鏈Н绱拰鍒涙柊鎴愭灉鐨勯泦涓睍绀猴紝涔熸槸鎴戝浗鏁版嵁搴撴妧鏈疄鍔涙彁鍗囩殑閲嶈鏍囧織銆傝鐪嬭繖閮ㄧ邯褰曠墖璁╂垜鏈夋満浼氭繁鍏ヤ簡瑙ｈ吘璁暟鎹簱MySQL鎶?鏈殑鐮斿彂鑳屾櫙銆佹妧鏈壒鐐广?佸簲鐢ㄥ満鏅拰甯傚満琛ㄧ幇銆傛垜浠皢鐪嬪埌锛屽湪鑵捐浜戝己澶х殑鎶?鏈敮鎸佷笅锛孴encentDB for MySQL濡備綍涓嶆柇绐佺牬鑷垜銆佹彁鍗囨?ц兘銆佷紭鍖栨湇鍔★紝浠ユ弧瓒虫棩鐩婂闀跨殑鏁板瓧鍖栭渶姹傘?傚悓鏃讹紝鎴戜滑涔熷皢鎰熷彈鍒颁腑鍥芥暟鎹簱鎶?鏈湪鍥介檯绔炰簤涓殑鐙壒榄呭姏鍜屾棤闄愭綔鍔涖?傝鎴戜滑涓?璧疯繘鍏ャ?婁腑鍥芥暟鎹簱鍓嶄笘浠婄敓銆嬬殑涓栫晫锛屼綋楠岃吘璁暟鎹簱MySQL鎶?鏈殑宕涜捣锛岃璇佷腑鍥芥暟鎹簱鎶?鏈殑杈夌厡鍘嗗彶銆?TangentDB for MySQL浜戞暟鎹簱MySQL锛圱encentDB for MySQL锛夋槸鑵捐浜戝熀浜庡紑婧愭暟鎹簱MySQL鎺ㄥ嚭鐨勪紒涓氱骇鏁版嵁搴撴湇鍔°?傛柟渚跨敤鎴峰湪浜戠杞绘澗璁剧疆銆佹搷浣滃拰鎵╁睍鍏崇郴鏁版嵁搴撱?備簯鏁版嵁搴揗ySQL鐨勪富瑕佺壒鎬у寘鎷細 浜戝瓨鍌ㄦ湇鍔★細杩欐槸鑵捐浜戝钩鍙颁负浜掕仈缃戝簲鐢ㄦ彁渚涚殑鏁版嵁瀛樺偍鏈嶅姟锛屼繚璇佺敤鎴锋暟鎹殑瀹夊叏绋冲畾銆傚叏闈㈠吋瀹筂ySQL鍗忚锛氫簯鏁版嵁搴揗ySQL鏀寔鏍囧噯MySQL鍗忚锛岃繖鎰忓懗鐫?浠讳綍閫傚悎MySQL鐨勫簲鐢ㄥ満鏅兘鍙互鏃犵紳杩佺Щ鍒拌吘璁簯鏁版嵁搴撱?傞珮鎬ц兘銆侀珮鍙潬銆佺畝鍗曟槗鐢ㄣ?佷究鎹风殑MySQL闆嗙兢鏈嶅姟锛氳吘璁簯鏁版嵁搴揗ySQL鎻愪緵鍗撹秺鐨勬?ц兘鍜屽彲闈犳?э紝鏁版嵁鍙潬鎬ч珮杈?9.%銆傚悓鏃讹紝瀹冭繕鍏锋湁鏄撶敤鎬у拰鏂逛究鎬э紝璁╃敤鎴峰彲浠ヨ交鏉惧湴绠＄悊鍜岀淮鎶ゆ暟鎹簱銆備赴瀵岀殑鍔熻兘闆嗘垚锛氫簯鏁版嵁搴揗ySQL闆嗘垚浜嗗浠姐?佹墿瀹广?佽縼绉荤瓑瀹炵敤鍔熻兘锛屽府鍔╃敤鎴疯交鏉惧簲瀵瑰悇绉嶆暟鎹簱绠＄悊闇?姹傘?傛柊涓?浠ｆ暟鎹簱宸ュ叿DMC锛氳吘璁簯杩樻彁渚涗簡鍏堣繘鐨勬暟鎹簱绠＄悊宸ュ叿DMC锛岃鐢ㄦ埛鍙互鏇存柟渚垮湴绠＄悊銆佺洃鎺у拰浼樺寲鏁版嵁搴撱?傝吘璁暟鎹簱鏋舵瀯浜戞暟鎹簱MySQL鏀寔鍥涚瀹炰緥鏋舵瀯锛氬崟鑺傜偣銆佸弻鑺傜偣銆佷笁鑺傜偣鍜岄泦缇ょ増鏈?傛灦鏋勮鏄?閫傜敤鍦烘櫙 鍗曡妭鐐规敮鎸佺増鏈細MySQL 5.7銆?.0銆傝妭鐐癸細鍗曚釜鑺傜偣銆備釜浜哄涔犮?佸井鍨嬬綉绔欍?佷紒涓氶潪鏍稿績灏忓瀷绯荤粺銆佸ぇ涓瀷浼佷笟寮?鍙戞祴璇曠幆澧冦?傚弻鑺傜偣鏀寔鐗堟湰锛歁ySQL 5.6銆?.7銆?.0銆傝妭鐐癸細涓?涓讳竴澶囥?備富浠庡鍒舵ā寮忥細寮傛锛堥粯璁わ級銆佸崐鍚屾銆傚簲鐢ㄥ湪娓告垙銆佷簰鑱旂綉銆佺墿鑱旂綉銆侀浂鍞數鍟嗐?佺墿娴併?佷繚闄┿?佽瘉鍒哥瓑琛屼笟銆備笁鑺傜偣鏀寔鐗堟湰锛歁ySQL 5.6銆?.7銆?.0銆傝妭鐐癸細1涓富鑺傜偣锛?涓浠借妭鐐广?備富浠庡鍒舵ā寮忥細寮傛锛堥粯璁わ級銆佸己鍚屾銆佸崐鍚屾銆傚簲鐢ㄥ湪娓告垙銆佷簰鑱旂綉銆佺墿鑱旂綉銆侀浂鍞數鍟嗐?佺墿娴併?佷繚闄┿?佽瘉鍒哥瓑琛屼笟銆傞泦缇ょ増鏈敮鎸佺増鏈細MySQL 5.7銆?.0銆傝妭鐐癸細1涓鍐欒妭鐐癸紝鏈?澶?涓彧璇昏妭鐐广?備富浠庡鍒舵ā寮忥細寮傛銆佸崐鍚屾锛堥粯璁わ級銆傚簲鐢ㄥ湪娓告垙銆佷簰鑱旂綉銆佺墿鑱旂綉銆侀浂鍞數鍟嗐?佺墿娴併?佷繚闄┿?佽瘉鍒哥瓑琛屼笟銆備骇鍝佹灦鏋凾encentDB浣撻獙浠婂ぉ锛屾垜浠氨鏉ヤ綋楠屼竴涓嬪浗鍐呮暟鎹彂灞曡嚦浠婄殑鍔涢噺銆傞鍏堬紝璐拱鎴栦綋楠孴encentDB瀹炰緥銆傚帇鍔涙祴璇曞噯澶囬厤缃弬鏁?CPU1鏍稿績鍐呭瓨1GMySQL5.8鑵捐浜戣交閲忕骇鏈嶅姟鍣–entOS7.5TencentDB浜嗚В鍘嬪姏娴嬭瘯姒傚康鍦ㄥ紑濮嬪帇鍔涙祴璇曚箣鍓嶏紝鎴戜滑鍏堜簡瑙ｅ嚑涓笌鍘嬪姏娴嬭瘯鐩稿叧鐨勫叧閿瘝銆傞?氳繃鐞嗚В瀹氫箟鍜岃绠楁柟娉曞彲浠ユ洿濂藉湴璇勪及鍜屼紭鍖栫郴缁熸?ц兘锛歈PS锛圦ueries Per Second锛夋槸鎸囨瘡绉掔殑鏌ヨ閫熺巼锛屽畠鏄郴缁熷鐞嗘煡璇㈣姹傝兘鍔涚殑閲嶈鎸囨爣銆傚畠閫氬父鐢ㄤ簬璇勪及鎼滅储寮曟搸銆佹暟鎹簱銆丄PI 鍜屽叾浠栫郴缁熺殑鎬ц兘銆俆PS锛圱ransactions Per Second锛夋槸姣忕鐨勪簨鍔″鐞嗛?熺巼锛屾槸琛￠噺绯荤粺鍗曚綅鏃堕棿鍐呭鐞嗕簨鍔℃暟閲忕殑閲嶈鎸囨爣銆傞?氬父鐢ㄤ簬璇勪及鏁版嵁搴撶郴缁熴?佷氦鏄撶郴缁熶互鍙婂叾浠栭渶瑕佸鐞嗗鏉備氦鏄撶殑绯荤粺鐨勬?ц兘銆?RT锛?5%锛夐?氬父鏄寚95%鐨勮姹傜殑寤惰繜鏃堕棿锛屽崟浣嶆槸姣锛屽弽鏄犱簡绯荤粺鍦ㄥ鐞嗚姹傛椂鐨勫搷搴旈?熷害銆備笅闈㈡槸璇︾粏浠嬬粛锛?QPS锛堟瘡绉掓煡璇㈢巼锛夊畾涔夛細绯荤粺姣忕鍙互澶勭悊鐨勬煡璇㈣姹傛暟銆傚簲鐢ㄥ満鏅細鎼滅储寮曟搸銆佹暟鎹簱鏌ヨ銆乄eb鏈嶅姟鍣ㄧ瓑銆傝绠楀叕寮忎负锛氭煡璇㈡?绘暟闄や互鎬绘椂闂达紙浠ョ涓哄崟浣嶏級銆傞噸瑕佹?э細鍙嶆槧绯荤粺鐨勬煡璇㈠鐞嗚兘鍔涘拰鍝嶅簲閫熷害銆?TPS锛堟瘡绉掍氦鏄撳鐞嗙巼锛夊畾涔夛細绯荤粺姣忕鍙互澶勭悊鐨勪氦鏄撴暟閲忋?傚簲鐢ㄥ満鏅細鏁版嵁搴撶郴缁熴?侀噾铻嶄氦鏄撶郴缁熴?佺數鍟嗗钩鍙扮瓑銆傝绠楀叕寮忎负锛氫氦鏄撴?绘暟闄や互鎬绘椂闂达紙绉掞級銆傞噸瑕佹?э細鍙嶆槧绯荤粺鐨勫鐞嗚兘鍔涘拰鏁堢巼銆?RT(95%)锛?5%璇锋眰寤惰繜锛夊畾涔夛細95%璇锋眰鐨勫欢杩熸椂闂达紝鍗曚綅姣銆傚簲鐢ㄥ満鏅細鐢ㄤ簬璇勪及绯荤粺鐨勫搷搴旈?熷害銆傝绠楁柟娉曪細閫氬父閫氳繃鐩戞祴宸ュ叿鏀堕泦鏁版嵁鍚庤绠椼?傞噸瑕佹?э細鍙嶆槧绯荤粺澶勭悊璇锋眰鐨勫疄鏃舵?с?傝緝浣庣殑 RT (95%) 鎰忓懗鐫?鏇村ソ鐨勭敤鎴蜂綋楠屻?傝涓嬭浇sysbench锛屾垜浠娇鐢ㄤ互涓嬪懡浠よ幏鍙栧苟鎵цscript.rpm.sh骞舵墽琛岃鑴氭湰銆備唬鐮佽瑷?锛歫avascript sudo bashsysbench 瀹夎浠ｇ爜璇█锛歫avascript copy sudo yum -y install sysbenchsysbench 鐗堟湰浠ｇ爜璇█锛歫avascript copy sysbench --versionsysbench 鏋勫缓鏁版嵁浠ｇ爜璇█锛歫avascript copy sysbench --db-driver=mysql -- time=--threads=10 --鎶ュ憡闂撮殧=1 --mysql-host=.0.0.1 --mysql-port=--mysql-user=root --mysql-password=56 --mysql-db= test_db --tables=20 --table_size =00 oltp_read_write --db-ps-mode=disable 鎴愬姛鎵цprepare鍚庯紝鏌ョ湅鎴戜滑鐨凞MS鏁版嵁绠＄悊宸ュ叿锛堥?氳繃鑵捐浜戣繘琛屾暟鎹簱绠＄悊锛圖MC锛夛級锛岃繖鏄竴涓珮鏁堝彲闈犵殑鏁版嵁搴撶鐞嗗钩鍙帮紝甯姪鎮ㄧ鐞嗘洿鏂逛究銆佹洿瑙勮寖鍦版煡鐪嬪涓暟鎹簱瀹炰緥锛夊苟鏌ョ湅鑵捐鏁版嵁搴撴湇鍔″櫒鏁版嵁銆備笂杩板懡浠ょ敤浜庤繍琛宻ysbench鐨刼ltp_read_write娴嬭瘯銆備笅闈㈡槸璇ュ懡浠ょ殑瑙ｉ噴锛?鍙傛暟瑙ｉ噴 --db-driver=mysql 鎸囧畾鏁版嵁搴撻┍鍔ㄤ负 MySQL --time=娴嬭瘯鎸佺画鏃堕棿锛堢锛?--threads=10 骞跺彂绾跨▼鏁?--report-interval=1 鎶ュ憡闂撮殧鏃堕棿浠ョ涓哄崟浣?--mysql-host=.0.0.1 MySQL鏈嶅姟鍣ㄥ湴鍧? --mysql-port=MySQL鏈嶅姟鍣ㄧ鍙?--mysql-user=rootMySQL鐢ㄦ埛鍚?--mysql-password=56 MySQL瀵嗙爜 --mysql-db=test_db瑕佹祴璇曠殑鏁版嵁搴撳悕绉?--tables=20 鐢熸垚鐨勮〃鏁伴噺 --table_size=姣忎釜琛ㄧ殑璁板綍鏁?oltp_read_write 杩愯 oltp_read_write 娴嬭瘯 --db-ps-mode=disable 鍦ㄥ噯澶囪鍙ョ殑鍑嗗闃舵锛屽垱寤鸿〃鍜岀储寮曟潵鐩戞帶鏁版嵁銆傚湪鍘嬫祴鎵ц杩囩▼涓紝鑵捐鏁版嵁搴撴彁渚涗簡涓撲笟鐨勫彲瑙嗗寲宸ュ叿鏉ョ洃鎺у疄渚嬨?備簯鏁版嵁搴揗ySQL鏀寔涓诲疄渚嬶紙鍚鍐欒妭鐐癸級銆佸彧璇诲疄渚嬶紙鍚彧璇昏妭鐐癸級銆佸鐏惧疄渚嬨?佹暟鎹簱浠ｇ悊鑺傜偣鐨勭洃鎺э紝骞朵负姣忎釜瀹炰緥鎻愪緵鐙珛鐨勭洃鎺ц鍥句緵鏌ヨ銆傜洃鎺у垎绫讳簯鏁版嵁搴揗ySQL鍖呮嫭鍥涚鐩戞帶绫诲瀷锛氳祫婧愮洃鎺с?佸紩鎿庣洃鎺э紙鏅?氾級銆佸紩鎿庣洃鎺э紙鎵╁睍锛夈?侀儴缃茬洃鎺с?傞?氳繃鏌ョ湅涓嶅悓鐩戞帶绫诲瀷鐨勬寚鏍囷紝鎮ㄥ彲浠ュ揩閫熴?佸噯纭湴浜嗚В瀹炰緥鎬ц兘鍜岃繍琛岀姸鎬併?傝祫婧愮洃鎺э細鎻愪緵CPU銆佸唴瀛樸?佺鐩樸?佺綉缁滅浉鍏崇殑鐩戞帶鏁版嵁銆傚紩鎿庣洃鎺э紙姝ｅ父锛夛細鎻愪緵杩炴帴鏁般?侀攣淇℃伅銆佺儹鐐硅〃銆佹參鏌ヨ绛夌浉鍏崇洃鎺ф暟鎹紝鏂逛究鎮ㄨ瘖鏂晠闅溿?佷紭鍖栨?ц兘銆傚紩鎿庣洃鎺э紙鎵╁睍锛夛細鎻愪緵鏇翠赴瀵岀殑寮曟搸鐩稿叧鐩戞帶鎸囨爣锛屽府鍔╂偍鏈?澶х▼搴﹀湴鍙戠幇鏁版嵁搴撶幇鏈夋垨娼滃湪鐨勫仴搴烽棶棰樸?傞儴缃茬洃鎺э細鎻愪緵涓讳粠寤惰繜鐩稿叧鐨勭洃鎺ф寚鏍囥?傞儴缃茬洃鎺у垎涓轰富鏈哄拰澶囨満锛氬鏋滃疄渚嬫槸涓诲疄渚嬶紝鍒欏疄渚嬮儴缃茬洃鎺х殑瀵硅薄鏄富瀹炰緥涓庡叾闅愯棌澶囨満涔嬮棿鐨勯摼璺?傞儴缃茬洃鎺ф樉绀洪殣钘忓鏈恒?佷富浠庣殑IO鍜孲QL绾跨▼鐘舵?併?傚欢杩熻窛绂诲拰涓讳粠寤惰繜鏃堕棿鏄寚涓诲疄渚嬩笌鍏堕殣钘忓鏈轰箣闂寸殑璺濈銆傝祫婧愮洃鎺у紩鎿庣洃鎺?鐩戞帶鎸囨爣 鑵捐浜戝彲瑙傚療骞冲彴浠庡疄渚嬬淮搴︿负浜戞暟鎹簱MySQL瀹炰緥鎻愪緵浜嗕赴瀵岀殑鐩戞帶鎸囨爣銆傝鎯呰鍙傝涓嬭〃銆備簯鏁版嵁搴揗ySQL闄や簡閫氳繃鐩戞帶鎸囨爣鐩戞帶瀹炰緥鐨勮繍琛岀姸鎬佸锛岃繕鏀寔鐩戞帶浜嬩欢鍜屼簨浠舵姤璀︺?傞?氳繃璁剧疆浜嬩欢瑙勫垯銆佷簨浠剁洰鏍囧拰鎺ㄩ?佺敤鎴凤紝褰撴娴嬪埌寮傚父浜嬩欢鏃讹紝灏嗕互澶氱鍙?夋柟寮忓悜鎮ㄥ彂閫佷簨浠惰鎶ャ?傜敤鎴峰彂閫佹姤璀﹂?氱煡锛屽府鍔╃敤鎴锋洿鍏ㄩ潰鍦版帉鎺у疄渚嬬殑杩愯淇℃伅銆備簨浠舵姤璀︾殑璇︾粏浠嬬粛璇峰弬瑙佷簨浠舵?荤嚎銆傛敮鎸佺殑鐩戞帶浜嬩欢璇︽儏璇峰弬瑙佷簯鏁版嵁搴揗ySQL浜嬩欢鍒楄〃銆?Sysbench鍘嬪姏娴嬭瘯涓庤В璇?鎴戜滑浠?0涓嚎绋嬪紑濮嬶紝鍘嬪姏10绉掞紝鍚屾椂杩涜璇诲啓鎿嶄綔銆備唬鐮佽瑷?锛歫avascript澶嶅埗sysbench --db-driver=mysql --time=10 --threads=10 --report-interval=1 --mysql-host=.0.0.1 --mysql-port=--mysql- user=root --mysql-password=56 --mysql-db=test_db --tables=20 --table_size=oltp_read_write --db-ps-mode=disable run 鎵ц缁撴灉浠ｇ爜璇█锛歴hell 澶嶅埗sysbench 1.0.20 (using鎹嗙粦 LuaJIT 2.1.0-beta2锛変娇鐢ㄤ互涓嬮?夐」杩愯娴嬭瘯锛氱嚎绋嬫暟锛?0 姣?1 绉掓姤鍛婁腑闂寸粨鏋滀粠褰撳墠鏃堕棿鍒濆鍖栭殢鏈烘暟鐢熸垚鍣ㄦ鍦ㄥ垵濮嬪寲宸ヤ綔绾跨▼...绾跨▼宸插惎鍔紒[ 1s ] thds锛?0 tps : 79.84 qps: .77 (r/w/o: .73/.37/.67) lat (ms,95%): .51 err/s: 0.00 reconn/s: 0.00[ 2s ] thds: 10 tps: 56.02 qps: .50 (r/w/o: .35/.09/.05) lat (ms,95%): .49 err/s: 0.00 reconn/s: 0.00[ 3s ] thds: 10 tps: 49.00 qps: .99 (r/w/o: .99/.00/97.00) lat (ms,95%): .66 err/s: 0.00 reconn/s: 0.00[ 4s ] thds: 10 tps: 49.99 qps: .88锛堣鍐欙細.92/.98/99.99锛夌含搴︼紙姣锛?5%锛夛細.67 閿欒/绉掞細0.00 渚﹀療/绉掞細0.00[ 5s ] thds锛?0 tps锛?7.00 qps锛?.95 (r/w/o: .96/.99/95.00) lat (ms,95%): .75 err/s: 0.00 reconn/s: 0.00[ 6s ] thds: 10 tps: 57.01 qps: .21 (r/w /o: .14/.04/.02) lat (ms,95%): .80 err/s: 0.00 reconn/s: 0.00[ 7s ] thds: 10 tps: 66.00 qps: .97 (r/w/ o: .98/.99/.00) lat (ms,95%): .68 err/s: 0.00 reconn/s: 0.00[ 8s ] thds: 10 tps: 68.00 qps: .07 (r/w/o : .05/.01/.01) lat (ms,95%): .68 err/s: 0.00 reconn/s: 0.00[ 9s ] thds: 10 tps: 65.99 qps: .78 (r/w/o: .85/.96/.98) lat (ms,95%): .08 err/s: 0.00 reconn/s: 0.00[ 10s ] thds: 10 tps: 66.00 qps: .02 (r/w/o: . 01/.00/.00) lat (ms,95%): .90 err/s: 0.00 reconn/s: 0.00[ 11s ] thds: 8 tps: 7.00 qps: 84.01 (r/w/o: 49.01/27.00 /8.00) lat (ms,95%): .84 err/s: 0.00 reconn/s: 0.00[ 12s ] thds: 8 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat ( ms,95%): 0.00 err/s: 0.00 reconn/s: 0.00[ 13s ] thds: 8 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,95%): 0.00 err/s: 0.00 reconn/s: 0.00[ 14s ] thds: 8 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,95%)锛?0.00 閿欒/绉掞細 0.00 渚﹀療/绉掞細 0.00[ 15s ] thds锛?6 tps锛?2.00 qps锛?12.00锛堣/鍐?杈撳嚭锛?2.00/8.00/2.00锛?绾害锛堟绉掞紝95锛咃級锛?0.80 閿欒/绉掞細 0.00 渚﹀療/绉? 0.00[ 16s ] thds: 6 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) 绾害 (ms,95%): 0.00 閿欒/绉? 0.00 渚﹀療/绉? 0.00 SQL 缁熻淇℃伅锛氭墽琛岀殑鏌ヨ锛氳鍙栵細鍐欏叆锛氬叾浠栵細鎬昏锛? 浜嬪姟锛氾紙姣忕 36.98 涓級鏌ヨ锛?锛堟瘡绉?0.56 涓級蹇界暐閿欒锛?锛堟瘡绉?0.00 涓級閲嶆柊杩炴帴锛?锛堟瘡绉?0.00 涓級 .)涓?鑸粺璁★細鎬绘椂闂达細16.s 浜嬩欢鎬绘暟锛氬欢杩燂紙ms锛夛細鏈?灏忓?硷細98.59 骞冲潎鍊硷細0.90 鏈?澶у?硷細4.1295% 鎬诲拰锛?2.86 绾跨▼鍏钩鎬э細浜嬩欢锛坅vg/stddev锛夛細61./37.36 鎵ц鏃堕棿锛坅vg/stddev锛夛細11./2.44 鍙傛暟瑙ｉ噴 1s thds锛?0 tps锛?9.84 qps锛?77锛坮/ w/o: .73/.37/.67) lat (ms,95%): .51 err/s: 0.00 reconn/s: 0.00 姝ゆ姤鍛婃彁渚?10 涓嚎绋嬪湪 1 绉掑唴瀵规暟鎹簱鏂藉姞鍘嬪姏 娴嬭瘯缁撴灉鍖呮嫭浜嬪姟澶勭悊鍔熻兘銆佹煡璇㈡墽琛岄?熷害銆佸欢杩熴?侀敊璇拰閲嶆柊杩炴帴銆傞檮鍙傛暟鍙婂惈涔夎鏄庯細 鍙傛暟鍊?鍚箟 瑙ｉ噴 鏃堕棿 1s 娴嬭瘯杩涜浜?1 绉?绾跨▼鏁帮紙thds锛?10 娴嬭瘯浣跨敤 10 涓嚎绋?姣忕浜嬪姟鏁帮紙tps锛?79.84 ?瘡绉掑畬鎴愪簨鍔℃??姣忕鏌ヨ鏁帮紙qps锛?.77 姣忕鎵ц鐨勬煡璇?璇?鍐?鍏朵粬 (r/w/o) .73/.37 /.67 姣忕璇诲彇銆佸啓鍏ュ拰鍏朵粬鎿嶄綔鐨勬暟閲?95% 寤惰繜锛堢含搴︺?佹绉掞級銆?Latency for % of requests in milliseconds 姣忕閿欒鏁?(err/s) 0.00 姣忕鍙戠敓鐨勯敊璇暟 姣忕閲嶆柊杩炴帴鏁?(reconn/s) 0.00 姣忕鍙戠敓鐨勯噸鏂拌繛鎺ユ暟璇︾粏璇存槑 涓嬮潰鏄缁嗚鏄巗ysbench 宸ュ叿鎬ц兘娴嬭瘯鎶ュ憡璇存槑锛?鍒濆鍖栬缃?Sysbench 鐗堟湰锛?.0.20LuaJIT 鐗堟湰锛?.1.0-beta2 绾跨▼鏁帮細10 鎶ュ憡闂撮殧锛氭瘡绉掍竴娆?闅忔満鏁扮敓鎴愬櫒锛氫粠褰撳墠鏃堕棿寮?濮嬫瘡绉掑垵濮嬪寲缁撴灉 绾跨▼鍚姩锛?10 涓姤鍛婃彁渚涙瘡绉掔粺璁℃暟鎹細 绗竴绉掞細姣忕浜嬪姟鏁?(TPS)锛?9.84 姣忕鏌ヨ鏁?(QPS)锛?77锛堣鍙栵細.73锛屽啓鍏ワ細.37锛屽叾浠栨搷浣滐細.67锛?95% 寤惰繜锛? 51 姣绗?2 绉掞細TPS锛?6.02QPS锛?.50锛堣鍙栵細0.35锛屽啓鍏ワ細0.09锛屽叾浠栨搷浣滐細0.05锛?5% 寤惰繜锛?.49 姣姝ゆā寮忔寔缁埌绗?11 绉掞紝鎶ュ憡涓嶅悓鐨?TPS銆丵PS銆佸拰姣忕鐨勫欢杩熴?傜浜屼釜 11锛氱嚎绋嬭鏁帮細8锛堜粠 10 鍑忓皯锛塗PS锛?.00 QPS锛?4.01锛堣鍙栵細49.01锛屽啓鍏ワ細27.00锛屽叾浠栨搷浣滐細8.00锛?5% 寤惰繜锛?.84 姣 绗?12 鑷?14 绉掞細绾跨▼璁℃暟锛? TPS锛?0.00 QPS锛?.00 绗崄浜旂锛氱嚎绋嬫暟锛?锛堜粠 8 杩涗竴姝ュ噺灏戯級 TPS锛?.00 QPS锛?2.00锛堣锛?.00锛屽啓锛?.00锛屽叾浠栨搷浣滐細2.00锛?95% 寤惰繜锛?.80 ms 绗?16 绉掞細绾跨▼鏁帮細6 TPS 锛?.00 QPS锛?.00 鎽樿缁熻 SQL 缁熻鏁版嵁锛氭煡璇㈡?绘暟锛?锛堣锛氥?佸啓锛氥?佸叾浠栵細锛変簨鍔℃?绘暟锛氾紙姣忕 36.98锛夌鏌ヨ鎬绘暟锛?.56 蹇界暐鐨勯敊璇細0 閲嶆柊杩炴帴锛? 鎬讳綋缁熻鏁版嵁锛氭?绘椂闂达細16 绉?浜嬩欢鎬绘暟锛氬欢杩燂細鏈?灏忓欢杩燂細98.59 姣 骞冲潎寤惰繜锛?.90 姣 鏈?澶у欢杩燂細4.12 姣 95% 寤惰繜锛?.49 姣 寤惰繜鎬诲拰锛?2.86 姣 绾跨▼鍏钩鎬э細浜嬩欢锛堝钩鍧囧??鏍囧噯宸級锛?1銆?/37.36 鎵ц鏃堕棿锛堝潎鍊?鏍囧噯宸級锛?1./2.44 鎶ュ憡姹囨?诲垎鏋?鏍规嵁sysbench鐨勫帇鍔涙祴璇曪紝鎴戜滑寰楀埌浜員encentDB for MySQL1鏍稿績1G鏈嶅姟鍣ㄦ?ц兘姹囨?汇?傞珮鍒濆鎬ц兘 TPS 鍜?QPS锛氬湪娴嬭瘯鐨勫墠鍑犵鍐咃紝鏈嶅姟鍣ㄨ〃鐜板嚭杈冮珮鐨勬瘡绉掍簨鍔℃暟 (TPS) 鍜屾瘡绉掓煡璇㈡暟 (QPS)銆傜涓?绉掞細TPS杈惧埌79.84锛孮PS涓?.77锛屽欢杩?5%涓?.51姣銆傜浜岀锛歍PS 涓?56.02锛孮PS 涓?0.50锛?5% 鏃剁殑寤惰繜涓?0.49 姣銆傚悎鐞嗙殑寤惰繜锛氬垵濮?5%寤惰繜杈冧綆锛岀郴缁熷湪鍒濆璐熻浇涓嬪叿鏈夎壇濂界殑鍝嶅簲鏃堕棿銆傛?ц兘閫愭笎涓嬮檷 TPS銆丵PS 涓嬮檷锛氶殢鐫?娴嬭瘯鐨勮繘琛岋紝TPS銆丵PS 閫愭笎涓嬮檷銆傜鍗佺锛歍PS 涓嬮檷鑷?66.00锛孮PS 涓?0.02锛屽欢杩熷鍔犺嚦 95% 鑷?0.90 姣銆傜嚎绋嬫暟鍑忓皯锛氬湪11绉掑拰15绉掓椂锛岀嚎绋嬫暟鍒嗗埆鍑忓皯鍒?涓拰6涓紝琛ㄦ槑绯荤粺鍙兘閬囧埌浜嗙嚎绋嬬鐞嗘垨璧勬簮鍒嗛厤闂銆傜鍗佷簲绉掞細TPS澶у箙涓嬮檷鑷?.00锛孮PS浠呬负12.00锛?5%寤惰繜澶у箙澧炲姞鑷?.80姣銆傚欢杩熸樉鐫?澧炲姞 寤惰繜娉㈠姩鍜屽鍔狅細寤惰繜娉㈠姩鍜屽鍔犺〃鏄庣郴缁熷湪楂樿礋杞戒笅鐨勫搷搴旀椂闂翠笉绋冲畾銆傛渶澶у欢杩熻揪鍒?.12姣锛屽钩鍧囧欢杩熶负0.90姣銆傛?讳綋缁熻锛?浜ゆ槗鎬绘暟锛氬湪16.63绉掔殑娴嬭瘯鏃堕棿鍐咃紝浜ゆ槗瀹屾垚銆傛煡璇㈡?绘暟锛氭?诲叡鎵ц浜?0 涓煡璇紙璇伙細銆佸啓锛氥?佸叾浠栨搷浣滐細锛夈?傚欢杩熸憳瑕侊細95% 寤惰繜涓?0.49 姣锛屾?诲欢杩熶负 72.86 姣銆備富瑕佸彂鐜版槸寮哄ぇ鐨勫垵濮嬫?ц兘锛? 鏍?1G 鏈嶅姟鍣ㄥ湪鍒濆璐熻浇涓嬭〃鐜拌壇濂斤紝鑳藉澶勭悊鏇撮珮鐨?TPS 鍜?QPS銆傛?ц兘閫愭笎涓嬮檷锛氶殢鐫?璐熻浇鐨勫鍔狅紝TPS鍜孮PS閫愭笎涓嬮檷锛屽欢杩熸槑鏄惧鍔狅紝鐗瑰埆鏄湪绗?5绉掋?傜嚎绋嬬鐞嗛棶棰橈細11绉掑拰15绉掔嚎绋嬫暟閲忓噺灏戯紝琛ㄦ槑绾跨▼绠＄悊鎴栬祫婧愬垎閰嶉棶棰樸?傚垵濮嬫?ц兘璇勪及锛氬浜?鏍?G鐨勬湇鍔″櫒鏉ヨ锛屽垵濮嬫?ц兘闈炲父濂斤紝鍙互鍦ㄧ煭鏃堕棿鍐呭鐞嗗ぇ閲忕殑浜嬪姟鍜屾煡璇€?傝礋杞藉簲瀵硅兘鍔涳細褰撹礋杞藉澶ф椂锛屾?ц兘鏄庢樉涓嬮檷锛岃鏄庤祫婧愭湁闄愮殑鏈嶅姟鍣ㄦ棤娉曞湪楂樿礋杞戒笅闀挎椂闂翠繚鎸佺ǔ瀹氱殑鎬ц兘銆備竴鑸潵璇达紝瀵逛簬1鏍?G鐨勬湇鍔″櫒鏉ヨ锛屽垵濮嬫?ц兘杩樻槸涓嶉敊鐨勩?傛湇鍔″櫒鐨勬?ц兘鍜岀ǔ瀹氭?т繚璇佷簡鍦ㄩ珮璐熻浇涓嬭兘澶熶繚鎸佽壇濂界殑鍝嶅簲鏃堕棿鍜屼竴鑷存?с?傛垜浠厛鏉ヨ璇村浗鍐呮暟鎹簱鎶?鏈粡鍘嗕簡鎶?鏈惎钂欍?佸鍏ャ?佹垚闀垮拰鍔犻?熷彂灞曞洓涓樁娈点?傜壒鍒槸浠婂勾浠ユ潵锛岄殢鐫?鏁板瓧鍖栬浆鍨嬬殑鍔犻?燂紝闃块噷浜戠殑Polar DB銆佽吘璁簯鐨凾DSQL绛夊浗浜ф暟鎹簱钃媰鍙戝睍锛屽睍鐜板嚭寮哄ぇ鐨勭珵浜夊姏鍜屽箍闃旂殑鍙戝睍鍓嶆櫙銆備緥濡傦紝OceanBase鍦═PC-C鍩哄噯娴嬭瘯涓墦鐮翠簡Oracle鐨勪笘鐣岀邯褰曪紝鎴愪负棣栦釜鐧婚《姒滃崟鐨勪腑鍥芥暟鎹簱浜у搧锛屾爣蹇楃潃鍥戒骇鏁版嵁搴撳湪浜戣绠楁椂浠ｇ殑鎹㈤亾銆傚叾鍥介檯璁ゅ彲搴﹂?愭笎鎻愰珮銆?OceanBase鐨勬垚鍔熶笉浠呭睍绀轰簡涓浗鏁版嵁搴撴妧鏈殑瀹炲姏锛屼篃鏍囧織鐫?鍥戒骇鏁版嵁搴撳湪鍥介檯绔炰簤涓殑宕涜捣銆傛湭鏉ワ紝闅忕潃鎶?鏈殑涓嶆柇杩涙鍜屽競鍦虹殑杩涗竴姝ユ墿澶э紝鍥戒骇鏁版嵁搴撴妧鏈湁鏈涘湪鍏ㄧ悆鑼冨洿鍐呭彂鎸ユ洿鍔犻噸瑕佺殑浣滅敤銆傛鍓嶏紝鏍稿績涓氬姟绯荤粺灏氭棤鍥戒骇鏁版嵁搴撴秹鍙婏紱姝ゅ悗锛屽浗浜ф暟鎹簱鍏徃涓嶅啀闇?瑕佸悜鐢ㄦ埛璇佹槑鍥戒骇鏁版嵁搴撴槸鍚﹀彲浠ョ珵浜夈??