1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
| [root@t-luhx02-v-szzb employees]# /media/mysql/innblock titles.ibd 3 16 ---------------------------------------------------------------------------------------------------- Welcome to use this block analyze tool: [Author]:gaopeng [Blog]:blog.itpub.net/7728585/abstract/1/ [QQ]:22389860 [Review]:yejinrong@zhishutang [Blog]:imysql.com [QQ]:4700963 ---------------------------------------------------------------------------------------------------- ==== Block base info ==== block_no:3 space_id:49 index_id:73 slot_nums:3 heaps_rows:10 n_rows:8 heap_top:333 del_bytes:0 last_ins_offset:317 page_dir:2 page_n_dir:7 leaf_inode_space:49 leaf_inode_pag_no:2 leaf_inode_offset:242 no_leaf_inode_space:49 no_leaf_inode_pag_no:2 no_leaf_inode_offset:50 last_modify_lsn:294095967 page_type:B+_TREE level:1 ==== Block list info ==== -----Total used rows:10 used rows list(logic): (1) INFIMUM record offset:99 heapno:0 n_owned 1,delflag:N minflag:0 rectype:2 (2) normal record offset:127 heapno:2 n_owned 0,delflag:N minflag:1 rectype:1 (3) normal record offset:153 heapno:3 n_owned 0,delflag:N minflag:0 rectype:1 (4) normal record offset:179 heapno:4 n_owned 0,delflag:N minflag:0 rectype:1 (5) normal record offset:209 heapno:5 n_owned 4,delflag:N minflag:0 rectype:1 (6) normal record offset:235 heapno:6 n_owned 0,delflag:N minflag:0 rectype:1 (7) normal record offset:261 heapno:7 n_owned 0,delflag:N minflag:0 rectype:1 (8) normal record offset:291 heapno:8 n_owned 0,delflag:N minflag:0 rectype:1 (9) normal record offset:317 heapno:9 n_owned 0,delflag:N minflag:0 rectype:1 (10) SUPREMUM record offset:112 heapno:1 n_owned 5,delflag:N minflag:0 rectype:3 -----Total used rows:10 used rows list(phy): (1) INFIMUM record offset:99 heapno:0 n_owned 1,delflag:N minflag:0 rectype:2 (2) SUPREMUM record offset:112 heapno:1 n_owned 5,delflag:N minflag:0 rectype:3 (3) normal record offset:127 heapno:2 n_owned 0,delflag:N minflag:1 rectype:1 (4) normal record offset:153 heapno:3 n_owned 0,delflag:N minflag:0 rectype:1 (5) normal record offset:179 heapno:4 n_owned 0,delflag:N minflag:0 rectype:1 (6) normal record offset:209 heapno:5 n_owned 4,delflag:N minflag:0 rectype:1 (7) normal record offset:235 heapno:6 n_owned 0,delflag:N minflag:0 rectype:1 (8) normal record offset:261 heapno:7 n_owned 0,delflag:N minflag:0 rectype:1 (9) normal record offset:291 heapno:8 n_owned 0,delflag:N minflag:0 rectype:1 (10) normal record offset:317 heapno:9 n_owned 0,delflag:N minflag:0 rectype:1 -----Total del rows:0 del rows list(logic): -----Total slot:3 slot list: (1) SUPREMUM slot offset:112 n_owned:5 (2) normal record offset:209 n_owned:4 (3) INFIMUM slot offset:99 n_owned:1
|