在做innodb测试时发现没有innodb引擎安装如下：

mysql> show variables like 'plugin_dir'; +---------------+-----------------------------------+ | Variable_name | Value                             | +---------------+-----------------------------------+ | plugin_dir    | /usr/local/mysql/lib/mysql/plugin | +---------------+-----------------------------------+

 

mysql> install plugin innodb soname 'ha_innodb.so';mysql> show engines; +------------+---------+------------------------------------------------------------+--------------+------+------------+ | Engine     | Support | Comment                                                    | Transactions | XA   | Savepoints | +------------+---------+------------------------------------------------------------+--------------+------+------------+ | CSV        | YES     | CSV storage engine                                         | 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         | | MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance     | NO           | NO   | NO         | | MRG_MYISAM | YES     | Collection of identical MyISAM tables                      | NO           | NO   | NO         | +------------+---------+------------------------------------------------------------+--------------+------+------------+

结束！！