《Mysql入門Mysql更換MyISAM存儲引擎為Innodb的操作記錄總結》要點：
本文介紹了Mysql入門Mysql更換MyISAM存儲引擎為Innodb的操作記錄總結，希望對您有用。如果有疑問，可以聯系我們。
MYSQL入門一般情況下,mysql會默認提供多種存儲引擎,可以通過下面的查看:
MYSQL入門1)查看mysql是否安裝了innodb插件.
MYSQL入門通過下面的命令結果可知,已經安裝了innodb插件.
MYSQL入門
mysql> show plugins;
+------------+--------+----------------+---------+---------+
| Name | Status | Type | Library | License |
+------------+--------+----------------+---------+---------+
| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
| partition | ACTIVE | STORAGE ENGINE | NULL | GPL |
| CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
| InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
+------------+--------+----------------+---------+---------+
7 rows in set (0.00 sec)
MYSQL入門----------------------------------------------------------------------
如果發現沒有安裝innodb插件,可以執行下面語句進行安裝：
mysql> install plugin innodb soname 'ha_innodb.so';
----------------------------------------------------------------------
MYSQL入門2)查看mysql現在已提供什么存儲引擎:
MYSQL入門
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入門3)查看mysql當前默認的存儲引擎:
MYSQL入門
mysql> show variables like '%storage_engine%';
+----------------+--------+
| Variable_name | Value |
+----------------+--------+
| storage_engine | MyISAM |
+----------------+--------+
1 row in set (0.00 sec)
MYSQL入門4)看某個表用了什么引擎(在顯示結果里參數engine后面的就表示該表當前用的存儲引擎):
MYSQL入門mysql> show create table 表名;
MYSQL入門
mysql> show create table wx_share_log;
+--------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+--------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| wx_share_log | CREATE TABLE `wx_share_log` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '微信分享日志自增ID',
`reference_id` int(11) NOT NULL COMMENT '保舉的經紀人id',
`create_time` datetime NOT NULL COMMENT '創建時間',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 |
+--------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
MYSQL入門5)如何將MyISAM庫導成INNODB引擎格式的:
MYSQL入門在備份出的xxx.sql文件中把ENGINE=MyISAM全換成ENGINE=INNODB
再次導入就可以了.
MYSQL入門6)轉換表的命令:
MYSQL入門mysql> alter table 表名 engine=innodb;
MYSQL入門有上面可以查到看,本機mysql使用的存儲引擎是默認的MyISAN,由于業務必要,先要將其存儲引擎改為Innodb.
MYSQL入門操作記錄如下：
MYSQL入門1)以平安模式關閉mysql
MYSQL入門[root@dev mysql5.1.57]# mysqladmin -uroot -p shutdown
Enter password:
[root@dev mysql5.1.57]# ps -ef|grep mysql
MYSQL入門2)備份my.cnf
MYSQL入門[root@dev mysql5.1.57]# cp my.cnf my.cnf.old
MYSQL入門3)修改my.cnf配置文件
MYSQL入門[root@dev mysql5.1.57]# vim my.cnf
.....
[mysqld] ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?//在這個配置區域添加下面一行,指定存儲引擎為innodb
default-storage-engine = InnoDB
MYSQL入門4)刪除/mysql/data目錄下的ib_logfile0,ib_logfile1.刪除或剪切到別處都行.
MYSQL入門[root@dev var]# mv ib_logfile0 ib_logfile1 /tmp/back/
MYSQL入門5)啟動mysql,登陸mysql驗證存儲引擎是否已切換
MYSQL入門[root@dev var]# /Data/app/mysql5.1.57/bin/mysqld_safe --defaults-file=/Data/app/mysql5.1.57/my.cnf &
MYSQL入門
mysql> show variables like '%storage_engine%';
+----------------+--------+
| Variable_name | Value |
+----------------+--------+
| storage_engine | InnoDB |
+----------------+--------+
1 row in set (0.00 sec)
MYSQL入門以上這篇Mysql更換MyISAM存儲引擎為Innodb的操作記錄總結便是小編分享給大家的全部內容了,希望能給大家一個參考,也希望大家多多支持維易PHP.
《Mysql入門Mysql更換MyISAM存儲引擎為Innodb的操作記錄總結》是否對您有啟發，歡迎查看更多與《Mysql入門Mysql更換MyISAM存儲引擎為Innodb的操作記錄總結》相關教程，學精學透。維易PHP學院為您提供精彩教程。
轉載請注明本頁網址：
http://www.snjht.com/jiaocheng/9848.html
