Debian Codegraph @

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

raw
1 '#---------------------BS_STVARS_033_01----------------------#'
2 SELECT COUNT(@@GLOBAL.innodb_log_buffer_size);
3 COUNT(@@GLOBAL.innodb_log_buffer_size)
4 1
5 1 Expected
6 '#---------------------BS_STVARS_033_02----------------------#'
7 Invalid value
8 SET GLOBAL innodb_log_buffer_size = -1;
9 Warnings:
10 Warning 1292 Truncated incorrect innodb_log_buffer_size value: '-1'
11 SELECT @@innodb_log_buffer_size;
12 @@innodb_log_buffer_size
13 262144
14 Invalid value
15 SET GLOBAL innodb_log_buffer_size = 0;
16 Warnings:
17 Warning 1292 Truncated incorrect innodb_log_buffer_size value: '0'
18 SELECT @@innodb_log_buffer_size;
19 @@innodb_log_buffer_size
20 262144
21 Too small value
22 SET GLOBAL innodb_log_buffer_size = 1;
23 Warnings:
24 Warning 1292 Truncated incorrect innodb_log_buffer_size value: '1'
25 SELECT @@innodb_log_buffer_size;
26 @@innodb_log_buffer_size
27 262144
28 SELECT COUNT(@@GLOBAL.innodb_log_buffer_size);
29 COUNT(@@GLOBAL.innodb_log_buffer_size)
30 1
31 1 Expected
32 '#---------------------BS_STVARS_033_03----------------------#'
33 SELECT @@GLOBAL.innodb_log_buffer_size = VARIABLE_VALUE
34 FROM performance_schema.global_variables
35 WHERE VARIABLE_NAME='innodb_log_buffer_size';
36 @@GLOBAL.innodb_log_buffer_size = VARIABLE_VALUE
37 1
38 1 Expected
39 SELECT COUNT(@@GLOBAL.innodb_log_buffer_size);
40 COUNT(@@GLOBAL.innodb_log_buffer_size)
41 1
42 1 Expected
43 SELECT COUNT(VARIABLE_VALUE)
44 FROM performance_schema.global_variables
45 WHERE VARIABLE_NAME='innodb_log_buffer_size';
46 COUNT(VARIABLE_VALUE)
47 1
48 1 Expected
49 '#---------------------BS_STVARS_033_04----------------------#'
50 SELECT @@innodb_log_buffer_size = @@GLOBAL.innodb_log_buffer_size;
51 @@innodb_log_buffer_size = @@GLOBAL.innodb_log_buffer_size
52 1
53 1 Expected
54 '#---------------------BS_STVARS_033_05----------------------#'
55 SELECT COUNT(@@innodb_log_buffer_size);
56 COUNT(@@innodb_log_buffer_size)
57 1
58 1 Expected
59 SELECT COUNT(@@local.innodb_log_buffer_size);
60 ERROR HY000: Variable 'innodb_log_buffer_size' is a GLOBAL variable
61 Expected error 'Variable is a GLOBAL variable'
62 SELECT COUNT(@@SESSION.innodb_log_buffer_size);
63 ERROR HY000: Variable 'innodb_log_buffer_size' is a GLOBAL variable
64 Expected error 'Variable is a GLOBAL variable'
65 SELECT COUNT(@@GLOBAL.innodb_log_buffer_size);
66 COUNT(@@GLOBAL.innodb_log_buffer_size)
67 1
68 1 Expected
69 SELECT innodb_log_buffer_size;
70 ERROR 42S22: Unknown column 'innodb_log_buffer_size' in 'field list'
71 SELECT @@innodb_log_buffer_size;
72 @@innodb_log_buffer_size
73 262144
74 SET GLOBAL innodb_log_buffer_size = 1024*1024;
75 SELECT @@innodb_log_buffer_size;
76 @@innodb_log_buffer_size
77 1048576
78 SET GLOBAL innodb_log_buffer_size = 256*1024;
79 SELECT @@innodb_log_buffer_size;
80 @@innodb_log_buffer_size
81 262144
82 SET GLOBAL innodb_log_buffer_size = 2048*1024;
83 SELECT @@innodb_log_buffer_size;
84 @@innodb_log_buffer_size
85 2097152
86 SET @@GLOBAL.innodb_log_buffer_size=16777216;
87 SELECT @@innodb_log_buffer_size;
88 @@innodb_log_buffer_size
89 16777216