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 Email Updates:
Status: Closed Impact on me:
None 
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:alik@sun.com-20100615080459-smuswd9ooeywcxuc) (version source revid:calvin.sun@oracle.com-20100422191614-2atswbilyyxep6rm) (merge vers: 5.1.47) (pib:16)
[15 Jun 2010 8:32] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100615080558-cw01bzdqr1bdmmec) (version source revid:calvin.sun@oracle.com-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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.