baotiao/inno_space

Inno_space is a command-line tool designed for direct access to InnoDB (.ibd) files.

inno_space's Issues

support get information from system tablespace.

RT..

Support removing a specified page from the index

It would be helpful if this tool supports removing a specified page from the index. we can use it as an
emergency data repair tool for some extreme error, like data corruption...

您好，我尝试在5.7的版本使用dump-all-records，似乎没有任何反应

Support converting ibd file to sql

Support converting ibd file to sql

mysql 8.0.35似乎无法使用show-records和dump-all-records

我尝试使用了show-records和dump-all-records，都无法读取表中的记录。是不兼容吗？我的命令是
./inno -f /var/lib/mysql/db01/t1.ibd -c show-records -p 3 -s /root/t1.json

t1表示单独创建的，没有使用tools下的案例

你好，文件解析有些问题，请帮忙看看。

[root@aaaaa inno_space-main]# ./inno -f ../project.ibd -c list-page-type
File path ../project.ibd path, page num 0
==========================Space Header==========================
Space ID: 7233
Highest Page number: 768
Free limit Page Number: 384
FREE_FRAG page number: 6
Next Seg ID: 7
==========================space page type==========================
File size 12582912
start end count type
0 0 1 FSP HDR
1 1 1 INSERT BUFFER BITMAP
2 2 1 INDEX NODE PAGE
3 213 211 INDEX PAGE
214 255 42 FRESHLY ALLOCATED PAGE
256 260 5 INDEX PAGE
261 261 1 SDI INDEX PAGE
262 319 58 FRESHLY ALLOCATED PAGE
320 320 1 INDEX PAGE
321 767 446 FRESHLY ALLOCATED PAGE
[root@aaaaa inno_space-main]# ./inno -f ../project.ibd -c index-summary
File path ../project.ibd path, page num 0
==========================Space Header==========================
Space ID: 7233
Highest Page number: 768
Free limit Page Number: 384
FREE_FRAG page number: 6
Next Seg ID: 7
Suggestion
File size 12582912, reserved but not used space 0, percentage 0.00%
Optimize table will get new fie size 12582912
[root@aaaaa inno_space-main]#
没有打印出索引相关的信息。

support estimate the ibd size after optimize table

support estimate the ibd size after optimize table..
Then we can make a decision to whether to optimize table.

Support parse undo log and dump more information

RT

show record details in specify page like innodb_space page-dump

like innodb_space example:

$ innodb_space -s ibdata1 -T innodb/t1 -p 3 page-dump
...
records:
{:format=>:compact,
 :offset=>127,
 :header=>
  {:next=>263,
   :type=>:conventional,
   :heap_number=>2,
   :n_owned=>0,
   :min_rec=>false,
   :deleted=>false,
   :nulls=>[],
   :lengths=>{"c2"=>36, "c3"=>72},
   :externs=>[],
   :length=>7},
 :next=>263,
 :type=>:clustered,
 :key=>[{:name=>"id", :type=>"INT UNSIGNED", :value=>1}],
 :row=>
  [{:name=>"c1", :type=>"INT UNSIGNED", :value=>777},
   {:name=>"c2",
    :type=>"VARCHAR(400)",
    :value=>"a1c1a7c7-bda5-11e9-8476-0050568bba82"},
   {:name=>"c3",
    :type=>"VARCHAR(400)",
    :value=>
     "a1c1a7c7-bda5-11e9-8476-0050568bba82a1c1aec5-bda5-11e9-8476-0050568bba82"}],
 :sys=>
  [{:name=>"DB_TRX_ID", :type=>"TRX_ID", :value=>10950},
   {:name=>"DB_ROLL_PTR",
    :type=>"ROLL_PTR",
    :value=>
     {:is_insert=>true,
      :rseg_id=>119,
      :undo_log=>{:page=>469, :offset=>272}}}],
 :length=>129,
 :transaction_id=>10950,
 :roll_pointer=>
  {:is_insert=>true, :rseg_id=>119, :undo_log=>{:page=>469, :offset=>272}}}

best regards :)