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
• Status: Closed
• Category: MySQL Server: Performance Schema
• Severity: S3 (Non-critical)
• Version: 5.5.3-m3, 5.5.4-m3
• OS: Any
• Assigned to: Marc ALFF
• CPU Architecture: Any

[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:[e-mail]-20100520100225-oe4iuu5kuzsx0knq) (version source revid:[e-mail]-20100520100057-rmn5y3o3ij726bm7) (merge vers: 6.0.14-alpha) (pib:16)

[20 May 2010 10:06] Bugs System

Pushed into mysql-next-mr (revid:[e-mail]-20100520100140-5bzrtadw4w419i3m) (version source revid:[e-mail]-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:[e-mail]-20100723121820-jryu2fuw3pc53q9w) (version source revid:[e-mail]-20100531152341-x2d4hma644icamh1) (merge vers: 5.5.5-m3) (pib:18)

[23 Jul 2010 12:29] Bugs System

Pushed into mysql-next-mr (revid:[e-mail]-20100723121929-90e9zemk3jkr2ocy) (version source revid:[e-mail]-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:[e-mail]-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:[e-mail]-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.