Description:
I can't analyze partition tables.
How to repeat:
mysql> show create table test1\G
*************************** 1. row ***************************
Table: test1
Create Table: CREATE TABLE `test1` (
`c1` datetime DEFAULT NULL,
KEY `test1_idx1` (`c1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 /*!50100 PARTITION BY RANGE (year(c1)) (PARTITION p0 VALUES LESS THAN (2001) ENGINE = InnoDB, PARTITION px VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
1 row in set (0.01 sec)
mysql> analyze table test1;
+-------------+---------+----------+----------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------+---------+----------+----------------------------------------------------------+
| scott.test1 | analyze | note | The storage engine for the table doesn't support analyze |
+-------------+---------+----------+----------------------------------------------------------+
1 row in set (0.01 sec)
mysql> alter table test1 analyze partition p0;
ERROR 1178 (42000): The storage engine for the table doesn't support analyze partition
##########
In 5.1.6,
mysql> analyze table test1;
+-------------+---------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------+---------+----------+----------+
| scott.test1 | analyze | status | OK |
+-------------+---------+----------+----------+
1 row in set (0.00 sec)
mysql> alter table test1 analyze partition p0;
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
Suggested fix:
5.1.6 ... can analyze. (cf. Bug #13441)
5.1.25 ... can't analyze.
Is there a degrade?
Please fix that.
Description: I can't analyze partition tables. How to repeat: mysql> show create table test1\G *************************** 1. row *************************** Table: test1 Create Table: CREATE TABLE `test1` ( `c1` datetime DEFAULT NULL, KEY `test1_idx1` (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 /*!50100 PARTITION BY RANGE (year(c1)) (PARTITION p0 VALUES LESS THAN (2001) ENGINE = InnoDB, PARTITION px VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */ 1 row in set (0.01 sec) mysql> analyze table test1; +-------------+---------+----------+----------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +-------------+---------+----------+----------------------------------------------------------+ | scott.test1 | analyze | note | The storage engine for the table doesn't support analyze | +-------------+---------+----------+----------------------------------------------------------+ 1 row in set (0.01 sec) mysql> alter table test1 analyze partition p0; ERROR 1178 (42000): The storage engine for the table doesn't support analyze partition ########## In 5.1.6, mysql> analyze table test1; +-------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------+---------+----------+----------+ | scott.test1 | analyze | status | OK | +-------------+---------+----------+----------+ 1 row in set (0.00 sec) mysql> alter table test1 analyze partition p0; Query OK, 0 rows affected (0.00 sec) Records: 0 Duplicates: 0 Warnings: 0 Suggested fix: 5.1.6 ... can analyze. (cf. Bug #13441) 5.1.25 ... can't analyze. Is there a degrade? Please fix that.