Debian Codegraph @

mysql-test/suite/maria/aria_log_dir_path.result

raw
1 #
2 # MDEV-30971 Add a new system variable aria_data_home_dir
3 #
4 # restart: --loose-aria-log-file-size=8388608 --loose-aria-log-dir-path=MYSQLTEST_VARDIR/tmp/aria_log_dir_path_1
5 SET @@global.aria_log_purge_type=external;
6 SHOW VARIABLES LIKE 'aria_log_file_size';
7 Variable_name Value
8 aria_log_file_size 8388608
9 SELECT @@aria_log_dir_path;
10 @@aria_log_dir_path
11 MYSQLTEST_VARDIR/tmp/aria_log_dir_path_1
12 SET @@global.aria_checkpoint_interval=DEFAULT /*Force checkpoint*/;
13 SHOW ENGINE aria logs;
14 Type Name Status
15 Aria aria_log.00000001 in use
16 CREATE TABLE t1 (id INT, txt LONGTEXT) ENGINE=Aria;
17 BEGIN NOT ATOMIC
18 FOR id IN 0..9 DO
19 INSERT INTO test.t1 (id, txt) VALUES (id, REPEAT(id,1024*1024));
20 END FOR;
21 END;
22 $$
23 SET @@global.aria_checkpoint_interval=DEFAULT /*Force checkpoint*/;
24 SHOW ENGINE aria logs;
25 Type Name Status
26 Aria aria_log.00000001 free
27 Aria aria_log.00000002 in use
28 DROP TABLE t1;
29 # restart