Bug #52983 innodb_(buffer_pool_pages_total|buffer_pool_pages_misc) units have gone wrong

• Submitted: 20 Apr 2010 12:58
• Modified: 30 Jun 2010 19:42
• Reporter: Vasil Dimov
• Status: Closed
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 5.5
• OS: Any
• Assigned to: John Russell
• CPU Architecture: Any

[20 Apr 2010 12:58] Vasil Dimov

Description:
This part of the multiple buffer pool patch has got it wrong:

-       export_vars.innodb_buffer_pool_pages_total = buf_pool->curr_size;
+       export_vars.innodb_buffer_pool_pages_total = buf_pool_get_curr_size();

-       export_vars.innodb_buffer_pool_pages_misc = buf_pool->curr_size
-               - UT_LIST_GET_LEN(buf_pool->LRU)
-               - UT_LIST_GET_LEN(buf_pool->free);
+       export_vars.innodb_buffer_pool_pages_misc = buf_pool_get_curr_size();

(in srv/srv0srv.c)

buf_pool_get_curr_size() returns the size in bytes, not pages.

innodb_buffer_pool_pages_misc should not be the same as innodb_buffer_pool_pages_total.

How to repeat:
SELECT variable_value FROM information_schema.global_status WHERE LOWER(variable_name) = 'innodb_buffer_pool_pages_total';

[30 Apr 2010 10:57] 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/107061

3044 Sunny Bains	2010-04-30
      Fix Bug#52983.

[30 Apr 2010 11:00] 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/107062

3045 Sunny Bains	2010-04-30
      Fix Bug#52983.

[15 Jun 2010 8:15] Bugs System

Pushed into 5.5.5-m3 (revid:[e-mail]-20100615080459-smuswd9ooeywcxuc) (version source revid:[e-mail]-20100422191614-2atswbilyyxep6rm) (merge vers: 5.1.47) (pib:16)

[15 Jun 2010 8:32] Bugs System

Pushed into mysql-next-mr (revid:[e-mail]-20100615080558-cw01bzdqr1bdmmec) (version source revid:[e-mail]-20100422191614-2atswbilyyxep6rm) (pib:16)

[30 Jun 2010 19:42] John Russell

Text for the change log:

The value of innodb_buffer_pool_pages_total
in the information_schema.global_status table
could be computed incorrectly.