{"id":10006792,"date":"2022-11-03T21:49:30","date_gmt":"2022-11-03T13:49:30","guid":{"rendered":"https:\/\/ityet.com\/?p=10006792"},"modified":"2022-11-03T21:49:30","modified_gmt":"2022-11-03T13:49:30","slug":"polardb-x-%e5%85%a8%e5%b1%80binlog%e8%a7%a3%e8%af%bb%e4%b9%8b%e6%80%a7%e8%83%bd%e7%af%87%e4%b8%8a","status":"publish","type":"post","link":"https:\/\/itmax.cn\/?p=10006792","title":{"rendered":"PolarDB-X \u5168\u5c40Binlog\u89e3\u8bfb\u4e4b\u6027\u80fd\u7bc7(\u4e0a)"},"content":{"rendered":"

\u7b80\u4ecb\uff1a\u00a0\u672c\u7bc7\u6765\u4ecb\u7ecd\u4e00\u4e0bPolarDB-X\u5168\u5c40binlog\u5728\u6027\u80fd\u65b9\u9762\u7684\u4e00\u4e9b\u8bbe\u8ba1\u548c\u601d\u8003\uff0c\u5148\u901a\u8fc7\u51e0\u4e2a\u5b9e\u9645\u7684\u6d4b\u8bd5\u6848\u4f8b\u6765\u5c55\u793a\u5168\u5c40binlog\u7684\u6027\u80fd\u60c5\u51b5\uff0c\u7136\u540e\u7ed3\u5408\u8fd9\u4e9b\u6848\u4f8b\u6765\u6df1\u5165\u8bb2\u89e3\u5168\u5c40binlog\u5173\u4e8e\u4f18\u5316\u7684\u6545\u4e8b\u3002\u672c\u7bc7\u6765\u4ecb\u7ecd\u4e00\u4e0bPolarDB-X\u5168\u5c40binlog\u5728\u6027\u80fd\u65b9\u9762\u7684\u4e00\u4e9b\u8bbe\u8ba1\u548c\u601d\u8003\uff0c\u5148\u901a\u8fc7\u51e0\u4e2a\u5b9e\u9645\u7684\u6d4b\u8bd5\u6848\u4f8b\u6765\u5c55\u793a\u5168\u5c40binlog\u7684\u6027\u80fd\u60c5\u51b5\uff0c\u7136\u540e\u7ed3\u5408\u8fd9\u4e9b\u6848\u4f8b\u6765\u6df1\u5165\u8bb2\u89e3\u5168\u5c40binlog\u5173\u4e8e\u4f18\u5316\u7684\u6545\u4e8b\u3002\u6d4b\u8bd5\u51c6\u5907\u51c6\u5907\u4e00\u4e2aPolarDB-X 2.0\u5b9e\u4f8b\uff0c\u672c\u6587\u6d4b\u8bd5\u6240\u7528\u5b9e\u4f8b\u7248\u672c\u4e3a5.4.14-16576195\uff0c\u5b9e\u4f8b\u914d\u7f6e\u5982\u4e0b\uff1a\u5b9e\u4f8b\u62d3\u6251\uff1a8CN + 8DN + 2CDC\u5355CN\u8282\u70b9\u89c4\u683c\uff1a32\u6838128GB\u5355DN\u8282\u70b9\u89c4\u683c\uff1a32\u6838128GB\u5355CDC\u8282\u70b9\u89c4\u683c\uff1a16\u683832GB\u51c6\u5907\u4e24\u53f0ECS\u538b\u6d4b\u673a\uff0c\u673a\u5668\u914d\u7f6e\uff1a64\u6838128G\u540d\u8bcd\u89e3\u91caEPSEvent Per Second\uff0c\u6bcf\u79d2\u5199\u5165binlog\u6587\u4ef6\u7684event\u4e2a\u6570DML EPSDML Event Per Second\uff0c\u6bcf\u79d2\u5199\u5165binlog\u6587\u4ef6\u7684dml event\u4e2a\u6570\uff0c\u6240\u8c13dml event\u7279\u6307binlog\u4e2d\u7684TableMapEvent\u3001WriteRowsEvent\u3001UpdateRowsEvent\u548cDeleteRowsEventBPSByte Per Second\uff0c\u6bcf\u79d2\u5199\u5165binlog\u6587\u4ef6\u7684\u5b57\u8282\u6570\uff0c\u540e\u6587\u4e3a\u8868\u8fbe\u65b9\u4fbf\uff0c\u91c7\u7528M\/s\u6765\u4f5c\u4e3a\u8ba1\u91cf\u5355\u4f4dTPSTransaction Per Second\uff0c\u6bcf\u79d2\u949f\u5199\u5165binlog\u6587\u4ef6\u7684\u4e8b\u52a1\u4e2a\u6570FPMFile Per Minute\uff0c\u6bcf\u5206\u949f\u751f\u6210binlog\u6587\u4ef6\u7684\u4e2a\u6570\uff0c\u5355\u4e2a\u6587\u4ef6\u5927\u5c0f500MDelay Time\u5ef6\u8fdf\u65f6\u95f4\uff0c\u5355\u4f4dms\u6d4b\u8bd5\u65b9\u6848TPCC\u6d4b\u8bd5\u65b9\u6cd5\u53c2\u89c1\uff1ahttps:\/\/help.aliyun.com\/docum…<\/a>\u672c\u6d4b\u8bd5\u6848\u4f8b\uff0cTPCC\u6838\u5fc3\u53c2\u6570\u7684\u914d\u7f6e\u5982\u4e0b\uff1awarehouses=2000loadWorkers=500terminals=1024runLoader.sh \u4e2dJVM\u53c2\u6570\u914d\u7f6e -Xms60g -Xmx60grunBenchmark.sh \u4e2dJVM\u53c2\u6570\u914d\u7f6e -Xms60g -Xmx60g\u573a\u666f\u4e00\uff1aTPCC\u6570\u636e\u5bfc\u5165\u6d4b\u8bd5\u76ee\u7684\u5728\u8fdb\u884c\u538b\u6d4b\u6570\u636e\u5bfc\u5165\u65f6\uff0cDN\u8282\u70b9\u4f1a\u77ac\u65f6\u4ea7\u751f\u5927\u91cf\u7269\u7406binlog\uff0c\u501f\u6b64\u89c2\u5bdf\u5168\u5c40binlog\u7684\u6027\u80fd\u6307\u6807\u60c5\u51b5\u6d4b\u8bd5\u65b9\u5f0f\u5728\u6bcf\u53f0ECS\u4e0a\u9762\u5206\u522b\u90e8\u7f72\u591a\u4efdtpcc\u7a0b\u5e8f\u5305\uff0c\u540c\u65f6\u8fd0\u884c\u591a\u4e2a.\/runDatabaseBuild.sh\uff0c\u6765\u6784\u9020\u6d41\u91cf\u573a\u666f\u4e8c\uff1aTPCC\u4ea4\u6613\u6d4b\u8bd5\u6d4b\u8bd5\u76ee\u7684\u6267\u884cTPCC\u6d4b\u8bd5\uff0c\u6a21\u62df\u771f\u5b9e\u4ea4\u6613\u573a\u666f\uff0c\u8003\u5bdf\u5168\u5c40binlog\u7684\u6027\u80fd\u60c5\u51b5(\u91cd\u70b9\u5173\u6ce8\u5ef6\u8fdf)\u6d4b\u8bd5\u65b9\u5f0f\u8c03\u6574\u538b\u6d4b\u5e76\u53d1\u5ea6\uff0c\u6784\u9020\u4e0d\u540c\u7684tmpC\u53c2\u8003\u6307\u6807\uff0c\u89c2\u5bdf\u5168\u5c40binlog\u5ef6\u8fdf\u6307\u6807\u3002\u7531\u4e8e8CN+8DN\u5728\u538b\u529b\u6253\u6ee1\u7684\u60c5\u51b5\u4e0b\uff0c\u5168\u5c40binlog\u7684\u5ef6\u8fdf\u4f9d\u7136\u6bd4\u8f83\u4f4e\uff0c\u6240\u4ee5\u4e0b\u9762\u7684\u6d4b\u8bd5\uff0c\u4e0d\u5c40\u9650\u4e8e8CN+8DNSysbench\u6d4b\u8bd5\u65b9\u6cd5\u53c2\u89c1:\u00a0https:\/\/help.aliyun.com\/docum…<\/a>\u573a\u666f\u4e00\uff1aSysbench\u6570\u636e\u5bfc\u5165\u6d4b\u8bd5\u76ee\u7684\u5728\u8fdb\u884c\u538b\u6d4b\u6570\u636e\u5bfc\u5165\u65f6\uff0cDN\u8282\u70b9\u4f1a\u77ac\u65f6\u4ea7\u751f\u5927\u91cf\u7269\u7406binlog\uff0c\u501f\u6b64\u89c2\u5bdf\u5168\u5c40binlog\u7684\u6027\u80fd\u6307\u6807\u60c5\u51b5\u6d4b\u8bd5\u65b9\u5f0f\u8c03\u6574–tables\u548c–threads\u7684\u53c2\u6570\u503c\uff0c\u6d4b\u8bd5\u4e0d\u540c\u538b\u529b\u72b6\u6001\u4e0b\u5168\u5c40binlog\u7684\u6027\u80fd\u6307\u6807\u573a\u666f\u4e8c\uff1aSysbench oltp_write_only\u6d4b\u8bd5\u76ee\u7684\u6267\u884csysbench oltp_write_only\uff0c\u6d4b\u8bd5\u6df7\u5408\u5199\u5165\u573a\u666f\u4e0b\uff0c\u5168\u5c40binlog\u6027\u80fd\u60c5\u51b5\u6d4b\u8bd5\u65b9\u5f0f\u6267\u884coltp_write_only\uff0c\u6784\u9020\u4e0d\u540cqps\u53c2\u8003\u6307\u6807\uff0c\u89c2\u5bdf\u5168\u5c40binlog\u5ef6\u8fdf\u60c5\u51b5Large Transaction\u6d4b\u8bd5\u76ee\u7684\u6d4b\u8bd5\u8d85\u5927\u4e8b\u52a1\u573a\u666f\u4e0b\uff0cCDC\u7684\u6027\u80fd\u60c5\u51b5\u548c\u7a33\u5b9a\u6027\uff0c\u91cd\u70b9\u5173\u6ce8\u5ef6\u8fdf\u65f6\u95f4\u6d4b\u8bd5\u65b9\u5f0f\u53c2\u8003\u5982\u4e0b\u811a\u672c\uff0c\u6784\u9020\u4e0d\u540c\u5927\u5c0f\u7684\u4e8b\u52a1\uff0c\u8fdb\u884c\u6d4b\u8bd5\uff0c\u6309\u5982\u4e0b\u811a\u672c\uff0c\u6bcf\u63d2\u516520w\u6761\u6570\u636e\u53ef\u4ee5\u6784\u9020\u4e00\u4e2a500M\u5927\u5c0f\u7684\u4e8b\u52a1CREATE TABLE t_1<\/code>
(id<\/code> bigint(20) NOT NULL AUTO_INCREMENT,
c_bit_1<\/code> bit(1) DEFAULT NULL,
c_bit_8<\/code> bit(8) DEFAULT NULL,
c_bit_16<\/code> bit(16) DEFAULT NULL,
c_bit_32<\/code> bit(32) DEFAULT NULL,
c_bit_64<\/code> bit(64) DEFAULT NULL,
c_tinyint_1<\/code> tinyint(1) DEFAULT NULL,
c_tinyint_4<\/code> tinyint(4) DEFAULT NULL,
c_tinyint_8<\/code> tinyint(8) DEFAULT NULL,
c_tinyint_8_un<\/code> tinyint(8) unsigned DEFAULT NULL,
c_smallint_1<\/code> smallint(1) DEFAULT NULL,
c_smallint_16<\/code> smallint(16) DEFAULT NULL,
c_smallint_16_un<\/code> smallint(16) unsigned DEFAULT NULL,
c_mediumint_1<\/code> mediumint(1) DEFAULT NULL,
c_mediumint_24<\/code> mediumint(24) DEFAULT NULL,
c_mediumint_24_un<\/code> mediumint(24) unsigned DEFAULT NULL,
c_int_1<\/code> int(1) DEFAULT NULL,
c_int_32<\/code> int(32) DEFAULT NULL,
c_int_32_un<\/code> int(32) unsigned DEFAULT NULL,
c_bigint_1<\/code> bigint(1) DEFAULT NULL,
c_bigint_64<\/code> bigint(64) DEFAULT NULL,
c_bigint_64_un<\/code> bigint(64) unsigned DEFAULT NULL,
c_decimal<\/code> decimal DEFAULT NULL,
c_decimal_pr<\/code> decimal(10,3) DEFAULT NULL,
c_float<\/code> float DEFAULT NULL,
c_float_pr<\/code> float(10,3) DEFAULT NULL,
c_float_un<\/code> float(10,3) unsigned DEFAULT NULL,
c_double<\/code> double DEFAULT NULL,
c_double_pr<\/code> double(10,3) DEFAULT NULL,
c_double_un<\/code> double(10,3) unsigned DEFAULT NULL,
c_date<\/code> date DEFAULT NULL COMMENT ‘date’,
c_datetime<\/code> datetime DEFAULT NULL,
c_timestamp<\/code> timestamp DEFAULT CURRENT_TIMESTAMP,
c_time<\/code> time DEFAULT NULL,
c_year<\/code> year DEFAULT NULL,
c_year_4<\/code> year(4) DEFAULT NULL,
c_char<\/code> char(50) DEFAULT NULL,
c_varchar<\/code> varchar(50) DEFAULT NULL,
c_binary<\/code> binary(200) DEFAULT NULL,
c_varbinary<\/code> varbinary(200) DEFAULT NULL,
c_blob_tiny<\/code> tinyblob DEFAULT NULL,
c_blob<\/code> blob DEFAULT NULL,
c_blob_medium<\/code> mediumblob DEFAULT NULL,
c_blob_long<\/code> longblob DEFAULT NULL,
c_text_tiny<\/code> tinytext DEFAULT NULL,
c_text<\/code> text DEFAULT NULL,
c_text_medium<\/code> mediumtext DEFAULT NULL,
c_text_long<\/code> longtext DEFAULT NULL,
c_enum<\/code> enum(‘a’,’b’,’c’) DEFAULT NULL,
c_set<\/code> set(‘a’,’b’,’c’) DEFAULT NULL,
c_testcase<\/code> varchar(10) DEFAULT NULL,
PRIMARY KEY (id<\/code>) )ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT=’10000000′ dbpartition by hash(id<\/code>) tbpartition by hash(id<\/code>) tbpartitions 8;INSERT t_1 (c_bit_1 , c_bit_8 , c_bit_16 , c_bit_32 , c_bit_64 , c_tinyint_1 , c_tinyint_4 , c_tinyint_8 , c_tinyint_8_un , c_smallint_1 , c_smallint_16 , c_smallint_16_un , c_mediumint_1 , c_mediumint_24 , c_mediumint_24_un , c_int_1 , c_int_32 , c_int_32_un , c_bigint_1 , c_bigint_64 , c_bigint_64_un , c_decimal , c_decimal_pr , c_float , c_float_pr , c_float_un , c_double , c_double_pr , c_double_un , c_date , c_datetime , c_timestamp , c_time , c_year , c_year_4 , c_char , c_varchar , c_binary , c_varbinary , c_blob_tiny , c_blob , c_blob_medium , c_blob_long , c_text_tiny , c_text , c_text_medium , c_text_long , c_enum , c_set , c_testcase)
VALUES(
b’1′ , b’11111111′ , b’1111111111111111′ , b’11111111111111111111111111111111′ , b’1111111111111111111111111111111111111111111111111111111111111111′ , ’82’ , ‘-101’ , ‘-75′ ,’253’ , ‘14497’ , ‘5070’ , ‘9427’ , ‘-5888259’ , ‘-1845105’ , ‘2350597’ , ‘-2147483648’ , ‘-2147483648’ , ‘3653062473’ , ‘-816854218224922624’ , ‘7292572323853307904’ , ‘2902765992697493504’ , ‘-1613793319’ , ‘1223077.292’ , ‘9.1096275E8’ , ‘-5839673.5’ , ‘2648.644’ , ‘4.334081673614155E9’ , ‘6973286.176’ , ‘7630560.182’ , ‘2019-02-15’ , ‘2019-02-15 14:54:41’ , ‘2019-02-15 14:54:41′ , ’20:12:46’ , ‘2019’ , ‘2019’, ‘xxx’,’int a = max(4,5)’,’xxxxxxx’,’varchar a = ‘,’xxkdkwjsjdfdsk’,’varchar a = ‘,’;sdjfaljdljfsljldjlsjdljflsjdlfjsaljdlfhahdljflajdlfasdf’,’int a = max(4,5)’,’xxx’,’sdjflshdflsjlfa;;dfjadjfahdfhklsajdfklsafasjlfjls’,repeat(‘a’,1024),repeat(‘a’,1024), ‘a’, ‘a’, ‘caseNo1’);INSERT t_1 ( c_bit_1 , c_bit_8 , c_bit_16 , c_bit_32 , c_bit_64 , c_tinyint_1 , c_tinyint_4 , c_tinyint_8 , c_tinyint_8_un , c_smallint_1 ,
c_smallint_16 , c_smallint_16_un , c_mediumint_1 , c_mediumint_24 , c_mediumint_24_un , c_int_1 , c_int_32 , c_int_32_un , c_bigint_1 , c_bigint_64
, c_bigint_64_un , c_decimal , c_decimal_pr , c_float , c_float_pr , c_float_un , c_double , c_double_pr , c_double_un , c_date , c_datetime , c_timestamp , c_time , c_year , c_year_4 , c_char , c_varchar , c_binary , c_varbinary , c_blob_tiny , c_blob , c_blob_medium , c_blob_long , c_text_tiny , c_text , c_text_medium , c_text_long , c_enum , c_set , c_testcase) select c_bit_1 , c_bit_8 , c_bit_16 , c_bit_32 , c_bit_64 , c_tinyint_1 , c_tinyint_4 , c_tinyint_8 , c_tinyint_8_un , c_smallint_1 , c_smallint_16 , c_smallint_16_un , c_mediumint_1 , c_mediumint_24 , c_mediumint_24_un , c_int_1 , c_int_32 , c_int_32_un , c_bigint_1 , c_bigint_64 , c_bigint_64_un , c_decimal , c_decimal_pr , c_float , c_float_pr , c_float_un , c_double , c_double_pr , c_double_un , c_date , c_datetime , c_timestamp , c_time , c_year , c_year_4 , c_char , c_varchar , c_binary , c_varbinary , c_blob_tiny , c_blob , c_blob_medium , c_blob_long , c_text_tiny , c_text , c_text_medium , c_text_long , c_enum , c_set , c_testcase from t_1;\u6d4b\u8bd5\u62a5\u544a\u5148\u7ed9\u51fa\u6c47\u603b\u540e\u7684\u6d4b\u8bd5\u62a5\u544a\uff0c\u518d\u8fdb\u884c\u8be6\u7ec6\u4ecb\u7ecd\uff0c\u6d4b\u8bd5\u6570\u636e\u5982\u4e0b\uff1a\u6d4b\u8bd5\u573a\u666f\u53c2\u8003\u6307\u6807DelayTimeEPSBPSTPCC\u6570\u636e\u5bfc\u51654000\u4ed3\/600\u5e76\u53d1300ms10w\/s350M\/sTPCC\u6570\u636e\u5bfc\u51658000\u4ed3\/1200\u5e76\u53d1700ms15w\/s450M\/s-500M\/sTPCC\u6570\u636e\u5bfc\u516512000\u4ed3\/1800\u5e76\u53d11s-60s15w\/s450M\/s-500M\/sSysbench\u6570\u636e\u5bfc\u516532Tables\/32\u5e76\u53d1500ms180w\/s140M\/sSysbench\u6570\u636e\u5bfc\u516548Tables\/48\u5e76\u53d11s210w\/s170M\/sSysbench\u6570\u636e\u5bfc\u516564Tables\/64\u5e76\u53d11s-70s220w\/s180M\/sTPCC\u4ea4\u6613\u6d4b\u8bd550w tpmC400ms60w\/s130M\/sTPCC\u4ea4\u6613\u6d4b\u8bd5100w tpmC500ms120w\/s250M\/sTPCC\u4ea4\u6613\u6d4b\u8bd5150w tpmC1s-4s170w\/s350M\/sSysbench Oltp_write_only20w QPS500ms130w\/s125M\/sSysbench Oltp_write_only30w QPS600ms180w\/s170M\/sSysbench Oltp_write_only35w QPS1s-18s210w\/s200M\/s\u5927\u4e8b\u52a1500M2s24w\/s500M\/s\u5927\u4e8b\u52a11G4.8s24w\/s500M\/s\u5927\u4e8b\u52a12G7.8s24w\/s500M\/s\u5927\u4e8b\u52a13G9.4s24w\/s500M\/s\u5927\u4e8b\u52a14G12.5s24w\/s500M\/s\u5927\u4e8b\u52a15G(no swap)17s24w\/s500M\/s\u5927\u4e8b\u52a15G(with swap)25s22w\/s350M\/s\u5927\u4e8b\u52a110G(with swap)55s22w\/s350M\/s\u5927\u4e8b\u52a120G(with swap)115s22w\/s350M\/sTPCC\u6570\u636e\u5bfc\u5165Test With 2 ClientEPS: 10w\/s\uff0cDML EPS: 6w\/s
\"\u56fe\u7247\"
BPS: 350M\/s\uff0cFPM: 40\u4e2a\/m
\"\u56fe\u7247\"
TPS: 11000\/s
\"\u56fe\u7247\"
Delay Time: 300ms
\"\u56fe\u7247\"
\u53e6\u9644CDC\u8fdb\u7a0bGC\u60c5\u51b5\uff1a\u5185\u5b58\u4f7f\u7528\u7387\u4e0d\u9ad8\u3001GC\u5e73\u7a33\u3001\u65e0\u8001\u5e74\u4ee3GC
\"\u56fe\u7247\"
\u7efc\u8ff0\uff1a\u4e24\u4e2aclient\u573a\u666f\u4e0b(4000\u4ed3\/600\u5e76\u53d1)\uff0c\u5199\u5165\u541e\u5410\u5e73\u5747\u503c\u7ea6350M\/s\uff0c\u5ef6\u8fdf\u65f6\u95f4\u5728300ms\u5de6\u53f3\uff0c\u5b8c\u5168\u65e0\u538b\u529bTest With 4 ClientEPS: 14w\/s ~ 16w\/s\uff0cDML EPS: 7.5w\/s ~ 9w\/s
\"\u56fe\u7247\"
BPS: 450M\/s ~ 500M\/s\uff0cFPM: 52\u4e2a\/m ~ 60\u4e2a\/m
\"\u56fe\u7247\"
TPS: 15000\/s
\"\u56fe\u7247\"
Delay Time: 700ms\uff0c\u6700\u5927\u5ef6\u8fdf\u6296\u52a810S
\"\u56fe\u7247\"
\u53e6\u9644CDC\u8fdb\u7a0bGC\u60c5\u51b5\uff1a\u8001\u5e74\u4ee3\u5185\u5b58\u4f7f\u7528\u7387\u7565\u6709\u63d0\u5347\u3001GC\u5e73\u7a33\u3001\u65e0\u8001\u5e74\u4ee3GC
\"\u56fe\u7247\"
\u7efc\u8ff0\uff1a\u56db\u4e2aclient\u573a\u666f\u4e0b(8000\u4ed3\/1200\u5e76\u53d1)\uff0c\u57fa\u672c\u65e0\u538b\u529b\uff0c\u5199\u5165\u541e\u5410\u5728450M\/s\uff5e500M\/s\uff0c\u5ef6\u8fdf\u65f6\u95f4\u603b\u4f53\u4e0a\u53ef\u4ee5\u7ef4\u6301\u57281S\u4ee5\u4e0b\uff0c\u6700\u5927\u5ef6\u8fdf\u6296\u52a810S\u4e14\u6709\u4e00\u5b9a\u7684\u6301\u7eed\u65f6\u95f4\uff0c\u5176\u5b83\u5927\u90e8\u5206\u6307\u6807\u76f8\u6bd4\u4e24\u4e2aclient\u573a\u666f\u57fa\u672c\u53ef\u4ee5\u8fbe\u5230\u7ffb\u500dTest With 6 ClientEPS: 14w\/s ~ 16w\/s\uff0cDML EPS: 8w\/s ~ 9w\/s
\"\u56fe\u7247\"
BPS: 450M\/s ~ 500M\/s\uff0cFPM: 55\u4e2a\/m ~ 60\u4e2a\/m
\"\u56fe\u7247\"
TPS: 15000\/s
\"\u56fe\u7247\"
Delay Time: \u5ef6\u8fdf\u5448\u9012\u589e\u8d8b\u52bf\uff0c\u6700\u5927\u5ef6\u8fdf1\u5206\u949f
\"\u56fe\u7247\"
\u53e6\u9644CDC\u8fdb\u7a0bGC\u60c5\u51b5\uff1a\u7f13\u51b2\u533a\u5f00\u59cb\u51fa\u73b0\u79ef\u538b\uff0c\u8001\u5e74\u4ee3\u4f7f\u7528\u7387\u63d0\u5347\u660e\u663e
\"\u56fe\u7247\"
\u53e6\u9644CDC\u6587\u4ef6\u5199\u5165\u7ebf\u7a0bCPU\u4f7f\u7528\u7387\u60c5\u51b5
\"\u56fe\u7247\"
\u7efc\u8ff0\uff1a\u516d\u4e2aclient\u573a\u666f\u4e0b(12000\u4ed3\/1800\u5e76\u53d1)\uff0c\u5ef6\u8fdf\u5f00\u59cb\u51fa\u73b0\u589e\u957f\uff0c\u6570\u636e\u5bfc\u5165\u65f6\u957f20min\uff0c\u89e6\u53d1\u6700\u5927\u5ef6\u8fdf60S\uff0c\u5176\u5b83\u6307\u6807\u548c4\u4e2aClient\u573a\u666f\u4e0b\u76f8\u6bd4\u57fa\u672c\u6301\u5e73\uff0c\u4e3b\u8981\u74f6\u9888\u70b9\u5728\u6587\u4ef6\u5199\u5165\u7ebf\u7a0b\uff0cCPU\u4f7f\u7528\u7387\u5df2\u7ecf\u8fbe\u5230\u4e86100%\uff0c\u6bcf\u79d2500M\u5de6\u53f3\u7684\u5199\u5165\u901f\u5ea6\u76ee\u524d\u662f\u5168\u5c40binlog\u80fd\u652f\u6301\u7684\u6700\u5927\u541e\u5410\uff0c\u540e\u5e8f\u8fdb\u4e00\u6b65\u7684\u4f18\u5316\u8fdb\u5c55\u4f1a\u5728\u672c\u6587\u6301\u7eed\u66f4\u65b0\uff0c\u656c\u8bf7\u5173\u6ce8Sysbench\u6570\u636e\u5bfc\u5165Test With 32 Tablessysbench –config-file=’sysb.conf’ –create-table-options=’dbpartition by hash(id<\/code>) tbpartition by hash(id) tbpartitions 8′ –tables=’32’ –threads=’32’ –table-size=’10000000′ oltp_point_select prepareEPS: 180w\/s\uff0cDML EPS: 60w\/s
\"\u56fe\u7247\"
BPS: 140M\/s\uff0cFPM: 17\u4e2a\/m
\"\u56fe\u7247\"
TPS: 30w\/s
\"\u56fe\u7247\"
Delay Time: 500ms,\u6700\u5927\u5ef6\u8fdf\u6296\u52a82s
\"\u56fe\u7247\"
\u7efc\u8ff0\uff1a32\u5f20\u8868\u5e76\u884c\u63d2\u5165\u573a\u666f\u4e0b\uff0c\u5ef6\u8fdf\u57fa\u672c\u53ef\u4ee5\u63a7\u5236\u57281s\u4ee5\u5185\u3002\u76f8\u6bd4TPCC\u5bfc\u6570\u636e\uff0cSysbench\u573a\u666f\u4e0bEPS\u6307\u6807\u5448\u73b0\u4e86\u6570\u5341\u500d\u7684\u63d0\u5347\uff0c\u4f46BPS\u6307\u6807\u5219\u8981\u4f4e\u5f88\u591a\uff0c\u4e3b\u8981\u662f\u56e0\u4e3aSysbench\u7684\u8868\u6bd4\u8f83\u5c0f\uff0c\u63d2\u5165\u903b\u8f91\u4e5f\u7b80\u5355\u76f4\u63a5\uff0c\u6240\u4ee5\u6570\u636e\u63d2\u5165\u7684rps(record per second)\u5f88\u9ad8\u4f46\u6d41\u91cf\u5e76\u4e0d\u662f\u5f88\u5927\uff0c\u5404\u9879\u6307\u6807\u5bf9\u6bd4\u89c1\u4e0b\u8868\uff1a\u6307\u6807\u9879TPCCSysbenchEPS14w\/s ~ 16w\/s170w\/sDML EPS7.5w\/s ~ 9w\/s60w\/sBPS450M\/s ~ 500M\/s140M\/sTPS15000\/s30w\/sDelay Time700ms500msFPM52\u4e2a\/m ~ 60\u4e2a\/m17\u4e2a\/mTest With 48 Tablessysbench –config-file=’sysb.conf’ –create-table-options=’dbpartition by hash(id<\/code>) tbpartition by hash(id) tbpartitions 8′ –tables=’48’ –threads=’48’ –table-size=’10000000′ oltp_point_select prepareEPS: 210w\/s\uff0cDML EPS: \u63a5\u8fd170w\/s
\"\u56fe\u7247\"
BPS: 170M\/s
\"\u56fe\u7247\"
TPS: 36w\/s\uff0cFPM: 20\u4e2a\/m
\"\u56fe\u7247\"
Delay Time: 1s\uff0c\u6700\u5927\u5ef6\u8fdf10s
\"\u56fe\u7247\"
\u7efc\u8ff0\uff1a48\u5f20\u8868\u5e76\u884c\u63d2\u5165\u573a\u666f\u4e0b\uff0c\u5404\u9879\u6307\u6807\u6709\u4e86\u5c0f\u5e45\u5ea6\u63d0\u5347\uff0c\u5ef6\u8fdf\u65f6\u95f4\u603b\u4f53\u57281s\u5de6\u53f3\uff0c\u6700\u592710s\u3002Test With 64 Tablessysbench –config-file=’sysb.conf’ –create-table-options=’dbpartition by hash(id<\/code>) tbpartition by hash(id) tbpartitions 8′ –tables=’64’ –threads=’64’ –table-size=’10000000′ oltp_point_select prepareEPS: 220w\/s\uff0cDML EPS: \u63a5\u8fd175w\/s
\"\u56fe\u7247\"
BPS: 180M\/s
\"\u56fe\u7247\"
TPS: 37w\/s\uff0cFPM: 21\u4e2a\/m
\"\u56fe\u7247\"
Delay Time: \u6700\u5927\u5ef6\u8fdf70s
\"\u56fe\u7247\"
\u7efc\u8ff0\uff1a64\u5f20\u8868\u5e76\u884c\u63d2\u5165\u573a\u666f\u4e0b\uff0c\u5404\u9879\u6307\u6807\u6709\u4e86\u5c0f\u5e45\u5ea6\u63d0\u5347\uff0c\u5ef6\u8fdf\u65f6\u95f4\u5f00\u59cb\u589e\u5927\uff0c\u6700\u5927\u5ef6\u8fdf\u65f6\u95f470s\u3002\u56e0\u6d89\u53ca\u5168\u5c40\u6392\u5e8f\u548c\u4e8b\u52a1\u5408\u5e76\uff0c\u4ee5\u53ca\u9700\u8981\u5bf9\u6bcf\u4e2aevent\u8fdb\u884cchecksum\u7684\u8ba1\u7b97\uff0c\u76ee\u524d\u5168\u5c40binlog\u53ef\u652f\u6301\u7684\u6700\u5927EPS\u5728220w\/S\u5de6\u53f3\uff0c\u540e\u5e8f\u8fdb\u4e00\u6b65\u7684\u4f18\u5316\u8fdb\u5c55\u4f1a\u5728\u672c\u6587\u6301\u7eed\u66f4\u65b0\uff0c\u656c\u8bf7\u5173\u6ce8TPCC\u4ea4\u6613\u6d4b\u8bd550w-55w tpmCtpmC: 50w\/m ~ 55w\/m
\"\u56fe\u7247\"
EPS: 60w\/s\uff0cDML EPS: 37w\/s ~ 40w\/s
\"\u56fe\u7247\"
BPS: 130M\/s\uff0cFPM: 15\u4e2a\/m
\"\u56fe\u7247\"
TPS: 18000\/s
\"\u56fe\u7247\"
Delay Time: 400ms
\"\u56fe\u7247\"
\u7efc\u8ff0\uff1atpmC 50w\/m ~ 55w\/m\uff0cTps 18000\/s, \u5168\u5c40binlog\u5ef6\u8fdf400ms\u5de6\u53f3, DML EPS\u5e73\u5747\u572837w\/s\u5de6\u53f3\uff0cBPS 130M\/s\u5de6\u53f3100w-105w tpmCtpmC: 100w\/m ~ 105w\/m
\"\u56fe\u7247\"
EPS: 120w\/s\uff0cDML EPS: 75w\/s
\"\u56fe\u7247\"
BPS: 250M\/s\uff0cFPM: 30\u4e2a\/m
\"\u56fe\u7247\"
TPS: 35000\/s
\"\u56fe\u7247\"
Delay Time: 500ms
\"\u56fe\u7247\"
\u7efc\u8ff0\uff1atpmC 100w\/m~105w\/m\uff0cTps 35000\/s, \u5168\u5c40binlog\u5ef6\u8fdf500ms\u5de6\u53f3, DML EPS\u5e73\u5747\u572875w\/s\u5de6\u53f3\uff0cBPS 250M\/s\u5de6\u53f3145w-150w tpmCtpmC: 145w\/m ~ 150w\/m
\"\u56fe\u7247\"
EPS: 170w\/s\uff0cDML EPS: 100w\/s
\"\u56fe\u7247\"
BPS: 350M\/s\uff0cFPM: 42\u4e2a\/m
\"\u56fe\u7247\"
TPS: 50000\/s
\"\u56fe\u7247\"
Delay Time: 1s ~ 4s\u3002\u524d\u6bb5\u548c\u540e\u6bb5\u5ef6\u8fdf\u57281.5s\u5de6\u53f3\uff0c\u4e2d\u6bb5\u5ef6\u8fdf\u57284s\u5de6\u53f3\uff0c\u4f46\u4e2d\u6bb5tpmC\u5176\u5b9e\u5e76\u6ca1\u6709\u524d\u6bb5\u9ad8\uff0c\u539f\u56e0\u5728\u4e8e\u5728\u538b\u529b\u6253\u6ee1\u60c5\u51b5\u4e0b\uff0c\u5076\u53d1\u6296\u52a8\u90fd\u4f1a\u5bfc\u81f4\u5ef6\u8fdf\u65f6\u95f4\u7684\u53d8\u5316\uff0c\u591a\u6b21\u590d\u6d4b\u5e76\u4e0d\u662f\u6bcf\u6b21\u90fd\u4f1a\u8fbe\u52304s\u5ef6\u8fdf\uff0c\u8fd9\u91cc\u53d6\u4e00\u4e2a\u6700\u574f\u7684\u6d4b\u8bd5\u7ed3\u679c\uff0c150w tpmC\u573a\u666f\u4e0b\u5e38\u89c4\u5ef6\u8fdf\u65f6\u95f4\u5927\u6982\u57282s\u5de6\u53f3
\"\u56fe\u7247\"
\u7efc\u8ff0\uff1atpmC 145w\/m ~ 150w\/m\uff0cTps 50000\/s, \u5168\u5c40binlog\u5ef6\u8fdf1s-4s\u5de6\u53f3\uff0cEPS 170w\/s\uff0cDML EPS\u5e73\u5747\u5728100w\/s\u5de6\u53f3\uff0cBPS 350M\/s\u5de6\u53f3Sysbench oltp_write_only20w qpssysbench –config-file=’sysb.conf’ –db-ps-mode=’disable’ –skip-trx=’on’ –mysql-ignore-errors=’all’ –tables=’16’ –table-size=’10000000′ –threads=300 oltp_write_only runSysbench: 21w+ qps, 5w+ tps
\"\u56fe\u7247\"
\u5ef6\u8fdf\u65f6\u95f4\uff1a500ms
\"\u56fe\u7247\"
EPS:130w+, DML EPS:43w+
\"\u56fe\u7247\"
BPS: 125M\/s
\"\u56fe\u7247\"
30w qpssysbench –config-file=’sysb.conf’ –db-ps-mode=’disable’ –skip-trx=’on’ –mysql-ignore-errors=’all’ –tables=’16’ –table-size=’10000000′ –threads=512 oltp_write_only runSysbench: 30w qps, 7.5w tps
\"\u56fe\u7247\"
\u5ef6\u8fdf\u65f6\u95f4\uff1a600ms
\"\u56fe\u7247\"
EPS:180w+, DML EPS:55w+
\"\u56fe\u7247\"
BPS: 170M\/s
\"\u56fe\u7247\"
35w qpssysbench –config-file=’sysb.conf’ –db-ps-mode=’disable’ –skip-trx=’on’ –mysql-ignore-errors=’all’ –tables=’16’ –table-size=’10000000′ –threads=800 oltp_write_only runSysbench: 35w~40w qps, 9w~10w tps
\"\u56fe\u7247\"
\u5ef6\u8fdf\u65f6\u95f4\uff1a18s
\"\u56fe\u7247\"
EPS: 200w+\/s, DML EPS:70w+\/s
\"\u56fe\u7247\"
BPS: 200M\/s
\"\u56fe\u7247\"
\u7efc\u8ff0\uff1a35w qps\u538b\u529b\u4e0b\uff0c\u5df2\u7ecf\u63a5\u8fd1220w\/s\u7684\u6700\u5927EPS\u80fd\u529b\uff0c\u538b\u6d4b\u65f6\u95f410\u5206\u949f\uff0c\u6700\u5927\u5ef6\u8fdf\u8fbe\u523018sLarge Transaction\u5148\u6765\u4ecb\u7ecd\u51e0\u4e2a\u53c2\u6570storage.isPersistOn\u662f\u5426\u5f00\u542fswap\u529f\u80fd\uff0c\u5373\u5f53\u5185\u5b58\u4e0d\u8db3\u6216\u9047\u5230\u5927\u4e8b\u52a1\u65f6\uff0c\u662f\u5426\u652f\u6301\u6570\u636e\u4e34\u65f6swap\u5230\u78c1\u76d8(RocksDB)\uff0c\u9ed8\u8ba4\u4e3atruestorage.persist.mode\u6301\u4e45\u5316\u6a21\u5f0f\uff0c\u53ef\u9009\u914d\u7f6e\u6709\u4e24\u4e2a\uff1aAUTO\u548cFORCE\u3002AUTO\u6a21\u5f0f\u4e0b\uff0c\u7cfb\u7edf\u4f1a\u6839\u636e\u5185\u5b58\u4f7f\u7528\u7387\u81ea\u52a8\u5224\u65ad\u662f\u5426\u9700\u8981\u5c06\u6570\u636eswap\u5230\u78c1\u76d8\uff1bFORCE\u6a21\u5f0f\u4e0b\uff0c\u7cfb\u7edf\u4f1a\u5f3a\u5236\u5c06\u6570\u636eswap\u5230\u78c1\u76d8storage.persistNewThreshold\u5185\u5b58\u4e2d\u65b0\u589e\u6570\u636e\u89e6\u53d1swap\u7684\u9608\u503c\uff0c\u5373\u5185\u5b58\u4f7f\u7528\u7387\u8fbe\u5230\u591a\u5927\u4e4b\u540e\uff0c\u65b0\u589e\u6570\u636e\u4f1a\u88abswap\u5230\u78c1\u76d8\uff0c\u9ed8\u8ba485%storage.persistAllThreshold\u5185\u5b58\u4e2d\u5b58\u91cf\u6570\u636e\u89e6\u53d1swap\u7684\u9608\u503c\uff0c\u5373\u5185\u5b58\u4f7f\u7528\u7387\u8fbe\u5230\u591a\u5927\u4e4b\u540e\uff0c\u5b58\u91cf\u6570\u636e\u4f1a\u88abswap\u5230\u78c1\u76d8\uff0c\u9ed8\u8ba495%5G Close Persist\u5355\u4e2a\u4e8b\u52a1\u5927\u5c0f5G\uff0c\u5173\u95edswap\u529f\u80fd\uff0c\u672c\u6d4b\u8bd5\u573a\u666f\uff0c\u8001\u5e74\u4ee3\u5185\u5b5814G\uff0c\u5373\u4f7f\u8003\u8651\u5230\u6570\u636e\u81a8\u80c0\uff0c\u8db3\u591f\u653e\u4e0b5G\u6570\u636eDelay Time: \u6240\u6709\u6570\u636e\u5b8c\u6210\u6392\u5e8f\u65f6\u5ef6\u8fdf7s\uff0c\u6240\u6709\u6570\u636e\u8f93\u51fa\u5230\u5168\u5c40binlog\u6587\u4ef6\u65f6\u5ef6\u8fdf17s
\"\u56fe\u7247\"
Task\u8fdb\u7a0b\u5185\u5b58: \u8001\u5e74\u4ee3\u4f7f\u7528\u7387\u663e\u8457\u63d0\u5347
\"\u56fe\u7247\"
\u7efc\u8ff0\uff1a\u5173\u95ed\u6301\u4e45\u5316\uff0c\u5168\u5185\u5b58\u6a21\u5f0f\u4e0b\uff0c5G\u6570\u636e\u572817S\u5185\u5b8c\u6210\u540c\u6b65\uff0c\u8001\u5e74\u4ee3\u5185\u5b58\u4f7f\u7528\u7387\u663e\u8457\u63d0\u53475G Force Persist\u5355\u4e2a\u4e8b\u52a1\u5927\u5c0f5G\uff0c\u5f00\u542fswap\u529f\u80fd\uff0c\u5e76\u5c06\u6301\u4e45\u5316\u6a21\u5f0f\u8bbe\u7f6e\u4e3aFORCEDelay Time: \u6240\u6709\u6570\u636e\u5b8c\u6210\u6392\u5e8f\u65f6\u5ef6\u8fdf10s\uff0c\u6240\u6709\u6570\u636e\u8f93\u51fa\u5230\u5168\u5c40binlog\u6587\u4ef6\u65f6\u5ef6\u8fdf25s
\"\u56fe\u7247\"
CDC\u8fdb\u7a0b\u5185\u5b58\u60c5\u51b5: \u7531\u4e8e\u91c7\u7528\u5f3a\u5236\u6301\u4e45\u5316\u673a\u5236\uff0c\u5185\u5b58\u5360\u7528\u65e0\u8d77\u4f0f
\"\u56fe\u7247\"
\u7efc\u8ff0\uff1a\u76f8\u6bd4close persist\u6a21\u5f0f\uff0c\u5f3a\u5236\u6301\u4e45\u5316\u6a21\u5f0f\u4e0b\uff0c\u5ef6\u8fdf\u589e\u52a0\u4e868s\uff0c\u8001\u5e74\u4ee3\u5185\u5b58\u5360\u7528\u65e0\u660e\u663e\u8d77\u4f0f10G Auto Persist With 4G Memory\u5355\u4e2a\u4e8b\u52a1\u5927\u5c0f10G\uff0c\u5f00\u542fswap\u529f\u80fd\uff0c\u5e76\u5c06\u6301\u4e45\u5316\u6a21\u5f0f\u8bbe\u7f6e\u4e3aAUTO\uff0cTask\u8fdb\u7a0b\u5185\u5b58\u8bbe\u7f6e\u4e3a4G(\u65e0\u6cd5\u653e\u4e0b10G\u6570\u636e)\uff0c\u8bc4\u6d4b\u7cfb\u7edf\u7684\u81ea\u52a8\u6301\u4e45\u5316\u80fd\u529bDelay Time: \u6240\u6709\u6570\u636e\u5b8c\u6210\u6392\u5e8f\u65f6\u5ef6\u8fdf23s\uff0c\u6240\u6709\u6570\u636e\u8f93\u51fa\u5230\u5168\u5c40binlog\u6587\u4ef6\u65f6\u5ef6\u8fdf55s
\"\u56fe\u7247\"
Task\u8fdb\u7a0b\u5185\u5b58: \u8001\u5e74\u4ee3\u5e76\u672a\u663e\u8457\u4e0a\u6da8
\"\u56fe\u7247\"
Swap\u65e5\u5fd7\uff1a\u5355\u4e2a\u5c40\u90e8\u4e8b\u52a1\u5927\u5c0f\u8d85\u8fc7\u9608\u503c\uff0c\u76f4\u63a5\u89e6\u53d1\u4e86swap
\"\u56fe\u7247\"
\u7efc\u8ff0\uff1aAUTO\u6a21\u5f0f\u4e0b\uff0c\u5bf9\u4e8e\u5927\u4e8b\u52a1\u7684\u843d\u76d8\uff0c\u7cfb\u7edf\u91c7\u53d6\u4e86\u66f4\u52a0\u79ef\u6781\u4e3b\u52a8\u7684\u65b9\u5f0f\uff0c\u5373\u4f7f\u5185\u5b58\u4f7f\u7528\u7387\u8fd8\u672a\u89e6\u53d1swap\u9608\u503c\uff0c\u5f53\u5355\u4e2a\u5c40\u90e8\u4e8b\u52a1\u5927\u5c0f\u8d85\u8fc7\u9608\u503c\u4e4b\u540e\uff0c\u4e5f\u4f1a\u76f4\u63a5\u89e6\u53d1swap\uff0c\u5e76\u4e14\u6027\u80fd\u8fd8\u7b97\u4e0d\u9519\u3002\u4e4b\u6240\u4ee5\u5f15\u5165\u8fd9\u79cd\u7b56\u7565\uff0c\u4e3b\u8981\u539f\u56e0\u662f\uff1a\u51fa\u73b0\u5927\u4e8b\u52a1\u65f6\uff0c\u5927\u6982\u7387\u4f1a\u89e6\u53d1\u5185\u5b58\u4e0d\u8db3\uff0c\u76f4\u63a5\u89e6\u53d1swap\uff0c\u514d\u53bb\u8001\u5e74\u4ee3GC\u7684\u6210\u672cswap\u64cd\u4f5c\u867d\u7136\u4f1a\u6709\u4e00\u5b9a\u7684\u635f\u8017\uff0c\u4f46\u603b\u4f53\u4e0a\u7684\u5ef6\u8fdf\u8fd8\u4e0d\u9519\uff0c\u4f18\u5148\u8003\u8651\u7a33\u5b9a\u602720G Auto Persist With 4G Memory\u5355\u4e2a\u4e8b\u52a1\u5927\u5c0f20G\uff0c\u5f00\u542fswap\u529f\u80fd\uff0c\u5e76\u5c06\u6301\u4e45\u5316\u6a21\u5f0f\u8bbe\u7f6e\u4e3aAUTO\uff0cTask\u8fdb\u7a0b\u5185\u5b58\u8bbe\u7f6e\u4e3a4G(\u65e0\u6cd5\u653e\u4e0b20G\u6570\u636e)\uff0c\u8bc4\u6d4b\u7cfb\u7edf\u7684\u81ea\u52a8\u6301\u4e45\u5316\u80fd\u529bDelay Time: \u6240\u6709\u6570\u636e\u5b8c\u6210\u6392\u5e8f\u65f6\u5ef6\u8fdf49s\uff0c\u6240\u6709\u6570\u636e\u8f93\u51fa\u5230\u5168\u5c40binlog\u6587\u4ef6\u65f6\u5ef6\u8fdf115s
\"\u56fe\u7247\"
Task\u8fdb\u7a0b\u5185\u5b58: \u8001\u5e74\u4ee3\u5c0f\u5e45\u4e0a\u6da8
\"\u56fe\u7247\"
Swap\u65e5\u5fd7\uff1a\u5355\u4e2a\u5c40\u90e8\u4e8b\u52a1\u5927\u5c0f\u8d85\u8fc7\u9608\u503c\uff0c\u76f4\u63a5\u89e6\u53d1\u4e86swap
\"\u56fe\u7247\"
\u603b\u7ed3\u672c\u6587\u57fa\u4e8eTPCC\u3001Sysbench\u548cLarge Transaction3\u4e2a\u573a\u666f\uff0c\u5bf9\u5168\u5c40Binlog\u7684\u6027\u80fd\u548c\u7a33\u5b9a\u6027\u60c5\u51b5\u8fdb\u884c\u4e86\u8be6\u7ec6\u4ecb\u7ecd\uff0c\u7efc\u5408\u6765\u770b\uff1a\u5199\u5165\u541e\u5410\u53ef\u4ee5\u8fbe\u5230500M\/S(30G\/min)\u5de6\u53f3\uff0cEPS\u6307\u6807\u53ef\u4ee5\u8fbe\u5230220W\/S\u5de6\u53f3\uff0c\u4e14\u5185\u5b58\u4f7f\u7528\u7387\u7ef4\u6301\u5728\u8f83\u4f4e\u7684\u6c34\u4f4dTPCC\u573a\u666f\uff0c\u5728150w tpmC\u538b\u529b\u4e0b\uff0c\u5ef6\u8fdf\u65f6\u95f4\u53ef\u4ee5\u63a7\u5236\u57284s\u4ee5\u5185\uff0c\u5927\u90e8\u5206\u65f6\u95f4\u6bb5\u5ef6\u8fdf\u65f6\u95f4\u4fdd\u6301\u57282s\u5de6\u53f3Sysbench\u573a\u666f\uff0c30w QPS\u538b\u529b\u4e0b\uff0c\u5ef6\u8fdf\u65f6\u95f4\u53ef\u4ee5\u7ef4\u6301\u57281s\u4ee5\u5185\uff0c\u66f4\u9ad8\u538b\u529b\u4e0b\u7531\u4e8e\u5df2\u7ecf\u89e6\u8fbe220w\/s\u7684EPS\u80fd\u529b\uff0c\u5ef6\u8fdf\u65f6\u95f4\u5f00\u59cb\u589e\u957f(\u7ee7\u7eed\u63d0\u5347EPS\u7684\u4e0a\u9650\u662f\u5168\u5c40binlog\u540e\u7eed\u7684\u4e00\u4e2a\u91cd\u70b9\u76ee\u6807)Large Transaction\u573a\u666f\uff0c\u4f9d\u6258\u81ea\u52a8swap\u80fd\u529b\uff0c\u4f7f\u7528\u5f88\u5c0f\u7684\u5185\u5b58\u53ef\u4ee5\u7a33\u5b9a\u7684\u540c\u6b65\u8d85\u5927\u4e8b\u52a1\uff0c\u4e14\u80fd\u4fdd\u6301\u8fd8\u4e0d\u9519\u7684\u6027\u80fd(\u7ee7\u7eed\u4f18\u5316swap\u7684\u8bfb\u5199\u80fd\u529b\uff0c\u5ef6\u8fdf\u65f6\u95f4\u8fd8\u6709\u8fdb\u4e00\u6b65\u7684\u964d\u4f4e\u7a7a\u95f4)\u4f18\u5316\u65e0\u6b62\u5883\uff0c\u5982\u679c\u5bf9PolarDB-X\u5145\u6ee1\u5174\u8da3\uff0c\u53ef\u6301\u7eed\u5173\u6ce8\u6211\u4eec\uff0c\u6700\u65b0\u7684\u4f18\u5316\u8fdb\u5c55\u4f1a\u6301\u7eed\u66f4\u65b0\u3002\u672c\u6587\u662f\u5168\u5c40Binlog\u6027\u80fd\u89e3\u8bfb\u7cfb\u5217\u7684\u4e0a\u7bc7\uff0c\u4e0b\u7bc7\u5c06\u4ece\u539f\u7406\u5c42\u9762\u5c55\u5f00\u6df1\u5165\u4ecb\u7ecd\uff0c\u656c\u8bf7\u5173\u6ce8\u3002\u6b22\u8fce\u5173\u6ce8PolarDB-X\u77e5\u4e4e\u673a\u6784\u53f7\uff0c\u9605\u8bfb\u66f4\u591a\u6280\u672f\u597d\u6587\u3002\u539f\u6587\u94fe\u63a5\uff1ahttps:\/\/click.aliyun.com\/m\/10…<\/a>\u672c\u6587\u4e3a\u963f\u91cc\u4e91\u539f\u521b\u5185\u5bb9\uff0c\u672a\u7ecf\u5141\u8bb8\u4e0d\u5f97\u8f6c\u8f7d\u3002<\/p>\n

https:\/\/segmentfault.com\/a\/1190000042737761<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

\u7b80\u4ecb\uff1a\u00a0\u672c\u7bc7\u6765\u4ecb\u7ecd\u4e00\u4e0bPolarDB-X\u5168\u5c40binlog\u5728\u6027\u80fd\u65b9\u9762\u7684\u4e00\u4e9b\u8bbe\u8ba1\u548c\u601d\u8003\uff0c\u5148\u901a\u8fc7\u51e0\u4e2a\u5b9e\u9645\u7684\u6d4b\u8bd5\u6848\u4f8b\u6765 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-10006792","post","type-post","status-publish","format-standard","hentry","category-share"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts\/10006792","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10006792"}],"version-history":[{"count":0,"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts\/10006792\/revisions"}],"wp:attachment":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10006792"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10006792"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10006792"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}