解决MySQL InnoDB Error: Data File ibdata2 Uses Page Size … But the Only Supported Page Size In This Release Ss=16384

适用于：

MySQL服务器版本5.5到5.5 [发行版5.5]

本文信息适用于所有平台。

症状

当重新启动MySQL5.5.20或5.5.21时，MySQL无法启动，并且在错误日志中出现以下错误：

121215 11:25:25 InnoDB: Error: data file /mysql_data/mysql_databases/ibdata2 uses page size
1024,
12121 5 11:25:25 InnoDB: but the only supported page size in this release is=16384
121215 11:25:25 InnoDB: Could not open or create data files.

报告的ibdata2页大小可以有除了1024的其他尺寸。

更改

这个问题通常在使用ALTER TABLE语句改变一个InnoDB表的KEY_BLOCK_SIZE属性时发生，例如从一个未压缩表切换到压缩表时。

原因

这是由于防止从MySQL5.6降级的更改而造成的复原，其支持除16k以外的页大小。

参见 Bug 13698765 64160: PAGE SIZE 1024 BUT THE ONLY SUPPORTED PAGE SIZE IN THIS RELEASE IS=16384.

解决方案

解决的办法是升级到MySQL5.5.22或更高版本。

建议升级到最新的补丁版本，以获得所有最新的补丁。

参见：

How to Download MySQL Server 5.6, 5.5, 5.1 or 5.0; Standard Edition, Enterprise Edition; Advanced, Pro, Classic, Patch

How to Upgrade your Existing MySQL Server to MySQL 5.6 Version (this also applies to MySQL 5.5)

参考

BUG:13698765 64160:

PAGE SIZE 1024 BUT THE ONLY SUPPORTED PAGE SIZE IN THIS RELEASE

IS=16384

NOTE:1300654.1 How to Download MySQL Server 5.6, 5.5, 5.1 or 5.0; Standard Edition, Enterprise Edition; Advanced, Pro, Classic, Patch

NOTE:1319877.1 How to Upgrade your Existing MySQL Server to MySQL 5.6 Version

NOTE:1589556.1 How does Patching Work in MySQL?; How to Apply All the Latest Patches?; How to Find the Latest Patches

Didn’t find what you are looking for?

Keywords

DATA FILE; MYSQL; PATCH; REGRESSION; TABLESPACE; INNODB STORAGE ENGINE