| 1 |
SET GLOBAL innodb_fast_shutdown=0; |
| 2 |
# restart |
| 3 |
CREATE TABLE t1 (f1 SERIAL, f2 char(200), f3 char(200)); |
| 4 |
set debug='+d,fil_space_print_xdes_pages'; |
| 5 |
start transaction; |
| 6 |
insert into t1(f2, f3) values (repeat('~', 200), repeat('/', 200)); |
| 7 |
commit; |
| 8 |
set debug='-d,fil_space_print_xdes_pages'; |
| 9 |
drop table t1; |
| 10 |
[Extent Descriptor Page: page_no=0 |
| 11 |
|
| 12 |
[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]]] |
| 13 |
|
| 14 |
[xdes_t: segid=0,page=0,state=XDES_FREE_FRAG,bitmap=[+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++.................................................................................................]] |
| 15 |
|
| 16 |
[xdes_t: segid=4,page=256,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 17 |
|
| 18 |
[xdes_t: segid=4,page=512,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 19 |
|
| 20 |
[xdes_t: segid=4,page=768,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 21 |
|
| 22 |
[xdes_t: segid=4,page=1024,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 23 |
|
| 24 |
[xdes_t: segid=4,page=1280,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 25 |
|
| 26 |
[xdes_t: segid=4,page=1536,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 27 |
|
| 28 |
[xdes_t: segid=4,page=1792,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 29 |
|
| 30 |
[xdes_t: segid=4,page=2048,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 31 |
|
| 32 |
[xdes_t: segid=4,page=2304,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 33 |
|
| 34 |
[xdes_t: segid=4,page=2560,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 35 |
|
| 36 |
[xdes_t: segid=4,page=2816,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 37 |
|
| 38 |
[xdes_t: segid=4,page=3072,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 39 |
|
| 40 |
[xdes_t: segid=4,page=3328,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 41 |
|
| 42 |
[xdes_t: segid=4,page=3584,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 43 |
|
| 44 |
[xdes_t: segid=4,page=3840,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 45 |
|
| 46 |
] |
| 47 |
|
| 48 |
[Extent Descriptor Page: page_no=4096 |
| 49 |
|
| 50 |
[xdes_t: segid=4,page=4096,state=XDES_FSEG_FRAG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 51 |
|
| 52 |
[xdes_t: segid=4,page=4352,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 53 |
|
| 54 |
[xdes_t: segid=4,page=4608,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 55 |
|
| 56 |
[xdes_t: segid=4,page=4864,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 57 |
|
| 58 |
[xdes_t: segid=4,page=5120,state=XDES_FSEG,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 59 |
|
| 60 |
[xdes_t: segid=4,page=5376,state=XDES_FSEG,bitmap=[+...............................................................................................................................................................................................................................................................]] |
| 61 |
|
| 62 |
[xdes_t: segid=0,page=5632,state=XDES_FREE,bitmap=[................................................................................................................................................................................................................................................................]] |
| 63 |
|
| 64 |
[xdes_t: segid=0,page=5888,state=XDES_NOT_INITED,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 65 |
|
| 66 |
[xdes_t: segid=0,page=6144,state=XDES_NOT_INITED,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 67 |
|
| 68 |
[xdes_t: segid=0,page=6400,state=XDES_NOT_INITED,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 69 |
|
| 70 |
[xdes_t: segid=0,page=6656,state=XDES_NOT_INITED,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 71 |
|
| 72 |
[xdes_t: segid=0,page=6912,state=XDES_NOT_INITED,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 73 |
|
| 74 |
[xdes_t: segid=0,page=7168,state=XDES_NOT_INITED,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 75 |
|
| 76 |
[xdes_t: segid=0,page=7424,state=XDES_NOT_INITED,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 77 |
|
| 78 |
[xdes_t: segid=0,page=7680,state=XDES_NOT_INITED,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 79 |
|
| 80 |
[xdes_t: segid=0,page=7936,state=XDES_NOT_INITED,bitmap=[++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++]] |
| 81 |
|
| 82 |
] |
| 83 |
|