MySQL Bugs: #68089: Manual refers to wrong (old?) column names for some P

Bug #68089	Manual refers to wrong (old?) column names for some P_S tables
Submitted:	15 Jan 2013 11:46	Modified:	30 Jan 2013 18:17
Reporter:	Valeriy Kravchuk	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.6, 5.7.1, 5.5.30	OS:	Any
Assigned to:	Paul DuBois	CPU Architecture:	Any
Tags:	event_name, performance_schema

Description:
http://dev.mysql.com/doc/refman/5.6/en/innodb-performance.html, says:

"During performance testing, examine the performance data in the events_waits_current and events_waits_history_long tables. If you are interested especially in InnoDB-related objects, use the clause where name like "%innodb%" to see just those entries;"

In reality (latest MySQL 5.6.9-rc) there is no NAME column in these tables. It is called EVENT_NAME now.

How to repeat:
Try to execute the query with WHERE clause mentioned on that manual page above.

Suggested fix:
Fix the entire MySQL 5.6 manual to refer to current column names in all P_S tables, before MySQL 5.6 GA if possible.

[valerii.kravchuk@cisco1 mysql-5.6.9-rc-linux-glibc2.5-x86_64]$ bin/mysql -uroot test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.9-rc MySQL Community Server (GPL)

Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> desc performance_schema.events_waits_history_long;
+-----------------------+----------------------------------+------+-----+---------+-------+
| Field                 | Type                             | Null | Key | Default | Extra |
+-----------------------+----------------------------------+------+-----+---------+-------+
| THREAD_ID             | bigint(20) unsigned              | NO   |     | NULL    |       |
| EVENT_ID              | bigint(20) unsigned              | NO   |     | NULL    |       |
| END_EVENT_ID          | bigint(20) unsigned              | YES  |     | NULL    |       |
| EVENT_NAME            | varchar(128)                     | NO   |     | NULL    |       |
| SOURCE                | varchar(64)                      | YES  |     | NULL    |       |
| TIMER_START           | bigint(20) unsigned              | YES  |     | NULL    |       |
| TIMER_END             | bigint(20) unsigned              | YES  |     | NULL    |       |
| TIMER_WAIT            | bigint(20) unsigned              | YES  |     | NULL    |       |
| SPINS                 | int(10) unsigned                 | YES  |     | NULL    |       |
| OBJECT_SCHEMA         | varchar(64)                      | YES  |     | NULL    |       |
| OBJECT_NAME           | varchar(512)                     | YES  |     | NULL    |       |
| INDEX_NAME            | varchar(64)                      | YES  |     | NULL    |       |
| OBJECT_TYPE           | varchar(64)                      | YES  |     | NULL    |       |
| OBJECT_INSTANCE_BEGIN | bigint(20) unsigned              | NO   |     | NULL    |       |
| NESTING_EVENT_ID      | bigint(20) unsigned              | YES  |     | NULL    |       |
| NESTING_EVENT_TYPE    | enum('STATEMENT','STAGE','WAIT') | YES  |     | NULL    |       |
| OPERATION             | varchar(32)                      | NO   |     | NULL    |       |
| NUMBER_OF_BYTES       | bigint(20)                       | YES  |     | NULL    |       |
| FLAGS                 | int(10) unsigned                 | YES  |     | NULL    |       |
+-----------------------+----------------------------------+------+-----+---------+-------+
19 rows in set (0.00 sec)

mysql> desc performance_schema.events_waits_current;
+-----------------------+----------------------------------+------+-----+---------+-------+
| Field                 | Type                             | Null | Key | Default | Extra |
+-----------------------+----------------------------------+------+-----+---------+-------+
| THREAD_ID             | bigint(20) unsigned              | NO   |     | NULL    |       |
| EVENT_ID              | bigint(20) unsigned              | NO   |     | NULL    |       |
| END_EVENT_ID          | bigint(20) unsigned              | YES  |     | NULL    |       |
| EVENT_NAME            | varchar(128)                     | NO   |     | NULL    |       |
| SOURCE                | varchar(64)                      | YES  |     | NULL    |       |
| TIMER_START           | bigint(20) unsigned              | YES  |     | NULL    |       |
| TIMER_END             | bigint(20) unsigned              | YES  |     | NULL    |       |
| TIMER_WAIT            | bigint(20) unsigned              | YES  |     | NULL    |       |
| SPINS                 | int(10) unsigned                 | YES  |     | NULL    |       |
| OBJECT_SCHEMA         | varchar(64)                      | YES  |     | NULL    |       |
| OBJECT_NAME           | varchar(512)                     | YES  |     | NULL    |       |
| INDEX_NAME            | varchar(64)                      | YES  |     | NULL    |       |
| OBJECT_TYPE           | varchar(64)                      | YES  |     | NULL    |       |
| OBJECT_INSTANCE_BEGIN | bigint(20) unsigned              | NO   |     | NULL    |       |
| NESTING_EVENT_ID      | bigint(20) unsigned              | YES  |     | NULL    |       |
| NESTING_EVENT_TYPE    | enum('STATEMENT','STAGE','WAIT') | YES  |     | NULL    |       |
| OPERATION             | varchar(32)                      | NO   |     | NULL    |       |
| NUMBER_OF_BYTES       | bigint(20)                       | YES  |     | NULL    |       |
| FLAGS                 | int(10) unsigned                 | YES  |     | NULL    |       |
+-----------------------+----------------------------------+------+-----+---------+-------+
19 rows in set (0.00 sec)

Thank you for the report.

Verified as described.

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.

There was no change of column name. This section just used the wrong name.