澶у濂斤紝鎴戞槸Skow鍦ㄧ湅杩欑瘒鏂囩珷涔嬪墠锛屼綘鍙互闂棶鑷繁浠€涔堟槸姝婚攣锛烳ysql鏈夊摢浜涢攣锛烳ysql閿佹ā寮忓吋瀹圭煩闃典綘鐭ラ亾鍚楋紵濡備綍瑙ｅ喅姝婚攣闂锛熷鏋滀綘鑳介棴鐫€鐪肩潧鍥炵瓟杩欎簺闂锛岄偅涔堣榛橀粯鐐硅禐绂诲紑馃憤馃徎濡傛灉浣犲浠ヤ笂鐭ヨ瘑鐐硅繕鏈変簺妯＄硦锛岄偅涔堟湰鏂囧皢甯︿綘浠庝竴涓湡瀹炵殑涓氬姟鍦烘櫙鍑哄彂锛屽垎鏋愭閿侀棶棰橈紝甯屾湜杩欑瘒鏂囩珷瀵逛綘鏈夊府鍔╋紝Let'sgo馃え涓氬姟鑳屾櫙鐩墠鎴戜滑鍏徃鏈変袱涓郴缁燂紝绯荤粺A鍜岀郴缁烞銆傜郴缁烝瀛樺偍浜嗗叕鍙告墍鏈変汉鍛樼殑淇℃伅銆傜郴缁烞闇€瑕佸湪涓€澶╃粨鏉熸椂瀹氭湡浠庣郴缁烝鍚屾鏁版嵁浜哄憳锛屽鏋滅郴缁烞涓凡缁忓瓨鍦紝鍒欐洿鏂帮紝濡傛灉涓嶅瓨鍦紝鍒欐彃鍏ャ€傜敱浜庝汉鍛樹俊鎭繃澶氾紝閲囩敤澶氱嚎绋嬬殑鏂瑰紡鍚屾浜哄憳鏁版嵁銆傞獙璇佷唬鐮佹椂锛岎煒℃祴璇曚汉鍛樻劋鎬掑弽搴旓紝sync\_user鏄垜浠悓姝ヤ汉鍛樼殑datasheet鎵撲笉寮€銆傚鏋滃彂鐢熶粈涔堜簨锛屼笉瑕佹儕鎱屻€傚厛鎬繍缁村惂銆傗€滃皬濮愶紝鍒媴蹇冦€備竴瀹氭槸鏁版嵁搴撶郴缁熸湁闂銆傗€濇垜浠唬鐮佺殑寮€鍙戦€犳垚浜嗚繖涓〃鐨勬閿侊紝瀵艰嚧琛ㄦ棤娉曟墦寮€銆備负浠€涔堜細鍑虹幇姝婚攣锛熸帴涓嬫潵锛岃鎴戜滑杩樺師妗堝彂鐜板満銆傛垜浠繕鍘熶竴涓嬪師鏉ョ殑寤鸿〃璇彞锛堝綋鐒舵垜浠笉浼氱粰浣犵湅鐪熷疄鐨勮〃锛塁REATETABLE`sync_user`(`user_id`VARCHAR(32)NOTNULLCOMMENT'userID',`user_name`VARCHAR(32)DEFAULTNULLCOMMENT'username',`login_account`VARCHAR(50)DEFAULTNULLCOMMENT'loginaccount',PRIMARYKEY(`user_id`),KEY`idx_login_account`(`login_account`)浣跨敤BREEENGINE=INNODBDEFAULTCHARSET=utf8mb4COMMENT='UserInformationTable';鐜板湪绯荤粺涓湁寮犱笁鍜屾潕鍥涗袱涓敤鎴疯〃鍑嗗濂戒簡锛屾垜浠湅鐪嬫垜浠殑鏁版嵁闅旂绾у埆锛屾妸鎴戜滑鐨勮嚜鍔ㄦ彁浜ゅ叧鎺夊ソ鎴忓紑濮嬶紒锛侊紒鉁嶏笍鎸夌収涓嬪浘鏉ユā鎷熸垜浠苟鍙戞暟鎹悓姝ョ殑鎯呭喌锛屽惎鍔ㄤ簨鍔?锛屾墽琛屾洿鏂拌鍙?UPDATEsync\_userSETuser\_name="寮犱笁2"wherelogin\_account="zhangsan";鎵撳紑浜嬪姟2锛屾墽琛屾洿鏂拌鍙?UPDATEsync\_userSETuser\_name="lisi2"wherelogin\_account="lisi";鏇存柊鎴愬姛杩斿洖浜嬪姟1锛屾墽琛宨nsert璇彞>INSERTINTOsync\_user(user\_id,user\_name,login\_account)VALUES('3','鐜嬩簲','wangwu');--杩欎釜璇彞琚樆濉烇紝杩斿洖浜嬪姟2锛屾墽琛屾彃鍏ヨ鍙?INSERTINTOsync\_user(user\_id,user\_name,login\_account)VALUES('4','yangliu','yangliu');--鍑虹幇姝婚攣锛屼笂闈簨鍔?鐨刬nsert璇彞鎵ц鎴愬姛灏辨槸鎴戜滑妯℃嫙鐨勫苟鍙戞儏鍐点€傜被浠ｈ〃鎬荤粨鍥惧涓嬸煈囨閿佸垎鏋愰€氳繃灏濊瘯鑾峰彇閿佹椂鍙戠幇鐨勬閿侊紱灏濊瘯閲嶅惎浜嬪姟2鎻愮ず鐨勪簨鍔★紝鎴戜滑鍙互娓呮鍦板緱鍒板畠銆傝繖灏辨槸姝婚攣鎯呭喌銆傛閿佹€庝箞鍔烇紵澶у鑰佸笀鏄繖鏍峰憡璇夋垜浠殑锛氭閿佹槸鎸囧涓繘绋嬪湪杩愯杩囩▼涓簤鎶㈣祫婧愰€犳垚鐨勬閿併€傚悜鍓嶆帹杩涘鑷存閿佺殑鍥涗釜蹇呰鏉′欢浜掓枼锛氫竴绉嶈祫婧愪竴娆″彧鑳借涓€涓繘绋嬩娇鐢紱璇锋眰鍜屼繚鎸佹潯浠讹細褰撲竴涓繘绋嬭璇锋眰璧勬簮闃诲鏃讹紝淇濇寔鑾峰緱鐨勮祫婧愶紱涓嶅墺澶烘潯浠讹細杩涚▼鑾峰緱鐨勮祫婧愬湪鐢ㄥ畬涔嬪墠涓嶈兘寮鸿鍓ュず锛涘惊鐜瓑寰呮潯浠讹細澶氫釜杩涚▼褰㈡垚澶村熬寰幆绛夊緟璧勬簮鍏崇郴锛沷k锛屼粈涔堟槸姝婚攣锛屾槸浠€涔堝鑷存閿佺殑蹇呰鏉′欢鎴戜滑宸茬粡鐭ラ亾浜嗐€傝浜х敓姝婚攣锛屽繀椤诲厛鏈夐攣銆傞偅涔圡ysql鏈夊摢浜涢攣鍛紵Mysql鎸夐攣鏂瑰紡鍖哄垎锛氳褰曢攣銆侀棿闅欓攣銆乶ext-key閿併€佹彃鍏ユ剰鍚戦攣銆傝姹傜殑閿佹帴涓嬫潵姝ｅ紡鍒嗘瀽涓€涓嬩簨鍔?鍜屼簨鍔?鍚勮嚜寰楀埌鐨勬槸浠€涔堥攣lisi,zhangsan),(zhangsan,+鈭?recordlock:鍥犱负login\_account鏄储寮曪紝鎵€浠ヤ細鍦▃hangsan琛屽姞涓€涓狽ext-Key閿侊細Next-Keylock=recordlock+gaplock锛屾墍浠PDATE璇彞鏈?lisi,zhangsan鐨凬ext-Key閿乚鎬荤粨锛氭洿鏂板紶涓夌殑璇彞鑾峰彇Next-Key閿?>(lisi,zhangsan]闂撮殭閿?>(zhangsan,+鈭?Transaction1isinsertingwangwuWangWu'sTime闂撮殭閿侊細鍥犱负wangwu锛坙isi鍜寊hangsan涔嬮棿锛夛紝闇€瑕佽姹傞棿闅欓攣锛坙isi锛寊hangsan锛夋彃鍏ユ剰鍥鹃攣锛圛nsertIntention锛夛細鎻掑叆鎰忓浘閿佹槸鍦ㄦ彃鍏ヤ竴琛岃褰曞墠璁剧疆鐨勯棿闅欓攣锛岃繖涓攣閲婃斁涓€绉嶆彃鍏ユā寮忕殑淇″彿锛屽嵆浜嬪姟A闇€瑕佹彃鍏ユ剰鍚戦攣(lisi,zhangsan)銆傚洜姝わ紝浜嬪姟1鐨刄PDATE璇彞鍜孖NSERT璇彞鎵ц瀹屽悗锛屾寔鏈?lisi,zhangsan)鐨勬槸Next-閿攣锛?zhangsan,+鈭?闂撮殭閿侊紝鎯冲緱鍒?lisi,zhangsan)鎻掑叆鎰忓悜鎺掍粬閿佷簨鍔?鐨勫垎鏋愪篃鍜屼笂闈㈢殑渚嬪瓙涓€鏍凤紝鎴戜滑鐩存帴缁欏嚭绛旀UPDATE璇彞鍜孖NSERT璇彞浜嬪姟2鎵ц瀹屾瘯锛屾寔鏈?-鈭?lisi)鐨凬ext-Key閿侊紝(lisi,zhangsan)鐨凣ap閿侊紝鎯宠幏鍙?lisi,zhangsan)鐨勬彃鍏ユ剰鍚戞帓浠栭攣宸茬粡鍒嗘瀽瀹屾瘯锛岀劧鍚庯紝鎴戜滑闇€瑕佹鏌ヤ簨鍔＄殑鏃ュ織缁撴灉銆傜湡鐩稿嵆灏嗘诞鍑烘按闈€備簨鍔?鏈熸湜寰楀埌(lisi,zhangsan)鐨勬彃鍏ユ剰鍚戦攣锛屼絾鏄繖涓寖鍥寸洰鍓嶈浜嬪姟2鐨?lisi,zhangsan]鐨勯棿闅欓攣鍗犵敤锛岃繖涓や釜閿佷篃鏈夊啿绐侊紝浜嬪姟2鏈熸湜寰楀埌鐨勬槸(lisi,zhangsan)鐨勬彃鍏ユ剰鍚戦攣锛屼絾鏄繖涓寖鍥磋浜嬪姟1鐨?lisi,zhangsan]鐨凬ext-Key閿佸崰鐢ㄤ簡锛岃繖涓や釜閿佸張鍐茬獊浜嗭紝鎵€浠ユ閿佸彂鐢熶簡鍥犱负Innodb鐨勫簳灞傛満鍒讹紝瀹冧細璁╁叾涓竴涓簨鍔℃斁寮冭祫婧愶紝鑰屽彟涓€涓簨鍔′細鎵ц鎴愬姛锛岃繖灏辨槸涓轰粈涔堜綘鏈€鍚庣湅鍒颁簨鍔?鎻掑叆鎴愬姛锛屼絾鏄簨鍔?鎻掑叆鏄剧ず鍙戠幇姝婚攣銆傛€荤粨姝婚攣鐨勫師鍥犲凡缁忓垎鏋愬嚭鏉ヤ簡锛岄偅涔堜互鍚庨亣鍒版閿侊紝鏁翠綋鐨勮В鍐虫€濊矾鏄粈涔堬紵鍦ㄦ閿佽繍缁存ā鎷熷満鏅腑灞曠ずengineinnodb鐘舵€侊紱鏌ョ湅姝婚攣鏃ュ織鎵惧嚭姝婚攣SQLSQL閿佸垎鏋愶紝鍙互鍘诲畼缃戠湅鐪嬶紝鍒嗘瀽姝婚攣鏃ュ織锛堟寔鏈変粈涔堥攣锛岀瓑寰呬粈涔堥攣锛夌啛鎮夐攣妯″紡鍏煎鎬х煩闃碉紝鍏煎鎬х煩闃礗nnoDB瀛樺偍寮曟搸涓殑閿併€傚弬鑰冩枃绔狅細涓佸銆奙ySql 瀹炴垬45璁层€嬫崱铚楃墰鐨勫皬鐢峰銆婃墜鎶婃墜鏁欎綘鍒嗘瀽Mysql姝婚攣闂銆嬫枃鍒版缁撴潫馃濡傛灉鏈枃瀵规偍鏈夊府鍔╋紝璇风偣璧炲澶氬垎浜埌寰俊鍏紬鍙枫€恈odeLiveHouse銆戝叕浼楀彿鍥炲銆嬩俊鎭€濆彲浠ヨ幏寰楀ぇ鍘傞潰璇曢/鎶€鏈枃妗?鐢靛瓙涔︾瓑銆?/p>
