Debian Codegraph @

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

raw
1 SELECT COUNT(@@GLOBAL.innodb_doublewrite_batch_size);
2 COUNT(@@GLOBAL.innodb_doublewrite_batch_size)
3 1
4 1 Expected
5 SET @@GLOBAL.innodb_doublewrite_batch_size=1;
6 ERROR HY000: Variable 'innodb_doublewrite_batch_size' is a read only variable
7 Expected error 'Read only variable'
8 SELECT COUNT(@@GLOBAL.innodb_doublewrite_batch_size);
9 COUNT(@@GLOBAL.innodb_doublewrite_batch_size)
10 1
11 1 Expected
12 SELECT @@GLOBAL.innodb_doublewrite_batch_size = VARIABLE_VALUE
13 FROM performance_schema.global_variables
14 WHERE VARIABLE_NAME='innodb_doublewrite_batch_size';
15 @@GLOBAL.innodb_doublewrite_batch_size = VARIABLE_VALUE
16 1
17 1 Expected
18 SELECT COUNT(@@GLOBAL.innodb_doublewrite_batch_size);
19 COUNT(@@GLOBAL.innodb_doublewrite_batch_size)
20 1
21 1 Expected
22 SELECT COUNT(VARIABLE_VALUE)
23 FROM performance_schema.global_variables
24 WHERE VARIABLE_NAME='innodb_doublewrite_batch_size';
25 COUNT(VARIABLE_VALUE)
26 1
27 1 Expected
28 SELECT @@innodb_doublewrite_batch_size = @@GLOBAL.innodb_doublewrite_pages;
29 @@innodb_doublewrite_batch_size = @@GLOBAL.innodb_doublewrite_pages
30 0
31 0 Expected
32 SELECT COUNT(@@innodb_doublewrite_batch_size);
33 COUNT(@@innodb_doublewrite_batch_size)
34 1
35 1 Expected
36 SELECT COUNT(@@local.innodb_doublewrite_batch_size);
37 ERROR HY000: Variable 'innodb_doublewrite_batch_size' is a GLOBAL variable
38 Expected error 'Variable is a GLOBAL variable'
39 SELECT COUNT(@@SESSION.innodb_doublewrite_batch_size);
40 ERROR HY000: Variable 'innodb_doublewrite_batch_size' is a GLOBAL variable
41 Expected error 'Variable is a GLOBAL variable'
42 SELECT COUNT(@@GLOBAL.innodb_doublewrite_batch_size);
43 COUNT(@@GLOBAL.innodb_doublewrite_batch_size)
44 1
45 1 Expected
46 SELECT innodb_doublewrite_batch_size;
47 ERROR 42S22: Unknown column 'innodb_doublewrite_batch_size' in 'field list'
48 Expected error 'Unknown column'