Bug #58798 SHOW ENGINE PERFORMANCE_SCHEMA STATUS: incorrect table lettercase
Submitted: 7 Dec 2010 19:39 Modified: 17 Dec 2010 16:47
Reporter: Paul Dubois Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Performance Schema Severity:S3 (Non-critical)
Version:5.5+ OS:Any
Assigned to: Marc Alff CPU Architecture:Any
Triage: Triaged: D4 (Minor)

[7 Dec 2010 19:39] Paul Dubois
Description:
As a result of Bug#57609 (in 5.5.8), performance_schema table names now are lowercase.

But SHOW ENGINE PERFORMANCE_SCHEMA STATUS still displays the table names in uppercase.

How to repeat:
mysql> SHOW ENGINE PERFORMANCE_SCHEMA STATUS\G
*************************** 1. row ***************************
  Type: performance_schema
  Name: EVENTS_WAITS_CURRENT.ROW_SIZE
Status: 136
*************************** 2. row ***************************
  Type: performance_schema
  Name: EVENTS_WAITS_CURRENT.ROW_COUNT
Status: 3000
*************************** 3. row ***************************
  Type: performance_schema
  Name: EVENTS_WAITS_HISTORY.ROW_SIZE
Status: 120
*************************** 4. row ***************************
  Type: performance_schema
  Name: EVENTS_WAITS_HISTORY.ROW_COUNT
Status: 10000
...

Suggested fix:
Table names should be lowercase.
[7 Dec 2010 19:47] Godofredo Miguel Solorzano
Thank you for the bug report.
[7 Dec 2010 20:01] 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/126262

3177 Marc Alff	2010-12-07
      Bug#58798 SHOW ENGINE PERFORMANCE_SCHEMA STATUS: incorrect table lettercase
      
      Before this fix, the output of SHOW ENGINE PERFORMANCE_SCHEMA STATUS
      used uppercase to name performance schema tables.
      
      This is inconsistent since performance schema tables have been renamed to lowercase.
      
      Also, an old table 'PROCESSLIST' was still visible, 
      even after this table got renamed to 'threads'.
      
      This fix:
      - correctly uses lowercases in the output, to match the current naming.
      - replaced 'PROCESSLIST' with 'threads'.
      
      Tested the output of SHOW ENGINE PERFORMANCE_SCHEMA STATUS manually.
      No automated test cases can be written for this, 
      since the output is too platform dependent (sizes).
[7 Dec 2010 20:19] Marc Alff
Approved by paul, discussed on IRC in #docs
[8 Dec 2010 5:40] Marc Alff
Pushed into:
- mysql-5.5-bugteam
- mysql-trunk-bugfixing
[17 Dec 2010 12:50] Bugs System
Pushed into mysql-5.5 5.5.9 (revid:georgi.kodinov@oracle.com-20101217124733-p1ivu6higouawv8l) (version source revid:marc.alff@oracle.com-20101207200033-gq17etcfrzskrlgr) (merge vers: 5.5.8) (pib:24)
[17 Dec 2010 12:54] Bugs System
Pushed into mysql-trunk 5.6.1 (revid:georgi.kodinov@oracle.com-20101217125013-y8pb3az32rtbplc9) (version source revid:anitha.gopi@sun.com-20101210041312-50t9adyhwwybsm6x) (merge vers: 5.6.1) (pib:24)
[17 Dec 2010 16:47] Paul Dubois
Cosmetic change, no changelog entry needed.