让mysql支持innodb

最新推荐文章于 2021-03-17 01:07:00 发布

myth815

最新推荐文章于 2021-03-17 01:07:00 发布

阅读量380

点赞数

分类专栏： MySQL数据库文章标签： mysql transactions csv locking performance 数据库

MySQL数据库专栏收录该内容

3 篇文章

订阅专栏

用源码包安装mysql 5.1.34 发现show engines;里没有innodb

cp /data/mysql/share/mysql/my-innodb-heavy-4G.cnf 到/etc/my.cnf

删除mysql数据目录里的删除ibdata1、ib_logfile1、 ib_logfile0 等文件，然后，重启mysql

每一次会出错，在重启一次就OK了

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)

让mysql默认存储引擎为Innodb

修改/etc/my.cnf

[mysqld]

default-storage-enginie=innodb

然后重启mysql数据库

./mysqladmin shutdown
./mysqld_safe &

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     | YES     | Default engine as of MySQL 3.23 with great performance     | NO           | NO   | NO         |
| InnoDB     | DEFAULT | 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         |
+------------+---------+------------------------------------------------------------+--------------+------+------------+
进入mysql 用show engines;如上图所示，Innodb已经支持了

本文出自 “网海过客” 博客，请务必保留此出处http://cqfish.blog.51cto.com/622299/159156