baotiao/inno_space

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

inno_space's Issues

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下的案例

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 :)

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...

Support converting ibd file to sql

Support converting ibd file to sql

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 get information from system tablespace.

RT..

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

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

[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]#
没有打印出索引相关的信息。