Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_ddl_buffer_size_basic.test

raw
1 #
2 # Show the global and session values.
3 #
4 SELECT @@global.innodb_ddl_buffer_size;
5 SELECT @@session.innodb_ddl_buffer_size;
6
7 SHOW GLOBAL VARIABLES LIKE 'innodb_ddl_buffer_size';
8 SHOW SESSION VARIABLES LIKE 'innodb_ddl_buffer_size';
9
10 SELECT * FROM performance_schema.global_variables
11 WHERE variable_name='innodb_ddl_buffer_size';
12
13 SELECT * FROM performance_schema.session_variables
14 WHERE variable_name='innodb_ddl_buffer_size';
15
16 #
17 # Set min value - 1
18 #
19 set global innodb_ddl_buffer_size=65535;
20 set session innodb_ddl_buffer_size=65535;
21
22 # Set the minimum value.
23 set global innodb_ddl_buffer_size=65536;
24 set session innodb_ddl_buffer_size=65536;
25
26 SELECT * FROM performance_schema.global_variables
27 WHERE variable_name='innodb_ddl_buffer_size';
28
29 SELECT * FROM performance_schema.session_variables
30 WHERE variable_name='innodb_ddl_buffer_size';
31
32 # Set max value + 1.
33 set global innodb_ddl_buffer_size=4294967297;
34 set session innodb_ddl_buffer_size=4294967297;
35
36 # Set the max value
37 set global innodb_ddl_buffer_size=4294967295;
38 set session innodb_ddl_buffer_size=4294967295;
39
40 SELECT * FROM performance_schema.global_variables
41 WHERE variable_name='innodb_ddl_buffer_size';
42
43 SELECT * FROM performance_schema.session_variables
44 WHERE variable_name='innodb_ddl_buffer_size';
45
46 # Set to the default value
47 set global innodb_ddl_buffer_size=1048576;
48 set session innodb_ddl_buffer_size=1048576;
49
50 SELECT * FROM performance_schema.global_variables
51 WHERE variable_name='innodb_ddl_buffer_size';
52
53 SELECT * FROM performance_schema.session_variables
54 WHERE variable_name='innodb_ddl_buffer_size';
55
56