Debian Codegraph @

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

raw
1 #######################################################################
2 # Innodb Buffer Pool Resize Status Codes
3 #
4 # Print status codes that can be seen when resize is in progress. We
5 # have a debug variable for each status code. The resize thread will
6 # wait on the debug variable corresponding to the current status code.
7 # This will allow the test to synchronize with the resize thread.
8 #######################################################################
9 #######################################################################
10 # Set all the debug variables and unset them after the query
11 #######################################################################
12 #######################################################################
13 # Query status code when no resize is in progress:
14 #######################################################################
15 SELECT variable_name, variable_value FROM
16 performance_schema.global_status WHERE LOWER(variable_name) LIKE
17 'innodb_buffer_pool_resize_status%';
18 variable_name variable_value
19 Innodb_buffer_pool_resize_status
20 Innodb_buffer_pool_resize_status_code 0
21 Innodb_buffer_pool_resize_status_progress 0
22 #######################################################################
23 # Trigger the resize operation to 4 times chunk size
24 #######################################################################
25 SET GLOBAL innodb_buffer_pool_size = @prev_size + 4 * 25165824;
26 #######################################################################
27 # BUF_POOL_RESIZE_START (1)
28 #######################################################################
29 SELECT variable_name, variable_value FROM
30 performance_schema.global_status WHERE LOWER(variable_name) LIKE
31 'innodb_buffer_pool_resize_status%';
32 variable_name variable_value
33 Innodb_buffer_pool_resize_status Resizing buffer pool from 25165824 to 125829120 (unit=25165824).
34 Innodb_buffer_pool_resize_status_code 1
35 Innodb_buffer_pool_resize_status_progress 100
36 SET GLOBAL debug = "-d,ib_buf_pool_resize_start_status_code";
37 #######################################################################
38 # BUF_POOL_RESIZE_DISABLE_AHI (2)
39 #######################################################################
40 SELECT variable_name, variable_value FROM
41 performance_schema.global_status WHERE LOWER(variable_name) LIKE
42 'innodb_buffer_pool_resize_status%';
43 variable_name variable_value
44 Innodb_buffer_pool_resize_status Disabling adaptive hash index.
45 Innodb_buffer_pool_resize_status_code 2
46 Innodb_buffer_pool_resize_status_progress 100
47 SET GLOBAL debug = "-d,ib_buf_pool_resize_disable_ahi_status_code";
48 #######################################################################
49 # BUF_POOL_RESIZE_WITHDRAW_BLOCKS (3)
50 #######################################################################
51 SELECT variable_name, variable_value FROM
52 performance_schema.global_status WHERE LOWER(variable_name) LIKE
53 'innodb_buffer_pool_resize_status%';
54 variable_name variable_value
55 Innodb_buffer_pool_resize_status Withdrawing blocks to be shrunken.
56 Innodb_buffer_pool_resize_status_code 3
57 Innodb_buffer_pool_resize_status_progress 100
58 SET GLOBAL debug = "-d,ib_buf_pool_resize_withdraw_blocks_status_code";
59 #######################################################################
60 # BUF_POOL_RESIZE_GLOBAL_LOCK (4)
61 #######################################################################
62 SELECT variable_name, variable_value FROM
63 performance_schema.global_status WHERE LOWER(variable_name) LIKE
64 'innodb_buffer_pool_resize_status%';
65 variable_name variable_value
66 Innodb_buffer_pool_resize_status Latching whole of buffer pool.
67 Innodb_buffer_pool_resize_status_code 4
68 Innodb_buffer_pool_resize_status_progress 100
69 SET GLOBAL debug = "-d,ib_buf_pool_resize_global_lock_status_code";
70 #######################################################################
71 # BUF_POOL_RESIZE_IN_PROGRESS (5)
72 #######################################################################
73 SELECT variable_name, variable_value FROM
74 performance_schema.global_status WHERE LOWER(variable_name) LIKE
75 'innodb_buffer_pool_resize_status%';
76 variable_name variable_value
77 Innodb_buffer_pool_resize_status buffer pool 0 : resizing with chunks 1 to 5.
78 Innodb_buffer_pool_resize_status_code 5
79 Innodb_buffer_pool_resize_status_progress 100
80 SET GLOBAL debug = "-d,ib_buf_pool_resize_in_progress_status_code";
81 #######################################################################
82 # BUF_POOL_RESIZE_HASH (6)
83 #######################################################################
84 SELECT variable_name, variable_value FROM
85 performance_schema.global_status WHERE LOWER(variable_name) LIKE
86 'innodb_buffer_pool_resize_status%';
87 variable_name variable_value
88 Innodb_buffer_pool_resize_status Resizing also other hash tables.
89 Innodb_buffer_pool_resize_status_code 6
90 Innodb_buffer_pool_resize_status_progress 100
91 SET GLOBAL debug = "-d,ib_buf_pool_resize_hash_status_code";
92 #######################################################################
93 # BUF_POOL_RESIZE_COMPLETE (0) (exclude message as it has timestamp)
94 #######################################################################
95 SELECT variable_name, variable_value FROM
96 performance_schema.global_status WHERE LOWER(variable_name) LIKE
97 'innodb_buffer_pool_resize_status_%';
98 variable_name variable_value
99 Innodb_buffer_pool_resize_status_code 0
100 Innodb_buffer_pool_resize_status_progress 100
101 SET GLOBAL debug = "-d,ib_buf_pool_resize_complete_status_code";
102 #######################################################################
103 # Trigger a resize that will fail
104 #######################################################################
105 # restart: --innodb-buffer-pool-instances=2 --innodb-buffer-pool-size=1G
106 SET GLOBAL innodb_buffer_pool_size = @prev_size + 4 * 25165824;
107 Warnings:
108 Warning 1292 Truncated incorrect innodb_buffer_pool_size value: '0'
109 Warning 1210 Cannot update innodb_buffer_pool_size to less than 1GB if innodb_buffer_pool_instances > 1.
110 #######################################################################
111 # BUF_POOL_RESIZE_FAILED (7)
112 #######################################################################
113 SELECT variable_name, variable_value FROM
114 performance_schema.global_status WHERE LOWER(variable_name) LIKE
115 'innodb_buffer_pool_resize_status%';
116 variable_name variable_value
117 Innodb_buffer_pool_resize_status Failed to validate requested buffer pool size.
118 Innodb_buffer_pool_resize_status_code 7
119 Innodb_buffer_pool_resize_status_progress 100
120 SET GLOBAL debug = "-d,ib_buf_pool_resize_failed_status_code";
121 #######################################################################
122 # CLEAN UP
123 #######################################################################
124 # Reset back to previous state
125 # restart