From: Date: September 2 2008 2:14pm Subject: svn commit - mysqldoc@docsrva: r11633 - in trunk: dynamic-docs/changelog refman-5.1 refman-6.0 List-Archive: http://lists.mysql.com/commits/53051 Message-Id: <200809021214.m82CEWue001252@docsrva.mysql.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Author: jstephens Date: 2008-09-02 14:14:31 +0200 (Tue, 02 Sep 2008) New Revision: 11633 Log: Documented new fix for Partitioning Bug #20129: ANALYZE|CHECK|OPTIMIZE|REPAIR TABLE supported with partitioned tables in 5.1.27+/6.0.7+. Modified: trunk/dynamic-docs/changelog/mysqld-1.xml trunk/refman-5.1/partitioning.xml trunk/refman-5.1/sql-syntax-data-definition.xml trunk/refman-6.0/partitioning.xml trunk/refman-6.0/sql-syntax-data-definition.xml Modified: trunk/dynamic-docs/changelog/mysqld-1.xml =================================================================== --- trunk/dynamic-docs/changelog/mysqld-1.xml 2008-08-30 02:18:16 UTC (rev 11632) +++ trunk/dynamic-docs/changelog/mysqld-1.xml 2008-09-02 12:14:31 UTC (rev 11633) Changed blocks: 2, Lines Added: 40, Lines Deleted: 1; 1785 bytes @@ -3799,9 +3799,11 @@ + + - + The following statements did not function correctly with @@ -3843,6 +3845,43 @@ + + + + The statements ANALYZE TABLE, CHECK + TABLE, OPTIMIZE TABLE, and + REPAIR TABLE are now supported for + partitioned tables. + + + + + + + + This restores functionality missing since the removal of + ALTER TABLE ... ANALYZE PARTITION, + ALTER TABLE ... CHECK PARTITION, + ALTER TABLE ... OPTIMIZE PARTITION, and + ALTER TABLE ... REPAIR PARTITION in MySQL + 5.1.24. + + + + + + + + This restores functionality missing since the removal of + ALTER TABLE ... ANALYZE PARTITION, + ALTER TABLE ... CHECK PARTITION, + ALTER TABLE ... OPTIMIZE PARTITION, and + ALTER TABLE ... REPAIR PARTITION in MySQL + 6.0.5. + + + + Modified: trunk/refman-5.1/partitioning.xml =================================================================== --- trunk/refman-5.1/partitioning.xml 2008-08-30 02:18:16 UTC (rev 11632) +++ trunk/refman-5.1/partitioning.xml 2008-09-02 12:14:31 UTC (rev 11633) Changed blocks: 1, Lines Added: 15, Lines Deleted: 9; 1892 bytes @@ -4918,19 +4918,25 @@ The statements CHECK TABLE, OPTIMIZE TABLE, ANALYZE - TABLE, and REPAIR TABLE are not - supported for partitioned tables. + TABLE, and REPAIR TABLE are + supported for partitioned tables beginning with MySQL + 5.1.27. Also in MySQL 5.1.27 and later, mysqlcheck and - myisamchk are also not supported for - partitioned tables. However, you can use ALTER - TABLE ... REBUILD PARTITION to rebuild one or more - partitions of a partitioned table; ALTER TABLE ... - REORGANIZE PARTITION also causes partitions to be - rebuilt. See , for more - information about these two statements. + myisamchk are supported with partitioned. + (See Bug #20129.) + + + In addition, you can use ALTER TABLE ... REBUILD + PARTITION to rebuild one or more partitions of a + partitioned table; ALTER TABLE ... REORGANIZE + PARTITION also causes partitions to be rebuilt. Both + of these statements were added in MySQL 5.1.5. See + , for more information about + these two statements. + Modified: trunk/refman-5.1/sql-syntax-data-definition.xml =================================================================== --- trunk/refman-5.1/sql-syntax-data-definition.xml 2008-08-30 02:18:16 UTC (rev 11632) +++ trunk/refman-5.1/sql-syntax-data-definition.xml 2008-09-02 12:14:31 UTC (rev 11633) Changed blocks: 1, Lines Added: 11, Lines Deleted: 0; 892 bytes @@ -1794,6 +1794,17 @@ and REPAIR PARTITION options were removed in MySQL 5.1.24. + + + + Beginning with MySQL 5.1.27, you can use the statements + ANALYZE TABLE, CHECK + TABLE, OPTIMIZE TABLE, and + REPAIR TABLE on partitioned tables. See + , for more + information. + + Modified: trunk/refman-6.0/partitioning.xml =================================================================== --- trunk/refman-6.0/partitioning.xml 2008-08-30 02:18:16 UTC (rev 11632) +++ trunk/refman-6.0/partitioning.xml 2008-09-02 12:14:31 UTC (rev 11633) Changed blocks: 1, Lines Added: 14, Lines Deleted: 10; 1869 bytes @@ -4824,19 +4824,23 @@ The statements CHECK TABLE, OPTIMIZE TABLE, ANALYZE - TABLE, and REPAIR TABLE are not - supported for partitioned tables. - mysqlcheck and - myisamchk are also not supported for - partitioned tables. However, you can use ALTER - TABLE ... REBUILD PARTITION to rebuild one or more - partitions of a partitioned table; ALTER TABLE ... - REORGANIZE PARTITION also causes partitions to be - rebuilt. See , for more - information about these two statements. + TABLE, and REPAIR TABLE are + supported for partitioned tables beginning with MySQL 6.0.7. + Also in MySQL 6.0.7 and later, mysqlcheck + and myisamchk are supported with + partitioned tables. (See Bug #20129.) + + + In addition, you can use ALTER TABLE ... REBUILD + PARTITION to rebuild one or more partitions of a + partitioned table; ALTER TABLE ... REORGANIZE + PARTITION also causes partitions to be rebuilt. See + , for more information about + these two statements. + Modified: trunk/refman-6.0/sql-syntax-data-definition.xml =================================================================== --- trunk/refman-6.0/sql-syntax-data-definition.xml 2008-08-30 02:18:16 UTC (rev 11632) +++ trunk/refman-6.0/sql-syntax-data-definition.xml 2008-09-02 12:14:31 UTC (rev 11633) Changed blocks: 1, Lines Added: 12, Lines Deleted: 3; 1204 bytes @@ -1540,10 +1540,19 @@ The ANALYZE PARTITION, CHECK PARTITION, OPTIMIZE PARTITION, and REPAIR PARTITION options were removed - in MySQL 6.0.5. We intend to reintroduce them (or replace them - with similar statement providing similar functionality) in a - future MySQL release. + in MySQL 6.0.5. + + + + Beginning with MySQL 6.0.7, you can use the statements + ANALYZE TABLE, CHECK + TABLE, OPTIMIZE TABLE, and + REPAIR TABLE on partitioned tables. See + , for more + information. + +