Debian Codegraph @

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

raw
1 SET @orig = @@global.innodb_buffer_pool_dump_pct;
2 SELECT @orig;
3 @orig
4 25
5 SET GLOBAL innodb_buffer_pool_dump_pct=3;
6 # Do the dump
7 SELECT @@global.innodb_buffer_pool_dump_now;
8 SELECT variable_value INTO @old_dump_status FROM information_schema.global_status
9 WHERE LOWER(variable_name) = 'innodb_buffer_pool_dump_status';
10 SET GLOBAL innodb_buffer_pool_dump_now = ON;
11 SELECT @@global.innodb_buffer_pool_dump_now;
12 SET GLOBAL innodb_buffer_pool_dump_pct=20;
13 SELECT @@global.innodb_buffer_pool_dump_pct;
14 @@global.innodb_buffer_pool_dump_pct
15 20
16 SET GLOBAL innodb_buffer_pool_dump_pct=1;
17 SELECT @@global.innodb_buffer_pool_dump_pct;
18 @@global.innodb_buffer_pool_dump_pct
19 1
20 SET GLOBAL innodb_buffer_pool_dump_pct=100;
21 SELECT @@global.innodb_buffer_pool_dump_pct;
22 @@global.innodb_buffer_pool_dump_pct
23 100
24 SET GLOBAL innodb_buffer_pool_dump_pct=101;
25 Warnings:
26 Warning 1292 Truncated incorrect innodb_buffer_pool_dump_pct value: '101'
27 SELECT @@global.innodb_buffer_pool_dump_pct;
28 @@global.innodb_buffer_pool_dump_pct
29 100
30 SET GLOBAL innodb_buffer_pool_dump_pct=-1;
31 Warnings:
32 Warning 1292 Truncated incorrect innodb_buffer_pool_dump_pct value: '-1'
33 SELECT @@global.innodb_buffer_pool_dump_pct;
34 @@global.innodb_buffer_pool_dump_pct
35 1
36 SET GLOBAL innodb_buffer_pool_dump_pct=Default;
37 SELECT @@global.innodb_buffer_pool_dump_pct;
38 @@global.innodb_buffer_pool_dump_pct
39 25
40 SET GLOBAL innodb_buffer_pool_dump_pct='foo';
41 ERROR 42000: Incorrect argument type to variable 'innodb_buffer_pool_dump_pct'
42 SET innodb_buffer_pool_dump_pct=50;
43 ERROR HY000: Variable 'innodb_buffer_pool_dump_pct' is a GLOBAL variable and should be set with SET GLOBAL
44 SET GLOBAL innodb_buffer_pool_dump_pct=@orig;