Debian Codegraph @

mysql-test/suite/maria/maria-no-logging.result

raw
1 set global aria_log_file_size=4294959104;
2 drop database if exists mysqltest;
3 create database mysqltest;
4 connect admin, localhost, root,,mysqltest,,;
5 connection default;
6 use mysqltest;
7 set global aria_checkpoint_interval=0;
8 create table t2 (a varchar(100)) engine=myisam;
9 insert into t2 select repeat('z',100);
10 insert into t2 select * from t2;
11 insert into t2 select * from t2;
12 insert into t2 select * from t2;
13 insert into t2 select * from t2;
14 insert into t2 select * from t2;
15 insert into t2 select * from t2;
16 connection default;
17 connection admin;
18 * shut down mysqld, removed logs, restarted it
19 connection default;
20 create table t1 (a varchar(100)) engine=aria transactional=1;
21 show create table t1;
22 Table Create Table
23 t1 CREATE TABLE `t1` (
24 `a` varchar(100) DEFAULT NULL
25 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1
26 show engine aria logs;
27 Type Name Status
28 Aria Size 16384 aria_log.00000001 unknown
29 insert into t1 values('a');
30 insert into t1 select * from t2;
31 show engine aria logs;
32 Type Name Status
33 Aria Size 24576 aria_log.00000001 unknown
34 select count(*) from t1;
35 count(*)
36 65
37 connection default;
38 connection admin;
39 * shut down mysqld, removed logs, restarted it
40 connection default;
41 truncate table t1;
42 insert into t1 select * from t2;
43 show engine aria logs;
44 Type Name Status
45 Aria Size 16384 aria_log.00000001 unknown
46 select count(*) from t1;
47 count(*)
48 64
49 drop table t1;
50 connection default;
51 connection admin;
52 * shut down mysqld, removed logs, restarted it
53 connection default;
54 create table t1 (a varchar(100)) engine=aria transactional=1;
55 insert into t1 values('a');
56 create table if not exists t1 select * from t2;
57 Warnings:
58 Note 1050 Table 't1' already exists
59 show engine aria logs;
60 Type Name Status
61 Aria Size 16384 aria_log.00000001 unknown
62 connection default;
63 connection admin;
64 * shut down mysqld, removed logs, restarted it
65 connection default;
66 drop table t1;
67 create table t1 engine=aria transactional=1 select * from t2;
68 show engine aria logs;
69 Type Name Status
70 Aria Size 16384 aria_log.00000001 unknown
71 drop database mysqltest;