Hallo,
I would like to know, how much of my system table space (idbata) is filled.
After some googling, I found a modified version about innochecksum. But I don't know how to handle the modified C-file. After that I found the innodb_ruby application, which is quite similar to innochecksum.
So I have the possibility to get a page-type-summary like
https://dev.mysql.com/doc/refman/5.7/en/innochecksum.html#option_innochecksum_page-type-summary
But I can't interprate the results. So could someone tell me, which types are good/wrong and how to calculate the used/free size of the system table space.
Two servers - two different results
type count percent description
UNDO_LOG 13540 84.62 Undo log
INDEX 1479 9.24 B+Tree index
IBUF_FREE_LIST 639 3.99 Insert buffer free list
ALLOCATED 166 1.04 Freshly allocated
SYS 163 1.02 System internal
INODE 9 0.06 File segment inode
TRX_SYS 2 0.01 Transaction system header
IBUF_BITMAP 1 0.01 Insert buffer bitmap
FSP_HDR 1 0.01 File space header
type count percent description
ALLOCATED 49064 74.87 Freshly allocated
UNDO_LOG 14202 21.67 Undo log
INDEX 1849 2.82 B+Tree index
IBUF_FREE_LIST 212 0.32 Insert buffer free list
SYS 134 0.20 System internal
INODE 56 0.09 File segment inode
BLOB 14 0.02 Uncompressed BLOB
IBUF_BITMAP 2 0.00 Insert buffer bitmap
TRX_SYS 1 0.00 Transaction system header
FSP_HDR 1 0.00 File space header
XDES 1 0.00 Extent descriptor
best regards
Christian