MYSQL查看及修改表使用的存儲引擎
正確的方法:
show table status from db_name where name='table_name';
+------+--------+---------+------------+------+----------------+-------------+-----------------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length |
+---------+------------+------+----------------+-------------+-----------------+--------------+
| t | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 |
+------+--------+---------+------------+------+----------------+-------------+-----------------+
www.2cto.com
不正確的方法:
show create table table_name;
+-------+-----------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+-----------------------------------------------------------------------------------------+
| t | CREATE TABLE `t` (
`vc` varchar(1) DEFAULT NULL,
`c` char(1) DEFAULT NULL,
KEY `c` (`c`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+------------------------------------------------------------------------------------------+
如果mysqld沒有啟動對應的引擎如這裡InnoDB,那麼會使用默認的MYISAM引擎,所以不准確。
修改: www.2cto.com
alter table table_name engine=innodb;
alter table table_name engine=myisam;