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