Bug #57154 Rename THREADS.ID to THREADS.PROCESSLIST_ID in 5.5

• Submitted: 30 Sep 2010 20:33
• Modified: 16 Nov 2010 3:41
• Reporter: Marc ALFF
• Status: Closed
• Category: MySQL Server: Performance Schema
• Severity: S3 (Non-critical)
• Version: 5.5.3-m3
• OS: Any
• Assigned to: Marc ALFF
• CPU Architecture: Any

[30 Sep 2010 20:33] Marc ALFF

Description:
In 5.5, the performance_schema.THREADS contains a column named ID.

In 5.6, now that WL#4674 is implemented, this column is named PROCESSLIST_ID.

To minimize the impact on users when upgrading from 5.5 to 5.6,
this column should be renamed in 5.5.

How to repeat:
show create table performance_schema.THREADS

Suggested fix:
As described

[30 Sep 2010 22:25] Vladislav Vaintroub

I'd rather rename threads to sessions. that we use thread per user-session is a tradition, or rather a bug that needs to be fixed :)

[7 Oct 2010 0:04] 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/120181

3096 Marc Alff	2010-10-06
      Bug#57154 Rename THREADS.ID to THREADS.PROCESSLIST_ID in 5.5
      
      This change is to align the 5.5 performance_schema.THREADS
      table definition with the 5.6 performance_schema.THREADS table,
      to facilitate the 5.5 -> 5.6 migration later.
      
      In the table performance_schema.THREADS:
      - renamed ID to PROCESSLIST_ID, removed not null
      - changed NAME from varchar(64) to varchar(128)
      to match the columns definitions from 5.6
      
      Adjusted the test cases accordingly.
      
      Note: this fix is for 5.5 only, to null merge into 5.6

[8 Oct 2010 17:41] Christopher Powers

Changes look good, patch approved.

[26 Oct 2010 9:07] Marc ALFF

Pushed into mysql-5.5-bugfixing

This fix is for 5.5 only, and should be "null merged" into mysql-trunk

[13 Nov 2010 16:10] Bugs System

Pushed into mysql-trunk 5.6.99-m5 (revid:[e-mail]-20101113155825-czmva9kg4n31anmu) (version source revid:[e-mail]-20101113152450-2zzcm50e7i4j35v7) (merge vers: 5.6.1-m4) (pib:21)

[13 Nov 2010 16:42] Bugs System

Pushed into mysql-next-mr (revid:[e-mail]-20101113160336-atmtmfb3mzm4pz4i) (version source revid:[e-mail]-20100629074804-359l9m9gniauxr94) (pib:21)

[16 Nov 2010 3:41] Paul DuBois

Noted in 5.5.8 changelog.

The following changes were made to the PERFORMANCE_SCHEMA.THREADS
table for conformance with the implementation in MySQL 5.6:

ID column: Renamed to PROCESSLIST_ID, removed NOT NULL from
definition. 

NAME column: Changed from VARCHAR(64) to VARCHAR(128).

[16 Dec 2010 22:28] Bugs System

Pushed into mysql-5.5 5.5.9 (revid:[e-mail]-20101216101358-fyzr1epq95a3yett) (version source revid:[e-mail]-20101216101358-fyzr1epq95a3yett) (merge vers: 5.5.9) (pib:24)