Debian Codegraph @

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

raw
1 SELECT name, count
2 FROM information_schema.innodb_metrics
3 WHERE name = 'purge_stop_count' OR name = 'purge_resume_count';
4 name count
5 purge_stop_count 0
6 purge_resume_count 0
7 SET @orig = @@global.innodb_purge_run_now;
8 SELECT @orig;
9 @orig
10 0
11 SET GLOBAL innodb_purge_stop_now = ON;
12 SELECT name, count
13 FROM information_schema.innodb_metrics
14 WHERE name = 'purge_stop_count' OR name = 'purge_resume_count';
15 name count
16 purge_stop_count 1
17 purge_resume_count 0
18 SET GLOBAL innodb_purge_run_now = ON;
19 SELECT @@global.innodb_purge_run_now;
20 @@global.innodb_purge_run_now
21 0
22 SELECT name, count
23 FROM information_schema.innodb_metrics
24 WHERE name = 'purge_stop_count' OR name = 'purge_resume_count';
25 name count
26 purge_stop_count 1
27 purge_resume_count 1