Debian Codegraph @

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

raw
1 SELECT @@global.innodb_buffer_pool_dump_pct;
2 @@global.innodb_buffer_pool_dump_pct
3 25
4 SET GLOBAL innodb_buffer_pool_dump_pct=20;
5 SELECT @@global.innodb_buffer_pool_dump_pct;
6 @@global.innodb_buffer_pool_dump_pct
7 20
8 SET GLOBAL innodb_buffer_pool_dump_pct=1;
9 SELECT @@global.innodb_buffer_pool_dump_pct;
10 @@global.innodb_buffer_pool_dump_pct
11 1
12 SET GLOBAL innodb_buffer_pool_dump_pct=100;
13 SELECT @@global.innodb_buffer_pool_dump_pct;
14 @@global.innodb_buffer_pool_dump_pct
15 100
16 SET GLOBAL innodb_buffer_pool_dump_pct=101;
17 Warnings:
18 Warning 1292 Truncated incorrect innodb_buffer_pool_dump_pct value: '101'
19 SELECT @@global.innodb_buffer_pool_dump_pct;
20 @@global.innodb_buffer_pool_dump_pct
21 100
22 SET GLOBAL innodb_buffer_pool_dump_pct=-1;
23 Warnings:
24 Warning 1292 Truncated incorrect innodb_buffer_pool_dump_pct value: '-1'
25 SELECT @@global.innodb_buffer_pool_dump_pct;
26 @@global.innodb_buffer_pool_dump_pct
27 1
28 SET GLOBAL innodb_buffer_pool_dump_pct=Default;
29 SELECT @@global.innodb_buffer_pool_dump_pct;
30 @@global.innodb_buffer_pool_dump_pct
31 25
32 SET GLOBAL innodb_buffer_pool_dump_pct='foo';
33 ERROR 42000: Incorrect argument type to variable 'innodb_buffer_pool_dump_pct'
34 SET innodb_buffer_pool_dump_pct=50;
35 ERROR HY000: Variable 'innodb_buffer_pool_dump_pct' is a GLOBAL variable and should be set with SET GLOBAL