MySQL Bugs: #49725: 'manage key' status undocumented

Bug #49725	'manage key' status undocumented
Submitted:	15 Dec 2009 22:29	Modified:	12 Jan 2010 19:54
Reporter:	Vadim TKACHENKO	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.1.41	OS:	Any
Assigned to:	Paul DuBois	CPU Architecture:	Any

Description:
Running ALTER TABLE ADD KEY on 5.1.41 with InnoDB-plugin
I see status 'manage key', which I am not sure what meaning it has.

mysql> show processlist;   
+----+------+-----------+----------+---------+------+-------------+--------------------------------------+
| Id | User | Host      | db       | Command | Time | State       | Info                                 |
+----+------+-----------+----------+---------+------+-------------+--------------------------------------+
|  1 | root | localhost | wikistat | Query   |  141 | manage keys | alter table pages0 add key (crchash) | 
|  2 | root | localhost | NULL     | Query   |    0 | NULL        | show processlist                     | 
+----+------+-----------+----------+---------+------+-------------+--------------------------------------+
2 rows in set (0.00 sec)

How to repeat:
create index on InnoDB table with InnoDB-plugin running.

Suggested fix:
Document status

Thank you for the bug report.

mysql 5.1 >show processlist\G
*************************** 1. row ***************************
     Id: 1
   User: root
   Host: localhost:65386
     db: test
Command: Query
   Time: 16
  State: manage keys
   Info: alter table t4 add key (name)
*************************** 2. row ***************************
     Id: 2
   User: root
   Host: localhost:65390
     db: test
Command: Query
   Time: 0
  State: NULL
   Info: show processlist
2 rows in set (0.00 sec)

mysql 5.1 >show variables like "%version%";
+-------------------------+---------------------+
| Variable_name           | Value               |
+-------------------------+---------------------+
| innodb_version          | 1.0.6               |
| protocol_version        | 10                  |
| version                 | 5.1.43-Win X64-log  |
| version_comment         | Source distribution |
| version_compile_machine | unknown             |
| version_compile_os      | Win64               |
+-------------------------+---------------------+
6 rows in set (0.00 sec)

mysql 5.1 >

Change to Documentation since "manage keys" was written by server during mysql_alter_table(), not InnoDB specific.

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

Added meaning of the state to http://dev.mysql.com/doc/refman/5.1/en/general-thread-states.html:

The server is enabling or disabling a table index.