expand_fast_index_creation is Broken For RENAME INDEX

Bug #1101660 reported by Jervin R
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Medium
Hrvoje Matijakovic
5.1
Fix Released
Medium
Hrvoje Matijakovic
5.5
Fix Released
Medium
Hrvoje Matijakovic

Bug Description

This page http://www.percona.com/doc/percona-server/5.1/management/innodb_fast_index_renaming.html indicates that an extended RENAME INDEX clause is available, however after making sure fast_index_creation and expand_fast_index_creation is ON the it would return an invalid syntax error.

This has been tested on 5.5.28-29.2, 5.1.66, 5.1.59 (wiki says expand_fast_index_creation was implemented here), 5.1.56 (http://www.mysqlperformanceblog.com/2011/11/06/improved-innodb-fast-index-creation/ says expand_fast_index_creation was available since 5.1.56).

How to repeat:

mysql [localhost] {msandbox} (test) > CREATE TABLE `t` (
    -> `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    -> `c` char(1) DEFAULT NULL,
    -> PRIMARY KEY (`id`),
    -> KEY `cxc` (`c`)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (0.11 sec)

mysql [localhost] {msandbox} (test) > show variables like '%fast_index_creation';
+----------------------------+-------+
| Variable_name | Value |
+----------------------------+-------+
| expand_fast_index_creation | OFF |
| fast_index_creation | ON |
+----------------------------+-------+
2 rows in set (0.00 sec)

mysql [localhost] {msandbox} (test) > set expand_fast_index_creation=ON;
Query OK, 0 rows affected (0.00 sec)

mysql [localhost] {msandbox} (test) > show variables like '%fast_index_creation';
+----------------------------+-------+
| Variable_name | Value |
+----------------------------+-------+
| expand_fast_index_creation | ON |
| fast_index_creation | ON |
+----------------------------+-------+
2 rows in set (0.00 sec)

mysql [localhost] {msandbox} (test) > alter table t rename index cxc to cxx;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'index cxc to cxx' at line 1

Tags: doc
Revision history for this message
Jervin R (revin) wrote :

This wiki entry http://www.percona.com/doc/percona-server/5.1/management/innodb_fast_index_renaming.html says "5.1.49-12.0: Not yet released externally" - maybe this feature is not really generally available and if so, should be documented clearly on the page.

Revision history for this message
Alexey Kopytov (akopytov) wrote :

Yes, RENAME INDEX has never been a part of Percona Server. It was only implemented in a separate branch.

It also has nothing to do with (expand_)fast_index_creation.

We can backport RENAME INDEX to main Percona Server branches.

Revision history for this message
Alexey Kopytov (akopytov) wrote :

Let's keep this bug as a request to fix docs. The port will be tracked as a BP: https://blueprints.launchpad.net/percona-server/+spec/port-rename-index

tags: added: doc
Revision history for this message
Hrvoje Matijakovic (hrvojem) wrote :

This has been fixed before, adjusted the Jenkins jobs to remove the stale files from the web.

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1303

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.