Chinaunix
標(biāo)題: 將MySQL 5.1 MyISAM 轉(zhuǎn)換成 INNODB 存儲引擎 [打印本頁]
作者: flashhand 時間: 2011-12-22 08:53
標(biāo)題: 將MySQL 5.1 MyISAM 轉(zhuǎn)換成 INNODB 存儲引擎
mysql 5.1默認(rèn)只啟用MyISAM, 使用INNODB要做一下修改:
=== InnoDB Storage Engine ===
Plugin Name: innobase
Description: Transactional Tables using InnoDB
Supports build: static and dynamic
Configurations: max, max-no-ndb
mysql 5.1版本之后,要使用innodb有兩種方法
(1).靜態(tài)編譯的時候加入 --with-plugin-innobase
(2).動態(tài)擴展 啟動mysqld后
mysql>INSTALL PLUGIN innodb SONAME 'ha_innodb.so'
mysql> show plugin
就可以看見了
動態(tài)的話plugin_dir要指定正確:
[mysqld]
plugin_dir=/path/to/plugin/directory
最后,通過動態(tài)方式,解決了這個轉(zhuǎn)換問題。
查看mysql 5.1 是否安裝了innodb插件(mysql 5.0使用: show variables like 'have_%';)
mysql> show plugins;
+------------+--------+----------------+--------------+---------+
| Name | Status | Type | Library | License |
+------------+--------+----------------+--------------+---------+
| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
| CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL | |
+------------+--------+----------------+--------------+---------+
5 rows in set (0.00 sec)
發(fā)現(xiàn)沒有安裝 INNODB,執(zhí)行下面語句:
mysql> install plugin innodb soname 'ha_innodb.so';
再次查看:
mysql> show plugins;
+------------+--------+----------------+--------------+---------+
| Name | Status | Type | Library | License |
+------------+--------+----------------+--------------+---------+
| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
| CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| InnoDB | ACTIVE | STORAGE ENGINE | ha_innodb.so | GPL |
+------------+--------+----------------+--------------+---------+
6 rows in set (0.00 sec)
2. 查看表的類型:
mysql> use web_db;
mysql> show tablse;
隨便找個表看類型:
mysql> show create table sys_user;
查看是否有以下字段:
ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8
如何將MyISAM庫 導(dǎo)成 INNODB:
在備份出的 xxx.bak文件中 把 ENGINE=MyISAM 全換成 ENGINE=INNODB
再次導(dǎo)入就可以了。
轉(zhuǎn)換表的命令:
alter table POD engine=innodb;
歡迎光臨 Chinaunix (http://www.72891.cn/) |
Powered by Discuz! X3.2 |