+ -
当前位置:首页 → 问答吧 → mysql 如何启用InnoDB引擎?

mysql 如何启用InnoDB引擎?

时间:2011-10-17

来源:互联网

如题:
mysql> show engines;
+------------+----------+----------------------------------------------------------------+
| Engine | Support | Comment |
+------------+----------+----------------------------------------------------------------+
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | 
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | 
| InnoDB | DISABLED | Supports transactions, row-level locking, and foreign keys | 
| BerkeleyDB | YES | Supports transactions and page-level locking | 
| BLACKHOLE | NO | /dev/null storage engine (anything you write to it disappears) | 
| EXAMPLE | NO | Example storage engine | 
| ARCHIVE | NO | Archive storage engine | 
| CSV | NO | CSV storage engine | 
| ndbcluster | NO | Clustered, fault-tolerant, memory-based tables | 
| FEDERATED | NO | Federated MySQL storage engine | 
| MRG_MYISAM | YES | Collection of identical MyISAM tables | 
| ISAM | NO | Obsolete storage engine | 
+------------+----------+----------------------------------------------------------------+

作者: shrimpma   发布时间: 2011-10-17

1)关闭mysqld服务
2)修改my.ini(linux下是my.cnf)将skip-innodb这行注释掉或删掉
3) 保存后重启mysqld服务

作者: nicenight   发布时间: 2011-10-17

引用 1 楼 nicenight 的回复:
1)关闭mysqld服务
2)修改my.ini(linux下是my.cnf)将skip-innodb这行注释掉或删掉
3) 保存后重启mysqld服务
1

作者: rucypli   发布时间: 2011-10-17

我的环境是linux

在my.cnf没有skip-innodb这个选项啊?

作者: shrimpma   发布时间: 2011-10-17

相关阅读 更多