如何在MySQL上更改存储引擎类型? [英] How to change the storage engine type on MySQL?

问题描述

我想在所有表和数据库上使用InnoDB作为存储引擎.我可以运行一条命令来更改当前表的类型以使用InnoDB代替MyISAM吗?

I would like to use InnoDB as the storage engine on all my tables and databases. Is there a command I can run to change the type of my current tables to use InnoDB instead of MyISAM?

还可以将其设置为默认值，这样我就不必再次执行此操作了吗?

Also, is there a way to set this as the default so I don't have to do this again?

推荐答案

以下文章将告诉您如何设置默认存储引擎，如何在CREATE TABLE命令期间显式使用特定引擎以及如何更改存储现有表的引擎:

The following article will tell you how to set the default storage engine, how to explicitly use a specific engine during a CREATE TABLE command, and how to change the storage engine of existing tables:

http://dev.mysql.com/doc/refman/5.1/en/storage-engine-setting.html

这篇关于如何在MySQL上更改存储引擎类型?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！