鏁版嵁搴撳懡鍚嶈鑼
1. 鎵鏈夋暟鎹簱瀵硅薄鍚嶇О蹇呴』浣跨敤灏忓啓瀛楁瘝骞剁敤涓嬪垝绾垮垎鍓
http://dev.mysql.com/doc/refman/5.7/en/keywords.html
涓存椂琛ㄥ繀椤讳互tmp涓哄墠缂骞朵互鏃ユ湡涓哄悗缂
澶囦唤搴擄紝澶囦唤琛ㄥ繀椤绘瘮bak涓哄墠缂骞朵互鏃ユ湡涓哄悗缂
鎵鏈夊偍瀛樼浉鍚屾暟鎹殑鍒楀悕鍜屽垪绫诲瀷蹇呴』涓鑷淬
瀹藉害涓嶈兘瓒呰繃4096
– 鍗曡〃淇濇寔500涓 鍙互鐢ㄥ巻鍙叉暟鎹綊妗ｏ紝鍒嗗簱鍒嗚〃鏉ユ帶鍒舵暟鎹噺澶у皬
– 寤鸿閲囩敤鐗╃悊鍒嗚〃鐨勬柟寮忕鐞嗗ぇ鏁版嵁
– 灏介噺鍋氬埌鍐风儹鏁版嵁鍒嗙锛屽噺灏忚〃鐨勫搴
+ 鍑忓皯纾佺洏IO锛屼繚璇佺儹鏁版嵁鐨勫唴瀛樼紦瀛樺懡涓巼
+ 鍒╃敤鏇存湁鏁堢殑缂撳瓨锛岄伩鍏嶈鍏ユ棤鐢ㄧ殑鍐锋暟鎹
– 绂佹鍦ㄨ〃涓缓绔嬮鐣欏瓧娈
– 绂佹鍦ㄦ暟鎹簱涓瓨鍌ㄥ浘鐗囷紝鏂囦欢绛変簩杩涘埗鏁版嵁
– 绂佹鍦ㄧ嚎涓婂仛鏁版嵁搴撳帇鍔涙祴璇
鏁版嵁搴撶储寮曡璁¤鑼
– 鍗曡〃涓嶈瓒呰繃5涓
– 姣忎釜Innodb琛ㄥ繀椤昏鏈変竴涓富閿
– where 浠庡彞 鍖呭惈order by group by distinct
– 澶氳〃 join鍏宠仈鍒
– 鑱斿悎绱㈠紩 浠庡乏鍒板彸 瑕嗙洊绱㈠紩 閬垮厤鍥炶〃
– 澶栭敭浼氬奖鍝嶅啓鎿嶄綔鎬ц兘
鏁版嵁搴撳瓧娈佃璁¤鑼
SQL寮鍙戣鑼
瓒呰繃100涓囪鐨勬壒閲忓啓鎿嶄綔锛岃鍒嗘壒澶氭杩涜鎿嶄綔 澶ф壒閲忔搷浣滃彲鑳戒細閫犳垚涓ラ噸鐨勪富浠庡欢杩
瀵逛簬杈炬爣浣跨敤pt-online-schema-change淇敼琛ㄧ粨鏋
鍙戣〃鍥炲