儲存引擎
檢視：
show table status like `bigcourse`;
結果：
+-----------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------+----------+--------------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +-----------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------+----------+--------------------+---------+ | bigcourse | InnoDB | 10 | Dynamic | 2 | 8192 | 16384 | 0 | 0 | 0 | 43 | 2018-06-30 13:46:32 | 2018-07-02 19:32:05 | NULL | utf8_bin | NULL | row_format=DYNAMIC | | +-----------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------+----------+--------------------+---------+ 1 row in set
欄位含義:
Row_format:行的格式。
Data_free:表示已分配但目前沒有使用的空間。這部分空間包括了之前刪除的行，以及後續可以被INSERT利用到的空間。
MyISAM：不支援事務和行級鎖，崩潰後無法安全恢復。
選擇哪種搜尋引擎
mysql中只有MyISAM支援地理空間搜尋。