Bug #64115 | Wrong values for the NUMBER_PAGES_CREATED and NUMBER_PAGES_WRITTEN columns | ||
---|---|---|---|
Submitted: | 23 Jan 2012 19:56 | Modified: | 16 Jul 2012 22:53 |
Reporter: | Davi Arnaut (OCA) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S3 (Non-critical) |
Version: | 5.6 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | INNODB_BUFFER_POOL_STATS |
[23 Jan 2012 19:56]
Davi Arnaut
[23 Jan 2012 21:46]
Davi Arnaut
Also, it is worth renaming IDX_BUF_STATS_PENDING_ZIP to IDX_BUF_STATS_PENDING_UNZIP.
[24 Jan 2012 5:07]
Valeriy Kravchuk
Thank you for the bug report. Verified just as described: ... mysql> insert into test.tinno(c2) select c2 from test.tinno; Query OK, 4096 rows affected (0.72 sec) Records: 4096 Duplicates: 0 Warnings: 0 mysql> select number_pages_written from innodb_buffer_pool_stats; +----------------------+ | number_pages_written | +----------------------+ | 31 | +----------------------+ 1 row in set (0.00 sec) mysql> select number_pages_written from innodb_buffer_pool_stats; +----------------------+ | number_pages_written | +----------------------+ | 0 | +----------------------+ 1 row in set (0.00 sec)
[16 Jul 2012 22:53]
John Russell
Added to changelog for 5.6.7, 5.7.0: The value of the NUMBER_PAGES_CREATED and NUMBER_PAGES_WRITTEN columns of the INFORMATION_SCHEMA.INNODB_BUFFER_POOL_STATS table were set to incorrect values, and the NUMBER_PAGES_GET column was not being set at all.