percona-discussion team mailing list archive
-
percona-discussion team
-
Mailing list archive
-
Message #00600
[Bug 378472] [NEW] big DATASIZE for some pages in INNODB_BUFFER_POOL_CONTENT
Public bug reported:
Every now and then I see big DATASIZEs while with default innodb page
size they should not exceed 16k. On i386 FreeBSD server the number seems
to be close to max unsigned long:
mysql> SELECT * FROM INNODB_BUFFER_POOL_CONTENT WHERE PAGE_TYPE = 'index' and TABLE_SCHEMA = 'db1' and TABLE_NAME = 'tbl1' and datasize > 16384 limit 10;
+-----------+-------+----------+---------+------------+------------+-----------+--------------+--------------+-----------+------------+--------------+------------+
| BLOCK_NUM | SPACE | OFFSET | RECORDS | DATASIZE | FLUSH_TYPE | FIX_COUNT | LRU_POSITION | PAGE_TYPE_ID | PAGE_TYPE | INDEX_NAME | TABLE_SCHEMA | TABLE_NAME |
+-----------+-------+----------+---------+------------+------------+-----------+--------------+--------------+-----------+------------+--------------+------------+
| 14029 | 25 | 17644660 | 16707 | 4294945826 | 3 | 0 | 76222025 | 17855 | index | PRIMARY | db1 | tbl1 |
| 21404 | 25 | 17644658 | 17231 | 4294936884 | 3 | 0 | 76222776 | 17855 | index | PRIMARY | db1 | tbl1 |
| 23391 | 26 | 66590 | 10794 | 4294956397 | 3 | 0 | 76235969 | 17855 | index | PRIMARY | db1 | tbl1 |
| 53404 | 25 | 17644456 | 16707 | 4294945826 | 3 | 0 | 76222772 | 17855 | index | PRIMARY | db1 | tbl1 |
| 81410 | 25 | 17644458 | 17231 | 4294936884 | 3 | 0 | 76222013 | 17855 | index | PRIMARY | db1 | tbl1 |
| 86737 | 26 | 62049 | 10794 | 4294956397 | 3 | 0 | 76237508 | 17855 | index | stats2 | db1 | tbl1 |
+-----------+-------+----------+---------+------------+------------+-----------+--------------+--------------+-----------+------------+--------------+------------+
While on x86_64 Linux it's more of a max singed long long:
mysql> select * from INNODB_BUFFER_POOL_CONTENT where datasize > 16384 limit 10;
+-----------+-------+---------+---------+---------------------+------------+-----------+--------------+--------------+-----------+------------+--------------+------------+
| BLOCK_NUM | SPACE | OFFSET | RECORDS | DATASIZE | FLUSH_TYPE | FIX_COUNT | LRU_POSITION | PAGE_TYPE_ID | PAGE_TYPE | INDEX_NAME | TABLE_SCHEMA | TABLE_NAME |
+-----------+-------+---------+---------+---------------------+------------+-----------+--------------+--------------+-----------+------------+--------------+------------+
| 778 | 1876 | 1416380 | 55159 | 9223372036854775807 | 3 | 0 | 3925504831 | 17855 | index | | | |
| 1781 | 1896 | 228399 | 21736 | 9223372036854775807 | 1 | 0 | 3924750985 | 17855 | index | | | |
| 1874 | 1876 | 1426130 | 32520 | 9223372036854775807 | 1 | 0 | 3924244005 | 17855 | index | | | |
| 4781 | 1876 | 1426438 | 28930 | 9223372036854775807 | 3 | 0 | 3924244254 | 17855 | index | | | |
| 7311 | 1916 | 552912 | 4305 | 9223372036854775807 | 1 | 0 | 3924278326 | 17855 | index | | | |
| 8003 | 1877 | 377518 | 14017 | 9223372036854775807 | 1 | 0 | 3925350688 | 17855 | index | | | |
| 8607 | 1916 | 527248 | 26275 | 9223372036854775807 | 1 | 0 | 3924194551 | 17855 | index | | | |
| 9277 | 1916 | 519166 | 22802 | 9223372036854775807 | 1 | 0 | 3924174158 | 17855 | index | | | |
| 9882 | 1887 | 969032 | 49579 | 9223372036854775807 | 1 | 0 | 3925556148 | 17855 | index | | | |
| 11944 | 1876 | 1405841 | 2217 | 9223372036854775807 | 1 | 0 | 3924352272 | 17855 | index | | | |
+-----------+-------+---------+---------+---------------------+------------+-----------+--------------+--------------+-----------+------------+--------------+------------+
10 rows in set (8.19 sec)
Linux server is running 5.0.75-percona-highperf-b13-log. FreeBSD server
is running 5.0.77 with slightly modified b13 patches. (Modified only to
compile and work on FreeBSD). Not sure how to reproduce, but all servers
I checked had at least few records with big datasize.
** Affects: percona-patches
Importance: Undecided
Status: New
--
big DATASIZE for some pages in INNODB_BUFFER_POOL_CONTENT
https://bugs.launchpad.net/bugs/378472
You received this bug notification because you are a member of Percona
developers, which is the registrant for Percona patches.
Status in Patches for MySQL by Percona: New
Bug description:
Every now and then I see big DATASIZEs while with default innodb page size they should not exceed 16k. On i386 FreeBSD server the number seems to be close to max unsigned long:
mysql> SELECT * FROM INNODB_BUFFER_POOL_CONTENT WHERE PAGE_TYPE = 'index' and TABLE_SCHEMA = 'db1' and TABLE_NAME = 'tbl1' and datasize > 16384 limit 10;
+-----------+-------+----------+---------+------------+------------+-----------+--------------+--------------+-----------+------------+--------------+------------+
| BLOCK_NUM | SPACE | OFFSET | RECORDS | DATASIZE | FLUSH_TYPE | FIX_COUNT | LRU_POSITION | PAGE_TYPE_ID | PAGE_TYPE | INDEX_NAME | TABLE_SCHEMA | TABLE_NAME |
+-----------+-------+----------+---------+------------+------------+-----------+--------------+--------------+-----------+------------+--------------+------------+
| 14029 | 25 | 17644660 | 16707 | 4294945826 | 3 | 0 | 76222025 | 17855 | index | PRIMARY | db1 | tbl1 |
| 21404 | 25 | 17644658 | 17231 | 4294936884 | 3 | 0 | 76222776 | 17855 | index | PRIMARY | db1 | tbl1 |
| 23391 | 26 | 66590 | 10794 | 4294956397 | 3 | 0 | 76235969 | 17855 | index | PRIMARY | db1 | tbl1 |
| 53404 | 25 | 17644456 | 16707 | 4294945826 | 3 | 0 | 76222772 | 17855 | index | PRIMARY | db1 | tbl1 |
| 81410 | 25 | 17644458 | 17231 | 4294936884 | 3 | 0 | 76222013 | 17855 | index | PRIMARY | db1 | tbl1 |
| 86737 | 26 | 62049 | 10794 | 4294956397 | 3 | 0 | 76237508 | 17855 | index | stats2 | db1 | tbl1 |
+-----------+-------+----------+---------+------------+------------+-----------+--------------+--------------+-----------+------------+--------------+------------+
While on x86_64 Linux it's more of a max singed long long:
mysql> select * from INNODB_BUFFER_POOL_CONTENT where datasize > 16384 limit 10;
+-----------+-------+---------+---------+---------------------+------------+-----------+--------------+--------------+-----------+------------+--------------+------------+
| BLOCK_NUM | SPACE | OFFSET | RECORDS | DATASIZE | FLUSH_TYPE | FIX_COUNT | LRU_POSITION | PAGE_TYPE_ID | PAGE_TYPE | INDEX_NAME | TABLE_SCHEMA | TABLE_NAME |
+-----------+-------+---------+---------+---------------------+------------+-----------+--------------+--------------+-----------+------------+--------------+------------+
| 778 | 1876 | 1416380 | 55159 | 9223372036854775807 | 3 | 0 | 3925504831 | 17855 | index | | | |
| 1781 | 1896 | 228399 | 21736 | 9223372036854775807 | 1 | 0 | 3924750985 | 17855 | index | | | |
| 1874 | 1876 | 1426130 | 32520 | 9223372036854775807 | 1 | 0 | 3924244005 | 17855 | index | | | |
| 4781 | 1876 | 1426438 | 28930 | 9223372036854775807 | 3 | 0 | 3924244254 | 17855 | index | | | |
| 7311 | 1916 | 552912 | 4305 | 9223372036854775807 | 1 | 0 | 3924278326 | 17855 | index | | | |
| 8003 | 1877 | 377518 | 14017 | 9223372036854775807 | 1 | 0 | 3925350688 | 17855 | index | | | |
| 8607 | 1916 | 527248 | 26275 | 9223372036854775807 | 1 | 0 | 3924194551 | 17855 | index | | | |
| 9277 | 1916 | 519166 | 22802 | 9223372036854775807 | 1 | 0 | 3924174158 | 17855 | index | | | |
| 9882 | 1887 | 969032 | 49579 | 9223372036854775807 | 1 | 0 | 3925556148 | 17855 | index | | | |
| 11944 | 1876 | 1405841 | 2217 | 9223372036854775807 | 1 | 0 | 3924352272 | 17855 | index | | | |
+-----------+-------+---------+---------+---------------------+------------+-----------+--------------+--------------+-----------+------------+--------------+------------+
10 rows in set (8.19 sec)
Linux server is running 5.0.75-percona-highperf-b13-log. FreeBSD server is running 5.0.77 with slightly modified b13 patches. (Modified only to compile and work on FreeBSD). Not sure how to reproduce, but all servers I checked had at least few records with big datasize.
Follow ups
References