MySQL Forums
Forum List  »  InnoDB

Posted by: Christian Molecki
Date: January 19, 2017 07:43AM


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

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

Options: ReplyQuote

Written By
January 19, 2017 07:43AM

Sorry, you can't reply to this topic. It has been closed.

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.