一般情況下，mysql會默認(rèn)提供多種存儲引擎,可以通過下面的查看:
1）查看mysql是否安裝了innodb插件。
通過下面的命令結(jié)果可知，已經(jīng)安裝了innodb插件。
|
1
2
3
4
5
6
7
8
9
10
11
12
13 |
mysql> show plugins; +------------+--------+----------------+---------+---------+ | Name | Status | Type | Library | License | +------------+--------+----------------+---------+---------+ | binlog | ACTIVE | STORAGE ENGINE | NULL | GPL | | partition | ACTIVE | STORAGE ENGINE | NULL | GPL | | CSV | ACTIVE | STORAGE ENGINE | NULL | GPL | | MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL | | InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL | | MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL | | MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL | +------------+--------+----------------+---------+---------+ 7 rows in set (0.00 sec) |
----------------------------------------------------------------------
如果發(fā)現(xiàn)沒有安裝innodb插件,可以執(zhí)行下面語句進(jìn)行安裝：
mysql> install plugin innodb soname 'ha_innodb.so';
----------------------------------------------------------------------
2）查看mysql現(xiàn)在已提供什么存儲引擎:
|
1
2
3
4
5
6
7
8
9
10
11 |
mysql> show engines; +------------+---------+------------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +------------+---------+------------------------------------------------------------+--------------+------+------------+ | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | CSV | YES | CSV storage engine | NO | NO | NO | | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO | | InnoDB | YES | Supports transactions, row-level locking, and foreign keys | YES | YES | YES | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | +------------+---------+------------------------------------------------------------+--------------+------+------------+ 5 rows in set (0.00 sec) |
3）查看mysql當(dāng)前默認(rèn)的存儲引擎:
|
1
2
3
4
5
6
7 |
mysql> show variables like '%storage_engine%'; +----------------+--------+ | Variable_name | Value | +----------------+--------+ | storage_engine | MyISAM | +----------------+--------+ 1 row in set (0.00 sec) |
4）看某個表用了什么引擎(在顯示結(jié)果里參數(shù)engine后面的就表示該表當(dāng)前用的存儲引擎):
mysql> show create table 表名;
|
1
2
3
4
5
6
7
8
9
10
11
12 |
mysql> show create table wx_share_log; +--------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +--------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | wx_share_log | CREATE TABLE `wx_share_log` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '微信分享日志自增ID', `reference_id` int(11) NOT NULL COMMENT '推薦的經(jīng)紀(jì)人id', `create_time` datetime NOT NULL COMMENT '創(chuàng)建時間', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 | +--------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) |
，我們將會及時處理。 |  2015年全國職稱計算機考試教材（2007模.. 定價：￥225 優(yōu)惠價：￥213 更多書籍 |
 | 全國職稱計算機考試速成過關(guān)系列套裝:W .. 定價：￥133 優(yōu)惠價：￥133.0 更多書籍 |