MySQL Forums :: InnoDB :: innochecksum/innodb_ruby


Advanced Search

innochecksum/innodb_ruby
Posted by: Christian Molecki ()
Date: January 19, 2017 07:43AM

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

Options: ReplyQuote


Subject Views Written By Posted
innochecksum/innodb_ruby 228 Christian Molecki 01/19/2017 07:43AM


Sorry, only registered users may post in this forum.

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.