Debian Codegraph @

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

raw
1 select @@global.max_binlog_total_size;
2 @@global.max_binlog_total_size
3 0
4 select @@session.max_binlog_total_size;
5 ERROR HY000: Variable 'max_binlog_total_size' is a GLOBAL variable
6 show global variables like 'max_binlog_total_size';
7 Variable_name Value
8 max_binlog_total_size 0
9 show session variables like 'max_binlog_total_size';
10 Variable_name Value
11 max_binlog_total_size 0
12 select * from information_schema.global_variables where variable_name='max_binlog_total_size';
13 VARIABLE_NAME VARIABLE_VALUE
14 MAX_BINLOG_TOTAL_SIZE 0
15 select * from information_schema.session_variables where variable_name='max_binlog_total_size';
16 VARIABLE_NAME VARIABLE_VALUE
17 MAX_BINLOG_TOTAL_SIZE 0
18 set global max_binlog_total_size=1;
19 select @@global.max_binlog_total_size, @@global.binlog_space_limit;
20 @@global.max_binlog_total_size @@global.binlog_space_limit
21 1 1
22 set global max_binlog_total_size=1;
23 select @@global.max_binlog_total_size;
24 @@global.max_binlog_total_size
25 1
26 set global binlog_space_limit=2;
27 select @@global.max_binlog_total_size, @@global.binlog_space_limit;
28 @@global.max_binlog_total_size @@global.binlog_space_limit
29 2 2
30 set session max_binlog_total_size=1;
31 ERROR HY000: Variable 'max_binlog_total_size' is a GLOBAL variable and should be set with SET GLOBAL
32 set global max_binlog_total_size=default;
33 CREATE USER user1@localhost;
34 connect con2,localhost,user1,,;
35 set global max_binlog_total_size=1;
36 ERROR 42000: Access denied; you need (at least one of) the BINLOG ADMIN privilege(s) for this operation
37 set global binlog_space_limit=1;
38 ERROR 42000: Access denied; you need (at least one of) the BINLOG ADMIN privilege(s) for this operation
39 disconnect con2;
40 connection default;
41 DROP USER user1@localhost;