summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/sys_vars/t/innodb_flush_method_func.test
blob: 7293a99db41a84e3a26c40cbde299b8c1268e8df (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
--source include/have_innodb.inc
# Embedded server tests do not support restarting.
--source include/not_embedded.inc
# InnoDB: Cannot read first page of './ibdata1' I/O error
--source include/not_valgrind.inc

call mtr.add_suppression("InnoDB: Failed to set .*DIRECT");
--replace_result unbuffered fsync
select @@innodb_flush_method;

create table t(a serial) engine=innodb;

# kill and restart
FLUSH TABLES;
let $shutdown_timeout= 0;
let $restart_parameters=--innodb-flush-method=5;
--source include/restart_mysqld.inc
select @@innodb_flush_method;

insert into t values(0);
# kill and restart
FLUSH TABLES;
let $shutdown_timeout= 0;
let $restart_parameters=--innodb-flush-method=0;
--source include/restart_mysqld.inc
select @@innodb_flush_method;

drop table t;