Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
11.0.2
Description
We upgraded our MariaDB instance from 10.4 to 11.0.2 and from this time our ibdata1 file started to grow in size by ~17GB per day.
We are currently using MariaDB 11.0.2 with Galera. Our datadir size 2.2TB. We have innodb_file_per_table turned ON and we also used innodbchecksum tool to investigate what’s going on in ibdata - it looks like everything is filled with undo logs, please see here:
"checksum.txt" 61L, 1654B 1,0-1 All
|
|
|
File::ibdata1
|
================PAGE TYPE SUMMARY==============
|
#PAGE_COUNT PAGE_TYPE
|
===============================================
|
1180 Index page
|
17935695 Undo log page
|
63539 Inode page
|
568 Insert buffer free list page
|
8206274 Freshly allocated page
|
1600 Insert buffer bitmap
|
152 System page
|
1 Transaction system page
|
1 File Space Header
|
1614 Extent descriptor page
|
0 BLOB page
|
0 Compressed BLOB page
|
0 Page compressed page
|
0 Page compressed encrypted page
|
0 Other type of page
|
|
|
===============================================
|
Additional information:
|
Undo page type: 17935695
|
Undo page state: 0 active, 120 cached, 5406344 to_purge, 0 prepared, 12529231 other
|
index_id #pages #leaf_pages #recs_per_page #bytes_per_page
|
1 3 2 104 9109
|
2 17 16 146 9702
|
3 6 5 130 10167
|
4 5 4 187 8241
|
5 1 1 320 13725
|
11 1 1 0 0
|
12 1 1 0 0
|
13 1 1 0 0
|
14 1 1 0 0
|
15 3 2 98 5783
|
16 1 0 2 32
|
17 1 1 0 0
|
1046 3 3 760 11410
|
1047 9 9 816 12251
|
1106 3 3 1126 15071
|
63258842 29 29 526 8101
|
|
|
index_id page_data_bytes_histgram(empty,...,oversized)
|
1 0 1 0 0 0 0 0 0 1 1 0 0
|
2 0 1 0 0 1 3 2 5 3 1 1 0
|
3 0 1 0 0 0 0 0 1 3 1 0 0
|
4 0 1 0 0 0 1 0 1 2 0 0 0
|
5 0 0 0 0 0 0 0 0 0 1 0 0
|
11 1 0 0 0 0 0 0 0 0 0 0 0
|
12 1 0 0 0 0 0 0 0 0 0 0 0
|
13 1 0 0 0 0 0 0 0 0 0 0 0
|
14 1 0 0 0 0 0 0 0 0 0 0 0
|
15 0 1 0 0 0 1 1 0 0 0 0 0
|
16 0 1 0 0 0 0 0 0 0 0 0 0
|
17 1 0 0 0 0 0 0 0 0 0 0 0
|
1046 0 0 0 0 0 0 1 0 2 0 0 0
|
1047 0 0 0 0 0 0 1 3 2 1 2 0
|
1106 0 0 0 0 0 0 0 0 0 1 2 0
|
63258842 0 0 0 0 0 24 5 0 0 0 0 0
|
-4294967296 0 0 0 0 0 0 0 0 0 0 0 0
|
~
|
~
|
~
|
It looks like purging of undo logs is not working at all.
This could be still related to: MDEV-31234
