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

[20 Jul 2010 21:17] Marc Alff
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.
[20 Jul 2010 23:27] Bugs System
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.
[22 Jul 2010 20:10] Christopher Powers
Patch reviewed, code tested.
[12 Aug 2010 14:10] Bugs System
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.
[12 Aug 2010 16:03] Marc Alff
Pushed into:
- mysql-5.5-bugfixing
- mysql-trunk-bugfixing
- mysql-next-mr-bugfixing
[12 Aug 2010 16:08] Marc Alff
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.
[25 Aug 2010 9:24] Bugs System
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)
[30 Aug 2010 8:32] Bugs System
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)
[30 Aug 2010 8:36] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100830082745-n6sh01wlwh3itasv) (version source revid:alik@sun.com-20100830082745-n6sh01wlwh3itasv) (pib:21)
[10 Sep 2010 2:23] Paul Dubois
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.