我的桌子是什么ROW_FORMAT? [英] What ROW_FORMAT is my table?

问题描述

我发现MySQL具有多种行格式，可以指定或更改它.另外，默认的ROW_FORMAT显然已经随着MySQL版本的变化而改变，这是可以理解的.

I've discovered that MySQL has multiple row formats, and it's possible to specify this or change it. Also, the default ROW_FORMAT has apparently changed over time with MySQL versions, which is understandable.

但是，我找不到任何地方说如何找出现有表的ROW_FORMAT！从旧版本的MySQL开始，我的数据库已经存在多年了，我想确保我没有使用性能不佳的古老磁盘格式.

However, I can't find anywhere that says how to find out what the ROW_FORMAT of an existing table is! My database has been around for years, from older versions of MySQL, and I want to make sure I'm not using a poorly performing ancient disk format.

如何找出MySQL中表格的ROW_FORMAT?

How do I find out the ROW_FORMAT of a table in MySQL?

推荐答案

2014.06.19-轻微更新

以下查询将为您提供当前数据库中所有表的行格式:

2014.06.19 - Mild Update

The following query will give you the row format of all tables in the current database:

SELECT `table_name`, `row_format`
FROM `information_schema`.`tables`
WHERE `table_schema`=DATABASE();

这篇关于我的桌子是什么ROW_FORMAT?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！