【已解决】gentoo如何启动mysql的innodb引擎?

4DSpace

gentoo 系统.livecd 2008的版本.没用最新的10.1

安装后,有一台服务器上的MySQL用
show engine查看,发现 innodb是 disabled,默认是myisam

如何修改配置让mysql支持innodb引擎??

druggo

看这个里面/etc/mysql/my.cnf
把skip-innodb注释掉。

4DSpace

默认skip-innodb前面有个#
取消这个#是不是用innodb的意思吧?

4DSpace

终于好用了..
默认gentoo是#skip-innodb的.也就是启用innodb
但是在/var/mysql_data/有
ib_logfile0
ib_logfile1
ibdata1

这几个文件

我rm ib*以后,进入 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 | YES | Supports transactions, row-level locking, and foreign keys |
| BerkeleyDB | NO | 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 |
+------------+---------+----------------------------------------------------------------+
12 rows in set (0.00 sec)


终于可以用了..

问题解决