MySQL Bugs: #55416: Renaming of performance

Bug #55416	Renaming of performance_schema tables in 5.5
Submitted:	20 Jul 2010 21:17	Modified:	10 Sep 2010 2:23
Reporter:	Marc ALFF	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Performance Schema	Severity:	S1 (Critical)
Version:		OS:	Any
Assigned to:	Marc ALFF	CPU Architecture:	Any

Description:
This fix is required in 5.5 to simplify the upgrade from 5.5 to 5.6 later.

Now that the 5.5 (mysql-trunk) and 5.6 (mysql-next-mr) code bases have
forked, no new feature will be implemented in 5.5.

As a result, tables that were place holders for new features to come
should be cleaned up.

In particular:

1)
The table performance_schema.SETUP_OBJECTS should be removed.
This table is not implemented and documented as "for future use" in 5.5.
Given that the 5.6 implementation will be slightly different, keeping a
non implemented and non supported table in 5.5 does not make sense.
This table should be removed from mysql-trunk before the code goes GA.

2)
The table performance_schema.PROCESSLIST should be renamed to
performance_schema.THREADS.
This is to facilitate the upgrade to 5.6 to the THREADS table,
as defined by WL#4676 PERFORMANCE SCHEMA SETUP_ACTORS

The actual table structure stays unchanged in 5.5 (3 columns only)

3)
The table performance_schema.EVENTS_WAITS_SUMMARY_BY_EVENT_NAME should
be renamed EVENTS_WAITS_SUMMARY_GLOBAL_BY_EVENT_NAME.
This is to facilitate the upgrade to 5.6 to this aggregate table,
as defined by WL#4816 PERFORMANCE SCHEMA SUMMARIES.

How to repeat:
show tables;
show create table;

Suggested fix:
As described.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/114002

3133 Marc Alff	2010-07-20
      Bug#55416 Renaming of performance_schema tables in mysql-trunk for 5.5
      
      Removed table SETUP_OBJECTS.
      
      Renamed table PROCESSLIST to THREADS.
      
      Renamed table EVENTS_WAITS_SUMMARY_BY_EVENT_NAME
      to EVENTS_WAITS_SUMMARY_GLOBAL_BY_EVENT_NAME.
      
      Adjusted Makefiles, code and tests accordingly.

Patch reviewed, code tested.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/115594

3177 Marc Alff	2010-08-12
      Bug#55416 Renaming of performance_schema tables for 5.5
            
      Removed table SETUP_OBJECTS.
            
      Renamed table PROCESSLIST to THREADS.
            
      Renamed table EVENTS_WAITS_SUMMARY_BY_EVENT_NAME
      to EVENTS_WAITS_SUMMARY_GLOBAL_BY_EVENT_NAME.
            
      Adjusted Makefiles, code and tests accordingly.

Pushed into:
- mysql-5.5-bugfixing
- mysql-trunk-bugfixing
- mysql-next-mr-bugfixing

Doc team:

Removed table SETUP_OBJECTS.
            
Renamed table PROCESSLIST to THREADS.
            
Renamed table EVENTS_WAITS_SUMMARY_BY_EVENT_NAME
to EVENTS_WAITS_SUMMARY_GLOBAL_BY_EVENT_NAME.

Pushed into mysql-5.5 5.5.6-m3 (revid:alik@ibmvm-20100825092002-2yvkb3iwu43ycpnm) (version source revid:alik@ibmvm-20100825092002-2yvkb3iwu43ycpnm) (merge vers: 5.5.6-m3) (pib:20)

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@sun.com-20100830082732-n2eyijnv86exc5ci) (version source revid:alik@sun.com-20100830082732-n2eyijnv86exc5ci) (merge vers: 5.6.1-m4) (pib:21)

Pushed into mysql-next-mr (revid:alik@sun.com-20100830082745-n6sh01wlwh3itasv) (version source revid:alik@sun.com-20100830082745-n6sh01wlwh3itasv) (pib:21)

Noted in 5.5.6, 5.6.1 changelogs.

Several changes were made to Performance Schema tables:

* The SETUP_OBJECTS table was removed.

* The PROCESSLIST table was renamed to THREADS.

* The EVENTS_WAITS_SUMMARY_BY_EVENT_NAME table was renamed to
  EVENTS_WAITS_SUMMARY_GLOBAL_BY_EVENT_NAME.