Debian Codegraph @

mysql-test/suite/maria/maria-purge.result

raw
1 connect admin, localhost, root,,test,,;
2 connection default;
3 connection default;
4 connection admin;
5 * shut down mysqld, removed logs, restarted it
6 connection default;
7 set global default_storage_engine=aria;
8 set session default_storage_engine=aria;
9 set global aria_log_file_size=4294959104;
10 drop table if exists t1,t2;
11 SET SQL_WARNINGS=1;
12 CREATE TABLE t1 (
13 STRING_DATA char(255) default NULL
14 );
15 CREATE TABLE t2 (
16 STRING_DATA char(255) default NULL
17 );
18 INSERT INTO t1 VALUES ('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');
19 INSERT INTO t1 VALUES ('DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD');
20 insert into t2 select * from t1;
21 insert into t1 select * from t2;
22 insert into t2 select * from t1;
23 insert into t1 select * from t2;
24 insert into t2 select * from t1;
25 insert into t1 select * from t2;
26 insert into t2 select * from t1;
27 insert into t1 select * from t2;
28 insert into t2 select * from t1;
29 insert into t1 select * from t2;
30 insert into t2 select * from t1;
31 insert into t1 select * from t2;
32 insert into t2 select * from t1;
33 insert into t1 select * from t2;
34 insert into t2 select * from t1;
35 insert into t1 select * from t2;
36 insert into t2 select * from t1;
37 insert into t1 select * from t2;
38 insert into t2 select * from t1;
39 insert into t1 select * from t2;
40 insert into t2 select * from t1;
41 insert into t1 select * from t2;
42 set global aria_log_file_size=16777216;
43 set global aria_checkpoint_interval=30;
44 SHOW ENGINE aria logs;
45 Type Name Status
46 Aria aria_log.00000002 in use
47 insert into t2 select * from t1;
48 insert into t1 select * from t2;
49 set global aria_checkpoint_interval=30;
50 SHOW ENGINE aria logs;
51 Type Name Status
52 Aria aria_log.00000004 in use
53 set global aria_log_file_size=16777216;
54 select @@global.aria_log_file_size;
55 @@global.aria_log_file_size
56 16777216
57 set global aria_checkpoint_interval=30;
58 SHOW ENGINE aria logs;
59 Type Name Status
60 Aria aria_log.00000004 in use
61 set global aria_log_file_size=8388608;
62 select @@global.aria_log_file_size;
63 @@global.aria_log_file_size
64 8388608
65 set global aria_log_purge_type=at_flush;
66 insert into t1 select * from t2;
67 set global aria_checkpoint_interval=30;
68 SHOW ENGINE aria logs;
69 Type Name Status
70 Aria aria_log.00000004 free
71 Aria aria_log.00000005 free
72 Aria aria_log.00000006 free
73 Aria aria_log.00000007 free
74 Aria aria_log.00000008 in use
75 flush logs;
76 SHOW ENGINE aria logs;
77 Type Name Status
78 Aria aria_log.00000008 in use
79 set global aria_log_file_size=16777216;
80 set global aria_log_purge_type=external;
81 insert into t1 select * from t2;
82 set global aria_checkpoint_interval=30;
83 SHOW ENGINE aria logs;
84 Type Name Status
85 Aria aria_log.00000008 free
86 Aria aria_log.00000009 in use
87 flush logs;
88 SHOW ENGINE aria logs;
89 Type Name Status
90 Aria aria_log.00000008 free
91 Aria aria_log.00000009 in use
92 set global aria_log_purge_type=immediate;
93 insert into t1 select * from t2;
94 set global aria_checkpoint_interval=30;
95 SHOW ENGINE aria logs;
96 Type Name Status
97 Aria aria_log.00000011 in use
98 drop table t1, t2;