瀹归檲鏃э紝闅忕潃鏃堕棿鎺ㄧЩ鎶?鏈?彂灞曞彉鍖栬?屽彉寰椾笉閫傜敤銆備负浜嗛槻姝㈣?瀵兼柊鎵嬶紝鐗规湰鐫?涓庢椂淇辫繘鐨勭簿绁炲啓鍑烘?鏂囷紝缁濋潪瀵瑰師鏂囦綔鑰呯殑涓嶅皧閲嶃??/p>
1.浣跨敤MyISAM鑰屼笉鏄疘nnoDB
瀹屽叏閿欒?锛屽弽椹崇悊鐢憋細
棣栧厛鍘熸枃璇碝yISAM鏄?粯璁や娇鐢ㄧ殑锛岃?屽疄闄呬笂鍒颁簡MySQL 5.5.x锛孖nnoDB宸茬粡鎴愪负浜嗛粯璁ょ殑琛ㄥ紩鎿庛??br style="margin: 0px; padding: 0px;">
鍙﹀?锛岀畝鍗曠殑浣跨敤InnoDB涓嶆槸瑙ｅ喅鎵?鏈夐棶棰樼殑鏂规硶锛岀洸鐩?殑浣跨敤鐢氳嚦浼氫娇搴旂敤鎬ц兘涓嬮檷10%涔冭嚦40%銆?br style="margin: 0px; padding: 0px;">
鏈?浣虫柟娉曡繕鏄?拡瀵瑰叿浣撲笟鍔″叿浣撳?鐞嗭紝渚嬪?璁哄潧涓?増鍧楄〃锛屾柊闂诲垎绫昏〃锛屽悇绉嶇爜琛ㄧ瓑闀挎椂闂翠笉鎿嶄綔鐨勮〃锛岃繕鏄??鐢ㄦ?ц兘浼樺紓鐨凪yISAM寮曟搸銆?br style="margin: 0px; padding: 0px;">鑰岄渶瑕佺敤鍒颁簨鍔″?鐞嗙殑渚嬪?鐢ㄦ埛銆佽处鐩??佹祦姘寸瓑涓ユ牸瑕佹眰鏁版嵁瀹屾暣鎬у拰鏃跺簭鎬х殑锛屽垯闇?瑕佺敤InnoDB寮曟搸锛屽苟涓斿簲鐢ㄤ篃瑕佺敤濂戒簨鍔″?鐞嗘満鍒躲?傚綋鐒讹紝浜嬪姟澶勭悊蹇呯劧瑕佸甫鏉ュぇ閲忕殑鎬ц兘鎹熻?楋紝浣嗘槸杩欏湪绠?鍗曢珮骞跺彂搴旂敤涓婃槸蹇呴』鐨勩??br style="margin: 0px; padding: 0px;">
鏈?鍚庯紝澶栭敭绾︽潫鍦ㄥ叕鍏眞eb浜掕仈缃戝簲鐢ㄤ笂涓?鑸?槸涓嶇敤鐨勶紝鍥犱负浠栦細涓ラ噸褰卞搷鎬ц兘銆傛暟鎹?畬鏁存?ц繕鏄?潬绋嬪簭鍛樻垨鑰呭簲鐢ㄦ灦鏋勬湰韬?殑鍋ュ．鏉ョ淮鎶ゃ?傝?屾?瑙勭殑绗?笁鑼冨紡鍙?槸鍦ㄤ紒涓氬唴閮∕IS绯荤粺鍜?2306杩欑?缃戠珯涓婁娇鐢ㄣ??br style="margin: 0px; padding: 0px;">
2.浣跨敤PHP鐨刴ysql鏂规硶
涓嶅畬鍏ㄩ敊锛屼絾瑕侀厡鎯呴?夌敤锛?br style="margin: 0px; padding: 0px;">mysqli鍥虹劧濂斤紝浣嗘槸涓嶆槸鎵?鏈夌殑鏈嶅姟鍣ㄩ兘涓篜HP缂栬瘧浜唌ysqli鐨勬敮鎸併??br style="margin: 0px; padding: 0px;">褰撲綘鐨勫簲鐢ㄥ?鏋滄槸鑳界‘瀹氬彧鐢ㄨ嚜宸遍儴缃茬殑鏈嶅姟鍣?紝鑰屽簲鐢ㄤ篃鏄?畬鍏ㄨ嚜宸卞紑鍙戯紝鍒檓ysqli鏄?渶濂界殑閫夋嫨銆?br style="margin: 0px; padding: 0px;">浣嗘槸涓?鏃︿綘鐨勫簲鐢ㄦ湁鍙?兘閮ㄧ讲鍦ㄨ櫄鎷熶富鏈烘垨鑰呯敱鍏朵粬浜洪儴缃诧紙渚嬪?鍒嗗竷寮忛」鐩?級锛岃繕鏄??佽?佸疄瀹炰娇鐢╩ysql鍑芥暟闆嗗惂锛屽ソ濂藉皝瑁呬竴涓嬫垨鑰呬娇鐢ㄦ垚鐔熸?鏋舵潨缁漵ql娉ㄥ叆銆?br style="margin: 0px; padding: 0px;">
3.涓嶈繃婊ょ敤鎴疯緭鍏?/span>
杩欎竴鐐逛笉鐢ㄨ?浜嗭紝瑕佷箞MagicQuote锛岃?涔堥?夌敤鎴愮啛妗嗘灦銆俿ql娉ㄥ叆鑰佽瘽棰樹簡銆?br style="margin: 0px; padding: 0px;">
4.涓嶄娇鐢║TF-8
澶ч儴鍒嗘儏鍐典笅瀵癸紝浣嗕篃瑕佽?鐪熻?冭檻锛?br style="margin: 0px; padding: 0px;">瑕佺煡閬擄紝涓?涓猆TF-8瀛楃?鍗?涓?瓧鑺傦紝鎵?浠ユ瘮GBK绛夊叾浠栫紪鐮佺殑鏂囦欢澶?3%銆傛崲鍙ヨ瘽璇达紝鐩稿悓鐨勭綉椤电敤UTF-8缂栫爜濡傛灉鏄?00KB锛岄偅涔堟崲鎴怗BK缂栫爜鍒欏彧鏈?6KB銆傛墍浠ュ嵆渚夸綘鐨凱HP纭?畾瑕佺敤UTF-8锛岄偅涔堝墠绔?〉闈?篃瑕佹牴鎹?儏鍐甸?夋嫨闇?瑕佺殑缂栫爜銆備絾鏄?紝濡傛灉PHP鐢║TF-8锛屽墠绔?ā鐗堟槸GBK锛屽啀鍔犱笂妯＄増寮曟搸涓嶅己澶э紝閭ｄ箞杞?爜宸ヤ綔澶熶綘鍙楃殑銆傛墍浠ュ敖鍙?兘鐨勯?夌敤鑷?繁闇?瑕佺殑缂栫爜锛岃?屼笉鏄?畝鍗曠殑閫夋嫨UTF-8浜嗕簨銆?br style="margin: 0px; padding: 0px;">鏈?鍚庡暟鍡︿竴鍙ワ細UTF-8涓嬶細strlen("鎴?)=3锛岃?孏BK涓嬶細strlen("鎴?)=2
5.璇ョ敤SQL鐨勫湴鏂逛娇鐢≒HP
鍚屾牱閰屾儏鑰冭檻锛?br style="margin: 0px; padding: 0px;">渚嬪?锛屾湁浜涗汉涔犳儻鍦ㄥ缓琛ㄦ椂锛岄粯璁ゅ?煎～鍐機URRENT_TIMESTAMP锛岀敤鏉ヨ揪鍒版敞鍐屾椂闂淬?佸彂甯栨椂闂寸殑鏁堟灉銆?鎴栬?呭湪鏃堕棿鍒ゆ柇鐨凷QL璇?彞涓?紝鍐欑被浼糞ELECT x FROM tab1 WHERE regdate < UNIX_TIMESTAMP()銆傞偅涔堟垜鍙?兘璇达紝浣犱负绯荤粺鍩嬩笅浜嗗緢闅愯斀鐨凚UG銆傚洜涓烘暟鎹?簱鍜屽簲鐢ㄥ線寰?涓嶅湪鍚屼竴鍙版満鍣ㄤ笂锛屾椂闂村緢瀹规槗鍑虹幇鍋忓樊銆傚綋浣犱竴濂楀簲鐢ㄧ殑鏃堕棿鍙傜収涓嶅噯纭?椂锛屽氨浼氬嚭鐜板緢澶х殑闂??銆?br style="margin: 0px; padding: 0px;">姝ｇ‘鍋氭硶鏄?細涓嶈?浣跨敤MySQL鐨勪换浣曟椂闂村嚱鏁帮紝鑰屾槸鍦ㄥ簲鐢ㄩ噷璁＄畻鏃堕棿銆傚?鏋滄槸鍒嗗竷寮忓簲鐢?紝涓?瀹氳?鏈夋椂闂存湇鍔″櫒鏉ョ粺涓?绠＄悊鏃堕棿銆?br style="margin: 0px; padding: 0px;">鑰屾枃涓??鐨勪竴浜汳ySQL鏁板?鍑芥暟 锛屼篃鏄??鎱庣敤銆傚洜涓哄湪澶у瀷搴旂敤涓?紝鏁版嵁搴撶殑璐熸媴寰?寰?鏄?渶澶х殑锛岃?屽?鏉傜殑WHERE璇?彞鍙堟槸閫犳垚鎱㈡煡璇㈢殑鍏冨嚩銆傛墍浠ワ紝瑕佹妸璁＄畻灏藉彲鑳界殑鏀惧湪寤変环鐨勩?佷笉褰卞搷鍏ㄥ眬绋冲畾鐨勫簲鐢ㄦ湇鍔″櫒涓婏紝鑰屼笉鏄?牳蹇冩暟鎹?簱涓娿??br style="margin: 0px; padding: 0px;">
6.涓嶄紭鍖栨煡璇?/span>
杩欑偣涔熶笉鐢ㄨ?浜嗭紝澶у瀷搴旂敤涓婄敋鑷充笉鍏佽?浣跨敤鍚勭?JOIN锛屽摢鎬曠敓鍐欎袱鏉℃煡璇?紝鏌ュ洖鏉ュ湪鐢≒HP鍚堝苟鏁版嵁銆?br style="margin: 0px; padding: 0px;">
7.浣跨敤閿欒?鐨勬暟鎹?被鍨?/span>
INT锛孴inyINT锛孷ARCHAR锛孋HAR锛孴EXT杩欎簺瀛楁?绫诲瀷鐨勫悎鐞嗛?夌敤鏃犲彲鍘氶潪銆?br style="margin: 0px; padding: 0px;">鑰孌ate銆丏ateTime銆乀IMESTAMP杩欎笁绉嶇被鍨嬶紝鍦ㄥぇ鍨嬪簲鐢ㄤ腑鏄?粷瀵逛笉鍙?互浣跨敤鐨勶紝鑰屾槸瑕佺敤INT(10) UNSIGNED浠ｆ浛銆?br style="margin: 0px; padding: 0px;">涓?涓?槸鎬ц兘锛屽彟澶栧氨鏄?簲鐢ㄤ腑灏ゅ叾鏄疨HP瀵筓NIX_TIMESTAMP鏃堕棿鎴崇殑杞?寲瀹炲湪澶?柟渚夸簡銆傜敤Date瑕佽緭鍑哄悇绉嶆椂闂存牸寮忓弽鑰岄夯鐑︺??br style="margin: 0px; padding: 0px;">
8.鍦⊿ELECT鏌ヨ?涓?娇鐢?
鍏卞媺
9.绱㈠紩涓嶈冻鎴栬?呰繃搴︾储寮?/span>
绱㈠紩鏄?繀椤荤殑锛屼絾鏄??鏋滅储寮曢兘瑙ｅ喅涓嶄簡鐨勬煡璇?紝鑰冭檻memcache鎴栬?卬osql瑙ｅ喅鏂规?鍚с??br style="margin: 0px; padding: 0px;">
10.涓嶅?浠?/span>
杩欐潯鏄?綔鑰呭噾鏁颁箞锛?br style="margin: 0px; padding: 0px;">
11.鍙﹀?锛氫笉鑰冭檻鍏朵粬鏁版嵁搴?/span>
杩欐潯鐩稿綋姝ｇ‘銆傚簲鐢ㄤ腑涓嶄粎瑕侀拡瀵瑰簲鐢ㄩ?夋嫨鍏朵粬鏁版嵁搴擄紝鐢氳嚦杩樿?閽堝?鍏蜂綋鐨勪笟鍔＄被鍨嬶紝鍦ㄥ悓涓?濂楀簲鐢ㄤ腑骞惰?浣跨敤澶氱?鏁版嵁搴撱?傚摢鎬曚笉鏄?暟鎹?簱锛岃?屾槸鍏朵粬鍚勭?缂撳瓨銆佸唴瀛樺瓨鍌ㄧ瓑瑙ｅ喅鏂规?