Bug #76374 | Partitioned tables not upgraded to use native partitioning | ||
---|---|---|---|
Submitted: | 18 Mar 2015 10:30 | Modified: | 4 Sep 2015 15:00 |
Reporter: | Mattias Jonsson | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Partitions | Severity: | S3 (Non-critical) |
Version: | 5.7.6 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[18 Mar 2015 10:30]
Mattias Jonsson
[4 Sep 2015 15:00]
Jon Stephens
Documented fix in the MySQL 5.7.9 changelog as follows: There was no way to upgrade existing partitioned tables to use the native partitioning implemented for InnoDB tables in MySQL 5.7.6. This fix adds support to both mysql_upgrade and the mysql client for upgrading partitioned InnoDB tables created in previous releases, which used the ha_partition handler, to use InnoDB native partitioning. ·mysql_upgrade now checks for all InnoDB tables that were created using the generic ha_partition handler and attempts to upgrade them to InnoDB native partitioning. ·In the mysql client, pre-5.7.6 partitioned InnoDB tables can be upgraded one by one to native partitioning using the ALTER TABLE ... UPGRADE PARTITIONING statement implemented in this release. Also added the new syntax to ALTER TABLE description in the Manual, noted behaviour changes in the What's New and mysql_upgrade sections of the Manual as well. Closed.