Bug #53566 SHOW ENGINE PERFORMANCE_SCHEMA STATUS reports less memory than really used
Submitted: 11 May 2010 13:20 Modified: 4 Aug 2010 20:09
Reporter: Marc Alff Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Performance Schema Severity:S3 (Non-critical)
Version:5.5.3-m3, 5.5.4-m3 OS:Any
Assigned to: Marc Alff
Triage: Triaged: D2 (Serious)

[11 May 2010 13:20] Marc Alff
Description:
SHOW ENGINE PERFORMANCE_SCHEMA STATUS
reports
PERFORMANCE_SCHEMA.MEMORY
for the total memory used.

The count returned is missing memory for PFS_FILE_HANDLE

How to repeat:
Read the code

Suggested fix:
Count the total allocated memory, and add an assert to make sure
everything allocated is also reported.
[11 May 2010 14:19] 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/107974

3175 Marc Alff	2010-05-11
      Bug#53566 SHOW ENGINE PERFORMANCE_SCHEMA STATUS reports less memory than really used
      
      Prior to this fix, the statement
        SHOW ENGINE PERFORMANCE_SCHEMA STATUS
      would report less memory that really allocated by the performance schema.
      
      With this fix:
      - memory usage is now reported accurately
      - an assert enforces that everything allocated internally 
        is reported, to avoid future discrepancies.
      
      No test script needed, as the existing scripts in the test suite
      provide coverage when using a debug binary (with asserts).
[12 May 2010 18:17] Christopher Powers
Changes look good. Ok to push.
[13 May 2010 14:19] Marc Alff
pushed into:
- mysql-next-mr-bugfixing
- mysql-6.0-codebase-bugfixing
[20 May 2010 10:04] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100520100225-oe4iuu5kuzsx0knq) (version source revid:alik@sun.com-20100520100057-rmn5y3o3ij726bm7) (merge vers: 6.0.14-alpha) (pib:16)
[20 May 2010 10:06] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100520100140-5bzrtadw4w419i3m) (version source revid:alik@sun.com-20100520100049-1njm09rkvnhmysnr) (pib:16)
[20 May 2010 15:23] Paul Dubois
Noted in 6.0.14 changelog.

SHOW ENGINE PERFORMANCE_SCHEMA STATUS underreported the amount of
memory allocated by Performance Schema.
[15 Jul 2010 23:27] Marc Alff
This bug is tagged SRGAQUAL,SR55RC,
but the fix is only present in mysql-next-mr (5.6).

Changing to "need merge" to merge the fix in mysql-trunk (5.5)
[15 Jul 2010 23:29] 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/113715

3115 Marc Alff	2010-07-15
      Bug#53566 SHOW ENGINE PERFORMANCE_SCHEMA STATUS reports less memory than really used
      
      Backporting the fix from myql-next-mr (5.6) to mysql-trunk (5.5)
[16 Jul 2010 0:34] Marc Alff
Pushed into mysql-trunk-bugfixing (5.5.6)
[22 Jul 2010 16:13] Paul Dubois
Noted in 5.5.6 changelog.
[23 Jul 2010 12:22] Bugs System
Pushed into mysql-trunk 5.5.6-m3 (revid:alik@sun.com-20100723121820-jryu2fuw3pc53q9w) (version source revid:vasil.dimov@oracle.com-20100531152341-x2d4hma644icamh1) (merge vers: 5.5.5-m3) (pib:18)
[23 Jul 2010 12:29] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100723121929-90e9zemk3jkr2ocy) (version source revid:vasil.dimov@oracle.com-20100531152341-x2d4hma644icamh1) (pib:18)
[4 Aug 2010 8:02] Bugs System
Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804080001-bny5271e65xo34ig) (version source revid:alik@sun.com-20100520123900-5kadc9fvcxz30s75) (merge vers: 5.6.99-m4) (pib:18)
[4 Aug 2010 8:18] Bugs System
Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804081533-c1d3rbipo9e8rt1s) (version source revid:alik@sun.com-20100520123900-5kadc9fvcxz30s75) (merge vers: 5.6.99-m4) (pib:18)
[4 Aug 2010 20:09] Paul Dubois
Bug is not present in any released 5.6.x version.