“VIM:NERD Tree”与“MySQL explain”：页面之间的差异

2018年9月18日 (二) 09:16的版本

mysql> explain SELECT COUNT(*) FROM vehicle_prod WHERE fin LIKE '%00000' \G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: vehicle_prod
   partitions: NULL
         type: index
possible_keys: NULL
          key: idx_vehicle_prod_fin
      key_len: 203
          ref: NULL
         rows: 3182812
     filtered: 11.11
        Extra: Using where; Using index
1 row in set, 1 warning (0.00 sec)

其中：

id select_id The SELECT identifier
select_type None The SELECT type
table table_name The table for the output row
partitions partitions The matching partitions
type access_type The join type
possible_keys possible_keys The possible indexes to choose
key key The index actually chosen
key_len key_length The length of the chosen key
ref ref The columns compared to the index
rows rows Estimate of rows to be examined
filtered filtered Percentage of rows filtered by table condition
Extra None Additional information

@@ 第1行： / 第1行： @@
-=操作=
+<pre>
-*<code>:NERDTree</code>打开目录树
+mysql> explain SELECT COUNT(*) FROM vehicle_prod WHERE fin LIKE '%00000' \G
-*{{key press|Ctrl|w|h}} focus到目录
+*************************** 1. row ***************************
-*{{key press|Ctrl|w|l}}  focus到右侧文件
+           id: 1
-*{{key press|o}} 打开关闭文件或者目录
+  select_type: SIMPLE
-*{{key press|t}} 在标签页中打开
+        table: vehicle_prod
-*{{key press|T}} 在后台标签页中打开
+   partitions: NULL
-*{{key press|!}} 执行此文件
+         type: index
-*{{key press|p}} 到上层目录
+possible_keys: NULL
-*{{key press|P}} 到根目录
+          key: idx_vehicle_prod_fin
-*{{key press|K}} 到第一个节点
+      key_len: 203
-*{{key press|J}} 到最后一个节点
+          ref: NULL
-*{{key press|u}} 打开上层目录
+         rows: 3182812
-*{{key press|m}} 显示文件系统菜单（添加、删除、移动操作）
+     filtered: 11.11
-*{{key press|?}} 帮助
+        Extra: Using where; Using index
-*{{key press|q}} 关闭
+row in set, 1 warning (0.00 sec)
-=配置=
+</pre>
-<source lang="bash">
-#~/.vimrc
+其中：
-#启动时自动加载
+*id	select_id	The SELECT identifier
-autocmd vimenter * NERDTree
+*select_type	None	The SELECT type
-</source>
+*table	table_name	The table for the output row
-[[Category:Linux/Unix]]
+*partitions	partitions	The matching partitions
+*type	access_type	The join type
+*possible_keys	possible_keys	The possible indexes to choose
+*key	key	The index actually chosen
+*key_len	key_length	The length of the chosen key
+*ref	ref	The columns compared to the index
+*rows	rows	Estimate of rows to be examined
+*filtered	filtered	Percentage of rows filtered by table condition
+*Extra	None	Additional information
+[[Category:Datebase]]