winxp 下,mysql5.0mysql> 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 | NO | Supports transactions and page-level locking |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) |
| EXAMPLE | NO | Example storage engine |
| ARCHIVE | YES | Archive storage engine |
| CSV | NO | CSV storage engine |
| ndbcluster | NO | Clustered, fault-tolerant, memory-based tables |
| FEDERATED | DISABLED | Federated MySQL storage engine |
| MRG_MYISAM | YES | Collection of identical MyISAM tables |
| ISAM | NO | Obsolete storage engine |
+------------+----------+----------------------------------------------------------------+这里InnoDB是DISABLED 的,怎么配置让他支持呢?这里我已经放开注释了:
# Uncomment the following if you are using InnoDB tables
+------------+----------+----------------------------------------------------------------+
| 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 | NO | Supports transactions and page-level locking |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) |
| EXAMPLE | NO | Example storage engine |
| ARCHIVE | YES | Archive storage engine |
| CSV | NO | CSV storage engine |
| ndbcluster | NO | Clustered, fault-tolerant, memory-based tables |
| FEDERATED | DISABLED | Federated MySQL storage engine |
| MRG_MYISAM | YES | Collection of identical MyISAM tables |
| ISAM | NO | Obsolete storage engine |
+------------+----------+----------------------------------------------------------------+这里InnoDB是DISABLED 的,怎么配置让他支持呢?这里我已经放开注释了:
# Uncomment the following if you are using InnoDB tables
解决方案 »
- 求助,求一mysql查询表达式
- winxp下,c#连接mysql,除了安装MySQLDriverCS,有没有更好的方法?
- an error occurred while establishing the connection
- grall all 给 192.168.10.%赋予最大权限给某个库 但是更新失败
- 一个好像有点复杂的SQL
- linux下安装mysql 的问题:不能启动
- 如何在Windows上运行多个MySql服务器?
- MySQL-Front的问题
- 求助jdbc调用存储过程问题!!!!!!!!!!!!!
- My Sql数据库求教大佬
- mysql语句优化问题 大家给优化个SQL语句
- 请问MYSQL有没有不输出query结果只输出query执行时间的方法?
# Use this option if you have a MySQL server with InnoDB support enabled
# but you do not plan to use it. This will save memory and disk space
# and speed up some things.
#skip-innodb
找到方法是:安装的时候就选transaction的方式.把配置文件里面的
# Uncomment the following if you are using InnoDB tables 这里注释放开