Skip to content

Instantly share code, notes, and snippets.

@kysnm

kysnm/gist:70fef1ca4792d5602100 Secret

Created December 20, 2015 14:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kysnm/70fef1ca4792d5602100 to your computer and use it in GitHub Desktop.
Save kysnm/70fef1ca4792d5602100 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
➜ innodb_ruby_test git:(master) ✗ bundle exec innodb_space -f innodb_ruby_test/users.ibd space-page-type-regions
start end count type
0 0 1 FSP_HDR
1 1 1 IBUF_BITMAP
2 2 1 INODE
3 649 647 INDEX
650 703 54 FREE (ALLOCATED)
704 741 38 INDEX
742 767 26 FREE (ALLOCATED)
768 859 92 INDEX
860 895 36 FREE (ALLOCATED)
896 1102 207 INDEX
1103 1151 49 FREE (ALLOCATED)
➜ innodb_ruby_test git:(master) ✗ bundle exec innodb_space -f innodb_ruby_test/users.ibd space-indexes
id name root fseg used allocated fill_factor
36749 3 internal 1 1 100.00%
36749 3 leaf 618 672 91.96%
36750 36 internal 1 1 100.00%
36750 36 leaf 124 160 77.50%
36751 709 internal 1 1 100.00%
36751 709 leaf 239 288 82.99%
➜ innodb_ruby_test git:(master) ✗ bundle exec innodb_space -f innodb_ruby_test/users.ibd -p 3 page-dump > page-dump-without-describer.txt
➜ innodb_ruby_test git:(master) ✗ bundle exec innodb_space -f innodb_ruby_test/users.ibd -p 3 -r innodb_ruby_test_db.rb -d InnodbRubyTest_users_state page-dump > page-dump-with-state-describer.txt
➜ innodb_ruby_test git:(master) ✗ bundle exec innodb_space -f innodb_ruby_test/users.ibd -p 3 -r innodb_ruby_test_db.rb -d InnodbRubyTest_users_PRIMARY page-dump > page-dump-with-primary-describer.txt
➜ innodb_ruby_test git:(master) ✗ bundle exec innodb_space -f innodb_ruby_test/users.ibd space-index-pages-summary | head -n 10
page index level data free records
3 36749 1 8652 7294 618
4 36749 0 7442 8770 81
5 36749 0 15134 1040 163
6 36749 0 15092 1082 162
7 36749 0 15081 1093 161
8 36749 0 15105 1069 161
9 36749 0 15144 1030 163
10 36749 0 15081 1095 159
11 36749 0 15111 1063 161
➜ innodb_ruby_test git:(master) ✗ bundle exec innodb_space -f innodb_ruby_test/users.ibd -p 3 -r innodb_ruby_test_db.rb -d InnodbRubyTest_users_PRIMARY index-recurse > index-recurse-with-primary-describer.txt
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment