Submitted: 30 Sep 2010 20:33 Modified: 16 Nov 2010 3:41
Reporter: Marc ALFF Email Updates:
Status: Closed Impact on me:
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
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:


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:alexander.nozdrin@oracle.com-20101113155825-czmva9kg4n31anmu) (version source revid:alexander.nozdrin@oracle.com-20101113152450-2zzcm50e7i4j35v7) (merge vers: 5.6.1-m4) (pib:21)
[13 Nov 2010 16:42] Bugs System
Pushed into mysql-next-mr (revid:alexander.nozdrin@oracle.com-20101113160336-atmtmfb3mzm4pz4i) (version source revid:vasil.dimov@oracle.com-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

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:jonathan.perkin@oracle.com-20101216101358-fyzr1epq95a3yett) (version source revid:jonathan.perkin@oracle.com-20101216101358-fyzr1epq95a3yett) (merge vers: 5.5.9) (pib:24)