- How can I determine type of mysql database : whether it is InnoDB or MyISAM ?
- 如何确定mysql数据库的类型：是InnoDB还是MyISAM？
- How can I convert MyISAM to InnoDB or vice-versa ?
- 如何将MyISAM转换为InnoDB，反之亦然？
5 个解决方案
#1
33
To determine the storage engine being used by a table, you can use show table status. The Engine field in the results will show the database engine for the table. Alternately, you can select the engine field from information_schema.tables:
要确定表使用的存储引擎，可以使用show table status。结果中的Engine字段将显示表的数据库引擎。或者，您可以从information_schema.tables中选择引擎字段：
select engine
from information_schema.tables
where table_schema = 'schema_name'
and table_name = 'table_name'
You can change between storage engines using alter table:
您可以使用alter table在存储引擎之间进行更改：
alter table the_table engine = InnoDB;
Where, of course, you can specify any available storage engine.
当然，您可以指定任何可用的存储引擎。
#2
10
Select the database in question and run show table status;
选择有问题的数据库并运行show table status;
#3
3
SHOW TABLE STATUS FROM `database`;
will list everything for all tables, starting with whether they are MyISAM or InnoDB. if you desire to list only data regarding 1 table, the syntax below may be used* :
将列出所有表的所有内容，从它们是MyISAM还是InnoDB开始。如果您只想列出有关1个表的数据，可以使用以下语法*：
SHOW TABLE STATUS FROM `database` LIKE 'table';
to change the table engine:
更改表引擎：
ALTER TABLE `table` ENGINE=InnoDB;
*attention use the GRAVE ACCENT (` backtick) for the database name and the table name and the SINGLE QUOTE (') for the comparison string (portion of table name) after LIKE.
*注意在LIKE之后使用GRAVE ACCENT（`backtick）作为数据库名称和表名，并使用SINGLE QUOTE（'）作为比较字符串（表名的一部分）。
` != '
`！='
#4
1
Regarding converting myIsam to Innodb
关于将myIsam转换为Innodb
http://dev.mysql.com/doc/refman/5.0/en/converting-tables-to-innodb.html
http://dev.mysql.com/doc/refman/5.0/en/converting-tables-to-innodb.html
#5
0
How can I determine type of mysql database : whether it is InnoDB or MyISAM?
如何确定mysql数据库的类型：是InnoDB还是MyISAM？
#1
33
To determine the storage engine being used by a table, you can use show table status. The Engine field in the results will show the database engine for the table. Alternately, you can select the engine field from information_schema.tables:
要确定表使用的存储引擎，可以使用show table status。结果中的Engine字段将显示表的数据库引擎。或者，您可以从information_schema.tables中选择引擎字段：
select engine
from information_schema.tables
where table_schema = 'schema_name'
and table_name = 'table_name'
You can change between storage engines using alter table:
您可以使用alter table在存储引擎之间进行更改：
alter table the_table engine = InnoDB;
Where, of course, you can specify any available storage engine.
当然，您可以指定任何可用的存储引擎。
#2
10
Select the database in question and run show table status;
选择有问题的数据库并运行show table status;
#3
3
SHOW TABLE STATUS FROM `database`;
will list everything for all tables, starting with whether they are MyISAM or InnoDB. if you desire to list only data regarding 1 table, the syntax below may be used* :
将列出所有表的所有内容，从它们是MyISAM还是InnoDB开始。如果您只想列出有关1个表的数据，可以使用以下语法*：
SHOW TABLE STATUS FROM `database` LIKE 'table';
to change the table engine:
更改表引擎：
ALTER TABLE `table` ENGINE=InnoDB;
*attention use the GRAVE ACCENT (` backtick) for the database name and the table name and the SINGLE QUOTE (') for the comparison string (portion of table name) after LIKE.
*注意在LIKE之后使用GRAVE ACCENT（`backtick）作为数据库名称和表名，并使用SINGLE QUOTE（'）作为比较字符串（表名的一部分）。
` != '
`！='
#4
1
Regarding converting myIsam to Innodb
关于将myIsam转换为Innodb
http://dev.mysql.com/doc/refman/5.0/en/converting-tables-to-innodb.html
http://dev.mysql.com/doc/refman/5.0/en/converting-tables-to-innodb.html
#5
0
How can I determine type of mysql database : whether it is InnoDB or MyISAM?
如何确定mysql数据库的类型：是InnoDB还是MyISAM？