1
# test of cases where we can safely disable logging
3
--source include/have_maria.inc
4
# can't restart server in embedded
5
--source include/not_embedded.inc
7
set global maria_log_file_size=4294967295;
10
drop database if exists mysqltest;
12
create database mysqltest;
14
connect (admin, localhost, root,,mysqltest,,);
21
# checkpoints can make log unrepeatable
22
let $def_checkinterval=`select @@global.maria_checkpoint_interval`;
23
set global maria_checkpoint_interval=0;
25
# Prepare table to help for big load
26
create table t2 (a varchar(100)) engine=myisam;
27
insert into t2 select repeat('z',100);
28
insert into t2 select * from t2;
29
insert into t2 select * from t2;
30
insert into t2 select * from t2;
31
insert into t2 select * from t2;
32
insert into t2 select * from t2;
33
insert into t2 select * from t2;
37
# no optimization because table not empty
39
# SHOW ENGINE MARIA LOGS could be influenced by older logs
40
-- source include/maria_empty_logs.inc
41
create table t1 (a varchar(100)) engine=maria transactional=1;
43
--replace_regex /; .+maria_log/maria_log/
44
show engine maria logs;
46
insert into t1 values('a');
47
insert into t1 select * from t2;
48
--replace_regex /; .+maria_log/maria_log/
49
show engine maria logs;
51
# optimization because table is empty
52
-- source include/maria_empty_logs.inc
54
insert into t1 select * from t2;
55
--replace_regex /; .+maria_log/maria_log/
56
show engine maria logs;
60
# same for CREATE SELECT
62
# no optimization because table not empty
63
-- source include/maria_empty_logs.inc
64
create table t1 (a varchar(100)) engine=maria transactional=1;
65
insert into t1 values('a');
66
create table if not exists t1 select * from t2;
67
--replace_regex /; .+maria_log/maria_log/
68
show engine maria logs;
70
# optimization because table is empty
71
-- source include/maria_empty_logs.inc
73
create table t1 engine=maria transactional=1 select * from t2;
74
--replace_regex /; .+maria_log/maria_log/
75
show engine maria logs;
77
drop database mysqltest;
81
eval set global maria_checkpoint_interval=$def_checkinterval;