MySQL: InnoDB 杩樻槸 MyISAM
MyISAM瀛樺偍寮曟搸
聽
聽聽聽聽聽聽 MyISAM鏄?榛樿瀛樺偍寮曟搸銆傚畠鍩轰簬鏇磋€佺殑ISAM浠ｇ爜锛屼絾鏈夊緢澶氭湁鐢ㄧ殑鎵╁睍銆侻yISAM瀛樺偍寮曟搸鐨勪竴浜涚壒寰侊細
路聽聽聽聽聽 鎵€鏈夋暟鎹€煎厛瀛樺偍浣庡瓧鑺傘€傝繖浣垮緱鏁版嵁鏈哄拰鎿嶄綔绯荤粺鍒嗙銆備簩杩涘埗杞讳究鎬х殑鍞竴瑕佹眰鏄満鍣ㄤ娇鐢ㄨˉ鐮侊紙濡傛渶杩?0骞寸殑鏈哄櫒鏈夌殑涓€鏍凤級鍜孖EEE娴偣鏍煎紡锛堝湪涓绘祦鏈哄櫒涓篃瀹屽叏鏄富瀵肩殑锛夈€傚敮涓€涓嶆敮鎸佷簩杩涘埗鍏煎鎬х殑鏈哄櫒鏄祵鍏ュ紡绯荤粺銆傝繖浜涚郴缁熸湁鏃朵娇鐢ㄧ壒娈婄殑澶勭悊鍣ㄣ€?/span>
路聽聽聽聽聽聽聽 鍏堝瓨鍌ㄦ暟鎹綆瀛楄妭骞朵笉涓ラ噸鍦板奖鍝嶉€熷害锛涙暟鎹涓殑瀛楄妭涓€鑸槸鏈仈鍚堢殑锛屼粠涓€涓柟鍚戣鏈仈鍚堢殑瀛楄妭骞朵笉姣斾粠鍙嶅悜璇绘洿鍗犵敤鏇村鐨勮祫婧愩€傛湇鍔″櫒涓婄殑鑾峰彇鍒楀€肩殑浠ｇ爜涓庡叾瀹冧唬鐮佺浉姣斿苟涓嶆樉寰楁椂闂寸揣銆?/p>
路聽聽聽聽聽聽聽聽澶ф枃浠讹紙杈?3浣嶆枃浠堕暱搴︼級鍦ㄦ敮鎸佸ぇ鏂囦欢鐨勬枃浠剁郴缁熷拰鎿嶄綔绯荤粺涓婅鏀寔銆?/p>
路聽聽聽聽聽聽聽聽 褰撴妸鍒犻櫎鍜屾洿鏂板強鎻掑叆娣峰悎鐨勬椂鍊欙紝鍔ㄦ€佸昂瀵哥殑琛屾洿灏戠鐗囥€傝繖瑕侀€氳繃鍚堝苟鐩搁偦琚垹闄ょ殑鍧楋紝浠ュ強鑻ヤ笅涓€涓潡琚垹闄わ紝灏辨墿灞曞埌涓嬩竴鍧楁潵鑷姩瀹屾垚銆?/p>
路聽聽聽聽聽聽聽聽 姣忎釜MyISAM琛ㄦ渶澶х储寮曟暟鏄?4銆?杩欏彲浠ラ€氳繃閲嶆柊缂栬瘧鏉ユ敼鍙樸€傛瘡涓储寮曟渶澶х殑鍒楁暟鏄?6涓€?/p>
路聽聽聽聽聽聽聽聽 鏈€澶х殑閿暱搴︽槸1000瀛楄妭銆傝繖涔熷彲浠ラ€氳繃缂栬瘧鏉ユ敼鍙樸€傚浜庨敭闀垮害瓒呰繃250瀛楄妭鐨勬儏鍐碉紝涓€涓秴杩?024瀛楄妭鐨勭殑閿潡琚敤涓娿€?/p>
路聽聽聽聽聽聽聽聽 BLOB鍜孴EXT鍒楀彲浠ヨ绱㈠紩銆?/p>
路聽聽聽聽聽聽聽聽 NULL鍊艰鍏佽鍦ㄧ储寮曠殑鍒椾腑銆傝繖涓崰姣忎釜閿殑0-1涓瓧鑺傘€?/p>
路聽聽聽聽聽聽聽聽 鎵€鏈夋暟瀛楅敭鍊间互楂樺瓧鑺備负鍏堣瀛樺偍浠ュ厑璁镐竴涓洿楂樺湴绱㈠紩鍘嬬缉銆?/p>
路聽聽聽聽聽聽聽聽褰撹褰曚互鎺掑ソ搴忕殑椤哄簭鎻掑叆锛堝氨鍍忎綘浣跨敤涓€涓狝UTO_INCREMENT鍒椾箣鏃讹級锛岀储寮曟爲琚妶寮€浠ヤ究楂樿妭鐐逛粎鍖呭惈涓€涓敭銆傝繖鏀瑰杽浜嗙储寮曟爲鐨勭┖闂村埄鐢ㄧ巼銆?/p>
路聽聽聽聽聽聽聽聽 姣忚〃涓€涓狝UTO_INCREMEN鍒楃殑鍐呴儴澶勭悊銆侻yISAM涓篒NSERT鍜孶PDATE鎿嶄綔鑷姩鏇存柊杩欎竴 鍒椼€傝繖浣垮緱AUTO_INCREMENT鍒楁洿蹇紙鑷冲皯10%锛夈€傚湪搴忓垪椤剁殑鍊艰鍒犻櫎涔嬪悗灏变笉鑳藉啀鍒╃敤銆傦紙褰揂UTO_INCREMENT鍒楄瀹氫箟涓哄鍒楃储 寮曠殑鏈€鍚庝竴鍒楋紝鍙互鍑虹幇閲嶄娇鐢ㄤ粠搴忓垪椤堕儴鍒犻櫎鐨勫€肩殑鎯呭喌 锛夈€侫UTO_INCREMENT鍊煎彲鐢ˋLTER TABLE鎴?strong style="margin: 0px; padding: 0px;">myisamch鏉ラ噸缃€?/p>
路聽聽聽聽聽聽聽聽 濡傛灉鏁版嵁鏂囦欢涓棿鐨勮〃娌℃湁鑷敱鍧椾簡锛屽湪鍏跺畠绾跨▼浠庤〃璇荤殑鍚屾椂锛屼綘鍙互INSERT鏂拌鍒拌〃涓€傦紙杩欒璁よ瘑涓哄苟鍙戞搷浣?锛夈€傝嚜鐢卞潡鐨勫嚭鐜版槸浣滀负鍒犻櫎琛岀殑缁撴灉锛屾垨鑰呮槸鐢ㄦ瘮褰撳墠鍐呭澶氱殑鏁版嵁瀵瑰姩鎬侀暱搴﹁鏇存柊鐨勭粨鏋溿€傚綋鎵€鏈夎嚜鐢卞潡琚敤瀹岋紙濉弧锛夛紝鏈潵鐨勬彃鍏ュ張鍙樻垚骞跺彂銆?/p>
路聽聽聽聽聽聽聽聽 浣犲彲浠ユ妸鏁版嵁鏂囦欢鍜岀储寮曟枃浠舵斁鍦ㄤ笉鍚岀洰褰曪紝鐢―ATA DIRECTORY鍜孖NDEX DIRECTORY閫夐」CREATE TABLE浠ヨ幏寰楁洿楂樼殑閫熷害锛岃鍙傞槄13.1.5鑺傦紝鈥淐REATE TABLE璇硶鈥?/a>銆?/p>
路聽聽聽聽聽聽聽聽 姣忎釜瀛楃鍒楀彲浠ュ張涓嶅悓鐨勫瓧绗﹂泦銆?/p>
路聽聽聽聽聽聽聽聽 鍦∕yISAM绱㈠紩鏂囦欢閲屽張涓€涓爣蹇楋紝瀹冭〃鏄庤〃鏄惁琚纭叧闂€傚鏋滅敤--myisam-recover閫夐」鍚姩mysqld锛孧yISAM琛ㄥ湪鎵撳紑寰楁椂鍊欒鑷姩妫€鏌ワ紝濡傛灉琚〃琚笉鎭板綋鍦板叧闂紝灏变慨澶嶈〃銆?/p>
路聽聽聽聽聽聽聽聽 濡傛灉浣犵敤--update-state閫夐」杩愯myisamchk锛屽畠鏍囨敞琛ㄤ负宸叉鏌ャ€?strong style="margin: 0px; padding: 0px;">myisamchk --fast鍙鏌ラ偅浜涙病鏈夎繖涓爣蹇楃殑琛ㄣ€?/p>
路聽聽聽聽聽聽聽聽聽myisamchk --analyze涓洪儴鍒嗛敭瀛樺偍缁熻淇℃伅锛屼篃涓烘暣涓敭瀛樺偍缁熻淇℃伅銆?/p>
路聽聽聽聽聽聽聽聽聽myisampack鍙互鎵撳寘BLOB鍜孷ARCHAR鍒椼€?/p>
MyISAM涔熸敮鎸佷笅鍒楃壒寰侊細
路聽聽聽聽聽聽聽聽 鏀寔true VARCHAR绫诲瀷锛沄ARCHAR鍒椾互瀛樺偍鍦?涓瓧鑺備腑鐨勯暱搴︽潵寮€濮嬨€?/p>
路聽聽聽聽聽聽聽聽 鏈塚ARCHAR鐨勮〃鍙互鏈夊浐瀹氭垨鍔ㄦ€佽褰曢暱搴︺€?/p>
路聽聽聽聽聽聽聽聽 VARCHAR鍜孋HAR鍒楀彲浠ュ杈?4KB銆?/p>
路聽聽聽聽聽聽聽聽 涓€涓鎼炰贡鐨勫凡璁＄畻绱㈠紩瀵瑰彲瀵筓NIQUE鏉ヤ娇鐢ㄣ€傝繖鍏佽浣犲湪琛ㄥ唴浠讳綍鍒楃殑鍚堝苟涓婃湁UNIQUE銆傦紙灏界濡傛锛屼綘涓嶈兘鍦ㄤ竴涓猆NIQUE宸茶绠楃储寮曚笂鎼滅储锛夈€?/p>
InnoDB瀛樺偍寮曟搸
InnoDB缁橫ySQL鎻愪緵 浜嗗叿鏈夋彁浜わ紝鍥炴粴鍜屽穿婧冩仮澶嶈兘鍔涚殑浜嬪姟瀹夊叏锛圓CID鍏煎锛夊瓨鍌ㄥ紩鎿庛€侷nnoDB閿佸畾鍦ㄨ绾у苟涓斾篃鍦⊿ELECT璇彞鎻愪緵涓€涓狾racle椋庢牸涓€鑷寸殑闈?閿佸畾璇汇€傝繖浜涚壒鑹插鍔?浜嗗鐢ㄦ埛閮ㄧ讲鍜屾€ц兘銆傛病鏈夊湪InnoDB涓墿澶ч攣瀹氱殑闇€瑕侊紝鍥犱负鍦↖nnoDB涓绾ч攣瀹氶€傚悎闈炲父灏忕殑绌洪棿銆侷nnoDB涔熸敮鎸丗OREIGN KEY寮哄埗銆傚湪SQL鏌ヨ涓紝浣犲彲浠ヨ嚜鐢卞湴灏咺nnoDB绫诲瀷鐨勮〃涓庡叾瀹僊ySQL鐨勮〃鐨勭被鍨嬫贩鍚堣捣鏉ワ紝鐢氳嚦鍦ㄥ悓涓€涓煡璇腑涔熷彲浠ユ贩鍚堛€?InnoDB鏄负澶勭悊宸ㄥぇ鏁版嵁閲忔椂鐨勬渶澶ф€ц兘璁捐銆傚畠鐨凜PU鏁堢巼鍙兘鏄换浣曞叾瀹冨熀浜庣鐩樼殑鍏崇郴鏁版嵁搴撳紩鎿庢墍涓嶈兘鍖规晫鐨勩€?/p>
InnoDB瀛樺偍寮曟搸琚畬鍏ㄤ笌MySQL鏈嶅姟鍣ㄦ暣鍚堬紝InnoDB瀛樺偍寮曟搸涓哄湪涓诲唴瀛樹腑缂撳瓨鏁版嵁鍜岀储寮曡€岀淮鎸佸畠鑷繁鐨勭紦鍐叉睜銆?InnoDB瀛樺偍瀹冪殑琛紗绱㈠紩鍦ㄤ竴涓〃绌洪棿涓紝琛ㄧ┖闂村彲浠ュ寘鍚暟涓枃浠讹紙鎴栧師濮嬬鐩樺垎鍖猴級銆傝繖涓嶮yISAM琛ㄤ笉鍚岋紝姣斿鍦∕yISAM琛ㄤ腑姣忎釜琛ㄨ瀛樺湪 鍒嗙鐨勬枃浠朵腑銆侷nnoDB 琛ㄥ彲浠ユ槸浠讳綍灏哄锛屽嵆浣垮湪鏂囦欢灏哄琚檺鍒朵负2GB鐨勬搷浣滅郴缁熶笂銆?/p>
InnoDB榛樿鍦拌鍖呭惈鍦∕ySQL浜岃繘鍒跺垎鍙戜腑銆俉indows Essentials installer浣縄nnoDB鎴愪负Windows涓奙ySQL鐨?榛樿琛ㄣ€?/p>
InnoDB琚敤鏉ュ湪浼楀闇€瑕侀珮鎬ц兘鐨勫ぇ鍨嬫暟鎹簱绔欑偣涓婁骇鐢熴€傝憲鍚嶇殑Internet鏂伴椈绔欑偣Slashdot.org杩愯鍦?InnoDB涓娿€侻ytrix, Inc.鍦↖nnoDB涓婂瓨鍌ㄨ秴杩?TB鐨勬暟鎹紝杩樻湁涓€浜涘叾瀹冪珯鐐瑰湪InnoDB涓婂鐞嗗钩鍧囨瘡绉?00娆℃彃鍏?鏇存柊鐨勮礋鑽枫€?br style="margin: 0px; padding: 0px;">
InnoDB鍜孧yISAM鐨勫尯鍒?/h2>
鍖哄埆姒傝堪锛?/h2>
MyISAM 鏄疢ySQL涓粯璁ょ殑瀛樺偍寮曟搸锛屼竴鑸潵璇翠笉鏄湁澶浜哄叧蹇冭繖涓笢瑗裤€傚喅瀹氫娇鐢ㄤ粈涔堟牱鐨勫瓨鍌ㄥ紩鎿庢槸涓€涓緢tricky鐨勪簨鎯咃紝浣嗘槸杩樻槸鍊兼垜浠幓鐮旂┒涓€涓嬶紝杩欓噷鐨勬枃绔犲彧鑰冭檻 MyISAM 鍜孖nnoDB杩欎袱涓紝鍥犱负杩欎袱涓槸鏈€甯歌鐨勩€?/p>
涓嬮潰鍏堣鎴戜滑鍥炵瓟涓€浜涢棶棰橈細
- 浣犵殑鏁版嵁搴撴湁澶栭敭鍚楋紵
- 浣犻渶瑕佷簨鍔℃敮鎸佸悧锛?/li>
- 浣犻渶瑕佸叏鏂囩储寮曞悧锛?/li>
- 浣犵粡甯镐娇鐢ㄤ粈涔堟牱鐨勬煡璇㈡ā寮忥紵
- 浣犵殑鏁版嵁鏈夊澶э紵
聽
鎬濊€冧笂闈㈣繖浜涢棶棰樺彲浠ヨ浣犳壘鍒板悎閫傜殑鏂瑰悜锛屼絾閭ｅ苟涓嶆槸缁濆鐨勩€傚鏋滀綘闇€瑕佷簨鍔″鐞嗘垨鏄閿紝閭ｄ箞InnoDB 鍙兘鏄瘮杈冨ソ鐨勬柟寮忋€傚鏋滀綘闇€瑕佸叏鏂囩储寮曪紝閭ｄ箞閫氬父鏉ヨ MyISAM鏄ソ鐨勯€夋嫨锛屽洜涓鸿繖鏄郴缁熷唴寤虹殑锛岀劧鑰岋紝鎴戜滑鍏跺疄骞朵笉浼氱粡甯稿湴鍘绘祴璇曚袱鐧句竾琛岃褰曘€傛墍浠ワ紝灏辩畻鏄參涓€鐐癸紝鎴戜滑鍙互閫氳繃浣跨敤Sphinx浠?InnoDB涓幏寰楀叏鏂囩储寮曘€?/p>
鏁版嵁鐨勫ぇ灏忥紝鏄竴涓奖鍝嶄綘閫夋嫨浠€涔堟牱瀛樺偍寮曟搸鐨勯噸瑕佸洜绱狅紝澶у昂瀵哥殑鏁版嵁闆嗚秼鍚戜簬閫夋嫨InnoDB鏂瑰紡锛屽洜涓哄叾鏀寔浜嬪姟澶勭悊鍜屾晠闅滄仮澶嶃€傛暟鎹簱鐨勫湪灏?鍐冲畾浜嗘晠闅滄仮澶嶇殑鏃堕棿闀跨煭锛孖nnoDB鍙互鍒╃敤浜嬪姟鏃ュ織杩涜鏁版嵁鎭㈠锛岃繖浼氭瘮杈冨揩銆傝€孧yISAM鍙兘浼氶渶瑕佸嚑涓皬鏃剁敋鑷冲嚑澶╂潵骞茶繖浜涗簨锛孖nnoDB 鍙渶瑕佸嚑鍒嗛挓銆?/p>
鎮ㄦ搷浣滄暟鎹簱琛ㄧ殑涔犳儻鍙兘涔熶細鏄竴涓鎬ц兘褰卞搷寰堝ぇ鐨勫洜绱犮€傛瘮濡傦細 COUNT() 鍦?MyISAM 琛ㄤ腑浼氶潪甯稿揩锛岃€屽湪InnoDB 琛ㄤ笅鍙兘浼氬緢鐥涜嫤銆傝€屼富閿煡璇㈠垯鍦↖nnoDB涓嬩細鐩稿綋鐩稿綋鐨勫揩锛屼絾闇€瑕佸皬蹇冪殑鏄鏋滄垜浠殑涓婚敭澶暱浜嗕篃浼氬鑷存€ц兘闂銆傚ぇ鎵圭殑inserts 璇彞鍦∕yISAM涓嬩細蹇竴浜涳紝浣嗘槸updates 鍦↖nnoDB 涓嬩細鏇村揩涓€浜涒€斺€斿挨鍏跺湪骞跺彂閲忓ぇ鐨勬椂鍊欍€?/p>
鎵€浠ワ紝鍒板簳浣犳浣跨敤鍝竴涓憿锛熸牴鎹粡楠屾潵鐪嬶紝濡傛灉鏄竴浜涘皬鍨嬬殑搴旂敤鎴栭」鐩紝閭ｄ箞MyISAM 涔熻浼氭洿閫傚悎銆傚綋鐒讹紝鍦ㄥぇ鍨嬬殑鐜涓嬩娇鐢∕yISAM 涔熶細鏈夊緢澶ф垚鍔熺殑鏃跺€欙紝浣嗗嵈涓嶆€绘槸杩欐牱鐨勩€傚鏋滀綘姝ｅ湪璁″垝浣跨敤涓€涓秴澶ф暟鎹噺鐨勯」鐩紝鑰屼笖闇€瑕佷簨鍔″鐞嗘垨澶栭敭鏀寔锛岄偅涔堜綘鐪熺殑搴旇鐩存帴浣跨敤InnoDB鏂?寮忋€備絾闇€瑕佽浣廔nnoDB 鐨勮〃闇€瑕佹洿澶氱殑鍐呭瓨鍜屽瓨鍌紝杞崲100GB 鐨凪yISAM 琛ㄥ埌InnoDB 琛ㄥ彲鑳戒細璁╀綘鏈夐潪甯稿潖鐨勪綋楠屻€?/p>
鍖哄埆鎬荤粨锛?/h2>
1.InnoDB涓嶆敮鎸丗ULLTEXT绫诲瀷鐨勭储寮曘€?/span>
2.InnoDB 涓笉淇濆瓨琛ㄧ殑鍏蜂綋琛屾暟锛屼篃灏辨槸璇达紝鎵цselect count(*) from table鏃讹紝InnoDB瑕佹壂鎻忎竴閬嶆暣涓〃鏉ヨ绠楁湁澶氬皯琛岋紝浣嗘槸MyISAM鍙绠€鍗曠殑璇诲嚭淇濆瓨濂界殑琛屾暟鍗冲彲銆傛敞鎰忕殑鏄紝褰揷ount(*)璇彞鍖呭惈 where鏉′欢鏃讹紝涓ょ琛ㄧ殑鎿嶄綔鏄竴鏍风殑銆?/span>
3.瀵逛簬AUTO_INCREMENT绫诲瀷鐨勫瓧娈碉紝InnoDB涓繀椤诲寘鍚彧鏈夎瀛楁鐨勭储寮曪紝浣嗘槸鍦∕yISAM琛ㄤ腑锛屽彲浠ュ拰鍏朵粬瀛楁涓€璧峰缓绔嬭仈鍚堢储寮曘€?/span>
4.DELETE FROM table鏃讹紝InnoDB涓嶄細閲嶆柊寤虹珛琛紝鑰屾槸涓€琛屼竴琛岀殑鍒犻櫎銆?/span>
5.LOAD TABLE FROM MASTER鎿嶄綔瀵笽nnoDB鏄笉璧蜂綔鐢ㄧ殑锛岃В鍐虫柟娉曟槸棣栧厛鎶奍nnoDB琛ㄦ敼鎴怣yISAM琛紝瀵煎叆鏁版嵁鍚庡啀鏀规垚InnoDB琛紝浣嗘槸瀵逛簬浣跨敤鐨勯澶栫殑InnoDB鐗规€э紙渚嬪澶栭敭锛夌殑琛ㄤ笉閫傜敤銆?/span>
鍙﹀锛孖nnoDB琛ㄧ殑琛岄攣涔熶笉鏄粷瀵圭殑锛屽鏋滃湪鎵ц涓€涓猄QL璇彞鏃禡ySQL涓嶈兘纭畾瑕佹壂鎻忕殑鑼冨洿锛孖nnoDB琛ㄥ悓鏍蜂細閿佸叏琛紝渚嬪update table set num=1 where name like 鈥?aaa%鈥?/span>
聽
鎻愬崌InnoDB鎬ц兘鐨勬柟娉曪細
MyISAM鍜孖nnoDB瀛樺偍寮曟搸鎬ц兘宸埆骞朵笉鏄緢澶э紝閽堝InnoDB鏉ヨ锛屽奖鍝嶆€ц兘鐨勪富瑕佹槸 innodb_flush_log_at_trx_commit 杩欎釜閫夐」锛屽鏋滆缃负1鐨勮瘽锛岄偅涔堟瘡娆℃彃鍏ユ暟鎹殑鏃跺€欓兘浼氳嚜鍔ㄦ彁浜わ紝瀵艰嚧鎬ц兘鎬ュ墽涓嬮檷锛屽簲璇ユ槸璺熷埛鏂版棩蹇楁湁鍏崇郴锛岃缃负0鏁堢巼鑳藉鐪嬪埌鏄庢樉鎻愬崌锛屽綋鐒讹紝鍚?鏍蜂綘鍙互SQL涓彁浜も€淪ET AUTOCOMMIT = 0鈥濇潵璁剧疆杈惧埌濂界殑鎬ц兘銆傚彟澶栵紝杩樺惉璇撮€氳繃璁剧疆innodb_buffer_pool_size鑳藉鎻愬崌InnoDB鐨勬€ц兘锛屼絾鏄垜娴嬭瘯鍙戠幇娌℃湁鐗瑰埆鏄庢樉 鐨勬彁鍗囥€?br style="margin: 0px; padding: 0px;">鍩烘湰涓婃垜浠彲浠ヨ€冭檻浣跨敤InnoDB鏉ユ浛浠ｆ垜浠殑MyISAM寮曟搸浜嗭紝鍥犱负InnoDB鑷韩寰堝鑹ソ鐨勭壒鐐癸紝姣斿浜嬪姟鏀寔銆佸瓨鍌?杩囩▼銆佽鍥俱€佽绾ч攣瀹氱瓑绛夛紝鍦ㄥ苟鍙戝緢澶氱殑鎯呭喌涓嬶紝鐩镐俊InnoDB鐨勮〃鐜拌偗瀹氳姣擬yISAM寮哄緢澶氾紝褰撶劧锛岀浉搴旂殑鍦╩y.cnf涓殑閰嶇疆涔熸槸姣旇緝鍏抽敭 鐨勶紝鑹ソ鐨勯厤缃紝鑳藉鏈夋晥鐨勫姞閫熶綘鐨勫簲鐢ㄣ€?br style="margin: 0px; padding: 0px;">浠讳綍涓€绉嶈〃閮戒笉鏄竾鑳界殑锛屽彧鐢ㄦ伆褰撶殑閽堝涓氬姟绫诲瀷鏉ラ€夋嫨鍚堥€傜殑琛ㄧ被鍨嬶紝鎵嶈兘鏈€澶х殑鍙戞尌MySQL鐨勬€ц兘浼樺娍銆?/div>