Another testcase
DROP DATABASE test;CREATE DATABASE test;USE test; CREATE TABLE t2(ticket int,inhalt text,KEY tig (ticket),fulltext index tix (inhalt)) ENGINE=InnoDB; create table t1(t1 timestamp default now(),t2 DATE,t3 timestamp DEFAULT '0000-00-00 00:00:00'); FLUSH LOCAL TABLES test.t1,test.t2 for ExPoRt; SET GLOBAL innodb_sched_priority_purge=19;
Another testcase
DROP DATABASE test;CREATE DATABASE test;USE test; sched_priority_ purge=19;
CREATE TABLE t2(ticket int,inhalt text,KEY tig (ticket),fulltext index tix (inhalt)) ENGINE=InnoDB;
create table t1(t1 timestamp default now(),t2 DATE,t3 timestamp DEFAULT '0000-00-00 00:00:00');
FLUSH LOCAL TABLES test.t1,test.t2 for ExPoRt;
SET GLOBAL innodb_