如何检查特定表的 MySQL 引擎类型?

2021-11-20 00:00:00 mysql innodb myisam

我的 MySQL 数据库包含多个使用不同存储引擎的表(特别是 myisam 和 innodb).我怎样才能找出哪些表是使用哪个引擎?

My MySQL database contains several tables using different storage engines (specifically myisam and innodb). How can I find out which tables are using which engine?

推荐答案

SHOW TABLE STATUS WHERE Name = 'xxx'

这将为您提供(除其他外)一个 Engine 列，这正是您想要的.

This will give you (among other things) an Engine column, which is what you want.

相关文章