84 lines
11 KiB
Plaintext
84 lines
11 KiB
Plaintext
SET GLOBAL innodb_fast_shutdown=0;
|
|
# restart
|
|
CREATE TABLE t1 (f1 SERIAL, f2 char(200), f3 char(200));
|
|
set debug='+d,fil_space_print_xdes_pages';
|
|
start transaction;
|
|
insert into t1(f2, f3) values (repeat('~', 200), repeat('/', 200));
|
|
commit;
|
|
set debug='-d,fil_space_print_xdes_pages';
|
|
drop table t1;
|
|
[Extent Descriptor Page: page_no=0
|
|
|
|
[fsp_header_t: m_space_id=N, m_fsp_size=7168, m_free_limit=5888, m_flags=16609, m_fsp_frag_n_used=159, m_fsp_free=[flst_base_node_t: len=1, first=[fil_addr_t: page=4096, boffset=686], last=[fil_addr_t: page=4096, boffset=686]], m_free_frag=[flst_base_node_t: len=1, first=[fil_addr_t: page=0, boffset=158], last=[fil_addr_t: page=0, boffset=158]], m_full_frag=[flst_base_node_t: len=0, first=[fil_addr_t: page=4294967295, boffset=0], last=[fil_addr_t: page=4294967295, boffset=0]], m_segid=5, m_inodes_full=[flst_base_node_t: len=0, first=[fil_addr_t: page=4294967295, boffset=0], last=[fil_addr_t: page=4294967295, boffset=0]], m_inodes_free=[flst_base_node_t: len=1, first=[fil_addr_t: page=2, boffset=38], last=[fil_addr_t: page=2, boffset=38]]]
|
|
|
|
[xdes_t: segid=0,page=0,state=XDES_FREE_FRAG,bitmap=[+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++.................................................................................................]]
|
|
|
|
[xdes_t: segid=4,page=256,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=4,page=512,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=4,page=768,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=4,page=1024,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=4,page=1280,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=4,page=1536,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=4,page=1792,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=4,page=2048,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=4,page=2304,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=4,page=2560,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=4,page=2816,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=4,page=3072,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=4,page=3328,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=4,page=3584,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=4,page=3840,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
]
|
|
|
|
[Extent Descriptor Page: page_no=4096
|
|
|
|
[xdes_t: segid=4,page=4096,state=XDES_FSEG_FRAG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=4,page=4352,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=4,page=4608,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=4,page=4864,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=4,page=5120,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=4,page=5376,state=XDES_FSEG,bitmap=[+...............................................................................................................................................................................................................................................................]]
|
|
|
|
[xdes_t: segid=0,page=5632,state=XDES_FREE,bitmap=[................................................................................................................................................................................................................................................................]]
|
|
|
|
[xdes_t: segid=0,page=5888,state=XDES_NOT_INITED,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=0,page=6144,state=XDES_NOT_INITED,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=0,page=6400,state=XDES_NOT_INITED,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=0,page=6656,state=XDES_NOT_INITED,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=0,page=6912,state=XDES_NOT_INITED,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=0,page=7168,state=XDES_NOT_INITED,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=0,page=7424,state=XDES_NOT_INITED,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=0,page=7680,state=XDES_NOT_INITED,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
[xdes_t: segid=0,page=7936,state=XDES_NOT_INITED,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]]
|
|
|
|
]
|
|
|