Bug #72423 buffer_pool_pages_data larger than buffer_pool_pages_total

Submitted: 22 Apr 2014 18:01 Modified: 17 Jul 2014 22:13
Reporter: Shlomi Noach (OCA) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.6.17-log OS:Linux
Assigned to: CPU Architecture:Any
Tags: buffer pool, flushing, innodb

[22 Apr 2014 18:01] Shlomi Noach
Description:
While trying to figure out why I have excessive flushing on InnoDB (if you're interested, please read: http://code.openark.org/blog/mysql/the-mystery-of-mysql-5-6-excessive-buffer-pool-flushing), I issued the following:

mysql> select name, count from INNODB_METRICS where name like '%buff%pool%page%';
+-------------------------+----------+
| name                    | count    |
+-------------------------+----------+
| buffer_pool_pages_total |  3014627 |
| buffer_pool_pages_misc  | -1808588 |
| buffer_pool_pages_data  |  4822230 |
| buffer_pool_pages_dirty |   488383 |
| buffer_pool_pages_free  |      985 |
+-------------------------+----------+

The buffer_pool_pages_total makes sense: innodb_buffer_pool_size=49392123904, innodb_page_size=16384. 49392123904/16384 = 3014656 which is roughly 3014627 buffer_pool_pages_total above.

buffer_pool_pages_data does NOT make sense since it is larger (and substantially so) than buffer_pool_pages_total,
and of course buffer_pool_pages_misc is invalid.

How to repeat:
Not sure, but this happens on all 6 servers upgraded from 5.5 to 5.6 without any configuration changes.

Suggested fix:
all values must be non-negative.
[23 Apr 2014 6:34] Shane Bester
Do you have compressed barracuda tables?
Also:  http://bugs.mysql.com/bug.php?id=59550
[23 Apr 2014 7:26] Shlomi Noach
I do. ROW_FORMAT=COMPRESSED, key block size is default (8)
[17 Jul 2014 22:13] Sveta Smirnova
Thank you for the feedback.

Closed as duplicate of bug #59550

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

Page generated in 0.051 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.