| 澶辨晥閾炬帴澶勭悊 |
|
MYSQL鎵ц璁″垝 PDF 涓嬭澆
鏈珯鏁寸悊涓嬭澆錛?/strong>
閾炬帴錛?a target="_blank">https://pan.baidu.com/s/1g4oDonLRbhmSdoWQmxIo3A
鎻愬彇鐮侊細(xì)764z
鐩稿叧鎴浘錛?/strong>
涓昏鍐呭錛?/strong>
2 rows in set (0.00 sec)
鎵ц璁″垝鐨処D 1.
id鐩稿悓錛屾墽琛岄『搴忕敱涓婅嚦涓?/div>
id涓嶅悓錛屽鏋滄槸瀛愭煡璇紝id鐨勫簭鍙蜂細(xì)閫掑錛宨d鐨勫€艱秺澶т紭鍏堢駭瓚婇珮錛岃秺鍏堣鎵ц
鎵ц璁″垝鐨剆elect_type 2.
鏌ヨ鐨勭被鍨嬶紝涓昏鏄敤浜庡尯鍒嗘櫘閫氭煡璇€佽仈鍚堟煡璇€佸瓙鏌ヨ絳夈€?/div>
SIMPLE錛氱畝鍗曠殑 select 鏌ヨ錛屾煡璇腑涓嶅寘鍚瓙鏌ヨ鎴栬€?union
PRIMARY錛氭煡璇腑鍖呭惈瀛愰儴鍒嗭紝鏈€澶栧眰鏌ヨ鍒欒鏍囪涓?primary
SUBQUERY/MATERIALIZED錛歋UBQUERY 琛ㄧず鍦?select 鎴?where 鍒楄〃涓寘鍚簡瀛愭煡璇紝MATERIALIZED錛氳〃紺?where 鍚庨潰 in 鏉?/div>
浠剁殑瀛愭煡璇?/div>
UNION錛氳〃紺?union 涓殑絎簩涓垨鍚庨潰鐨?select 璇彞
UNION RESULT錛歶nion 鐨勭粨鏋?/div>
瀵逛簬 UNION 鍜?UNION RESULT 鍙互閫氳繃涓嬮潰鐨勪緥瀛愬睍鐜幫細(xì)
EXPLAIN
SELECT * FROM users WHERE id IN(1, 2)
UNION
SELECT * FROM users WHERE id IN(3, 4);
鎵ц璁″垝鐨則able 3.
鏌ヨ娑夊強鍒扮殑琛ㄣ€?/div>
鐩存帴鏄劇ず琛ㄥ悕鎴栬€呰〃鐨勫埆鍚?/div>
<unionM,N> 鐢?ID 涓?M錛孨 鏌ヨ union 浜х敓鐨勭粨鏋?/div>
<subqueryN> 鐢?ID 涓?N 鏌ヨ浜х敓鐨勭粨鏋?/div>
鎵ц璁″垝鐨則ype 4.
璁塊棶綾誨瀷錛孲QL 鏌ヨ浼樺寲涓竴涓緢閲嶈鐨勬寚鏍囷紝緇撴灉鍊間粠濂藉埌鍧忎緷嬈℃槸錛歴ystem > const > eq_ref > ref > range > index > ALL
system錛氱郴緇熻〃錛屽皯閲忔暟鎹紝寰€寰€涓嶉渶瑕佽繘琛岀鐩業(yè)O
const錛氬父閲忚繛鎺?/div>
eq_ref錛氫富閿儲寮曪紙primary key錛夋垨鑰呴潪絀哄敮涓€绱㈠紩錛坲nique not null錛夌瓑鍊兼壂鎻?/div>
ref錛氶潪涓婚敭闈炲敮涓€绱㈠紩絳夊€兼壂鎻?/div>
range錛氳寖鍥存壂鎻?/div>
index錛氱儲寮曟爲(wèi)鎵弿
ALL錛氬叏琛ㄦ壂鎻忥紙full table scan錛?/div>
涓嬮潰閫氳繃涓句緥璇存槑銆?/div>
system
explain select * from mysql.time_zone;
涓婁緥涓紝浠庣郴緇熷簱 MySQL 鐨勭郴緇熻〃 time_zone 閲屾煡璇㈡暟鎹紝璁塊棶綾誨瀷涓?system錛岃繖浜涙暟鎹凡緇忓姞杞藉埌鍐呭瓨閲岋紝涓嶉渶瑕佽繘
琛岀鐩?IO錛岃繖綾繪壂鎻忔槸閫熷害鏈€蹇殑銆?/div>
MYSQL鎵ц璁″垝
2020騫?1鏈?6鏃?/div>
14:15
鍒嗗尯 MYSQL鎵ц璁″垝 鐨勭 1 欏?nbsp;
explain select * from (select * from user where id=1) tmp;
鍐嶄婦涓€涓緥瀛愶紝鍐呭眰宓屽錛坈onst錛夎繑鍥炰簡涓€涓復(fù)鏃惰〃錛屽灞傚祵濂椾粠涓存椂琛ㄦ煡璇紝鍏舵壂鎻忕被鍨嬩篃鏄?system錛屼篃涓嶉渶瑕佽蛋紓佺洏
IO錛岄€熷害瓚呭揩銆?br />
|
| Java1234瀹樻柟緹?5錛?/td> | 
|
| Java1234瀹樻柟緹?5錛?/td> | 838462530 |
鑻忓叕緗戝畨澶?32061202001004鍙?/p>
