“FreeBSD:查看内存”与“MySQL explain”：页面之间的差异

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

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

@@ 第1行： / 第1行： @@
 <pre>
-root@riguz:~ # vmstat
+mysql> explain SELECT COUNT(*) FROM vehicle_prod WHERE fin LIKE '%00000';
-procs  memory       page                    disks     faults         cpu
++----+-------------+--------------+------------+-------+---------------+----------------------+---------+------+---------+----------+--------------------------+
-r b w  avm   fre   flt  re  pi  po    fr   sr vt0 cd0   in    sy    cs us sy id
+| id | select_type | table        | partitions | type  | possible_keys | key                  | key_len | ref  | rows    | filtered | Extra                    |
-0 0 1.1G  127M    28   0   0   0    34   30   0   0    3   116    78  0  0 100
++----+-------------+--------------+------------+-------+---------------+----------------------+---------+------+---------+----------+--------------------------+
+|  1 | SIMPLE      | vehicle_prod | NULL       | index | NULL          | idx_vehicle_prod_fin | 203     | NULL | 3182812 |    11.11 | Using where; Using index |
++----+-------------+--------------+------------+-------+---------------+----------------------+---------+------+---------+----------+--------------------------+
+row in set, 1 warning (0.00 sec)
 </pre>
-[[Category:Linux/Unix]]
+[[Category:Datebase]]