Debian Codegraph @

mysql-test/suite/innodb/r/xdes_fseg_frag.result

raw
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