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
Triage: Needs Triage: D3 (Medium)

[15 Jan 2013 11:46] Valeriy Kravchuk
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.
[15 Jan 2013 11:49] Valeriy Kravchuk
[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)
[15 Jan 2013 15:26] Sveta Smirnova
Thank you for the report.

Verified as described.
[30 Jan 2013 18:17] Paul Dubois
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.
[30 Jan 2013 18:19] Paul Dubois
There was no change of column name. This section just used the wrong name.