Debian Codegraph @

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

raw
1 SET @start_innodb_buf_dump_status_frequency = @@global.innodb_buf_dump_status_frequency;
2 SELECT @start_innodb_buf_dump_status_frequency;
3 @start_innodb_buf_dump_status_frequency
4 0
5 SELECT COUNT(@@global.innodb_buf_dump_status_frequency);
6 COUNT(@@global.innodb_buf_dump_status_frequency)
7 1
8 SET @@global.innodb_buf_dump_status_frequency = 20;
9 SELECT @@global.innodb_buf_dump_status_frequency;
10 @@global.innodb_buf_dump_status_frequency
11 20
12 SET @@global.innodb_buf_dump_status_frequency = 0;
13 SELECT @@global.innodb_buf_dump_status_frequency;
14 @@global.innodb_buf_dump_status_frequency
15 0
16 SET @@global.innodb_buf_dump_status_frequency = 100;
17 SELECT @@global.innodb_buf_dump_status_frequency;
18 @@global.innodb_buf_dump_status_frequency
19 100
20 SET @@global.innodb_buf_dump_status_frequency = -1;
21 Warnings:
22 Warning 1292 Truncated incorrect innodb_buf_dump_status_frequency value: '-1'
23 SELECT @@global.innodb_buf_dump_status_frequency;
24 @@global.innodb_buf_dump_status_frequency
25 0
26 SET @@global.innodb_buf_dump_status_frequency = 101;
27 Warnings:
28 Warning 1292 Truncated incorrect innodb_buf_dump_status_frequency value: '101'
29 SELECT @@global.innodb_buf_dump_status_frequency;
30 @@global.innodb_buf_dump_status_frequency
31 100
32 SET @@global.innodb_buf_dump_status_frequency = 10.5;
33 ERROR 42000: Incorrect argument type to variable 'innodb_buf_dump_status_frequency'
34 SELECT @@global.innodb_buf_dump_status_frequency;
35 @@global.innodb_buf_dump_status_frequency
36 100
37 SET @@global.innodb_buf_dump_status_frequency = "abc";
38 ERROR 42000: Incorrect argument type to variable 'innodb_buf_dump_status_frequency'
39 SELECT @@global.innodb_buf_dump_status_frequency;
40 @@global.innodb_buf_dump_status_frequency
41 100
42 SET @@global.innodb_buf_dump_status_frequency = @start_innodb_buf_dump_status_frequency;