开启InnoDB引擎



[root@djipidb01-dr mysqldata]# /etc/init.d/mysqld start
MySQL Daemon failed to start.

150415 10:38:25 mysqld_safe Starting mysqld daemon with databases from /mysqldata
150415 10:38:25  InnoDB: Initializing buffer pool, size = 8.0M
150415 10:38:25  InnoDB: Completed initialization of buffer pool
150415 10:38:25  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
150415 10:38:25 [ERROR] Plugin 'InnoDB' init function returned error.
150415 10:38:25 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150415 10:38:25 [ERROR] Unknown/unsupported table type: INNODB
150415 10:38:25 [ERROR] Aborting

查看：have_innodb   为    NO 

mysql> SHOW variables like "have_%";
+-------------------------+----------+
| Variable_name           | Value    |
+-------------------------+----------+
| have_community_features | YES      |
| have_compress           | YES      |
| have_crypt              | YES      |
| have_csv                | YES      |
| have_dynamic_loading    | YES      |
| have_geometry           | YES      |
| have_innodb             | NO       |
| have_ndbcluster         | NO       |
| have_openssl            | DISABLED |
| have_partitioning       | YES      |
| have_query_cache        | YES      |
| have_rtree_keys         | YES      |
| have_ssl                | DISABLED |
| have_symlink            | DISABLED |
+-------------------------+----------+
14 rows in set (0.00 sec)

安装innodb

mysql> INSTALL PLUGIN InnoDB SONAME 'ha_innodb_plugin.so';
ERROR 1123 (HY000): Can't initialize function 'InnoDB'; Plugin initialization function failed.

解决：

把ibdata1,ib_datafile0,ib_datafile1重命名，让系统重新生成数据文件和两个日志文件；







修改 my.cnf

default-storage-engine=INNODB