Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_ddl_buffer_size_basic.result

raw
1 SELECT @@global.innodb_ddl_buffer_size;
2 @@global.innodb_ddl_buffer_size
3 1048576
4 SELECT @@session.innodb_ddl_buffer_size;
5 @@session.innodb_ddl_buffer_size
6 1048576
7 SHOW GLOBAL VARIABLES LIKE 'innodb_ddl_buffer_size';
8 Variable_name Value
9 innodb_ddl_buffer_size 1048576
10 SHOW SESSION VARIABLES LIKE 'innodb_ddl_buffer_size';
11 Variable_name Value
12 innodb_ddl_buffer_size 1048576
13 SELECT * FROM performance_schema.global_variables
14 WHERE variable_name='innodb_ddl_buffer_size';
15 VARIABLE_NAME VARIABLE_VALUE
16 innodb_ddl_buffer_size 1048576
17 SELECT * FROM performance_schema.session_variables
18 WHERE variable_name='innodb_ddl_buffer_size';
19 VARIABLE_NAME VARIABLE_VALUE
20 innodb_ddl_buffer_size 1048576
21 set global innodb_ddl_buffer_size=65535;
22 Warnings:
23 Warning 1292 Truncated incorrect innodb_ddl_buffer_size value: '65535'
24 set session innodb_ddl_buffer_size=65535;
25 Warnings:
26 Warning 1292 Truncated incorrect innodb_ddl_buffer_size value: '65535'
27 set global innodb_ddl_buffer_size=65536;
28 set session innodb_ddl_buffer_size=65536;
29 SELECT * FROM performance_schema.global_variables
30 WHERE variable_name='innodb_ddl_buffer_size';
31 VARIABLE_NAME VARIABLE_VALUE
32 innodb_ddl_buffer_size 65536
33 SELECT * FROM performance_schema.session_variables
34 WHERE variable_name='innodb_ddl_buffer_size';
35 VARIABLE_NAME VARIABLE_VALUE
36 innodb_ddl_buffer_size 65536
37 set global innodb_ddl_buffer_size=4294967297;
38 Warnings:
39 Warning 1292 Truncated incorrect innodb_ddl_buffer_size value: '4294967297'
40 set session innodb_ddl_buffer_size=4294967297;
41 Warnings:
42 Warning 1292 Truncated incorrect innodb_ddl_buffer_size value: '4294967297'
43 set global innodb_ddl_buffer_size=4294967295;
44 set session innodb_ddl_buffer_size=4294967295;
45 SELECT * FROM performance_schema.global_variables
46 WHERE variable_name='innodb_ddl_buffer_size';
47 VARIABLE_NAME VARIABLE_VALUE
48 innodb_ddl_buffer_size 4294967295
49 SELECT * FROM performance_schema.session_variables
50 WHERE variable_name='innodb_ddl_buffer_size';
51 VARIABLE_NAME VARIABLE_VALUE
52 innodb_ddl_buffer_size 4294967295
53 set global innodb_ddl_buffer_size=1048576;
54 set session innodb_ddl_buffer_size=1048576;
55 SELECT * FROM performance_schema.global_variables
56 WHERE variable_name='innodb_ddl_buffer_size';
57 VARIABLE_NAME VARIABLE_VALUE
58 innodb_ddl_buffer_size 1048576
59 SELECT * FROM performance_schema.session_variables
60 WHERE variable_name='innodb_ddl_buffer_size';
61 VARIABLE_NAME VARIABLE_VALUE
62 innodb_ddl_buffer_size 1048576