1
set global maria_log_file_size=4294967295;
2
drop database if exists mysqltest;
3
create database mysqltest;
5
set global maria_checkpoint_interval=0;
6
create table t2 (a varchar(100)) engine=myisam;
7
insert into t2 select repeat('z',100);
8
insert into t2 select * from t2;
9
insert into t2 select * from t2;
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
* shut down mysqld, removed logs, restarted it
15
create table t1 (a varchar(100)) engine=maria transactional=1;
18
t1 CREATE TABLE `t1` (
19
`a` varchar(100) DEFAULT NULL
20
) ENGINE=MARIA DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=1
21
show engine maria logs;
23
MARIA Size 16384 maria_log.00000001 unknown
24
insert into t1 values('a');
25
insert into t1 select * from t2;
26
show engine maria logs;
28
MARIA Size 24576 maria_log.00000001 unknown
29
* shut down mysqld, removed logs, restarted it
31
insert into t1 select * from t2;
32
show engine maria logs;
34
MARIA Size 16384 maria_log.00000001 unknown
36
* shut down mysqld, removed logs, restarted it
37
create table t1 (a varchar(100)) engine=maria transactional=1;
38
insert into t1 values('a');
39
create table if not exists t1 select * from t2;
41
Note 1050 Table 't1' already exists
42
show engine maria logs;
44
MARIA Size 24576 maria_log.00000001 unknown
45
* shut down mysqld, removed logs, restarted it
47
create table t1 engine=maria transactional=1 select * from t2;
48
show engine maria logs;
50
MARIA Size 16384 maria_log.00000001 unknown
51
drop database mysqltest;