1
2
3
4
5
6
7
8
9
10
11
12
13
|
set default_storage_engine='tokudb';
drop table if exists t1;
set session tokudb_auto_analyze = 1;
set session tokudb_analyze_in_background = true;
set session tokudb_analyze_mode = TOKUDB_ANALYZE_STANDARD;
set session tokudb_analyze_throttle = 0;
set session tokudb_analyze_time = 0;
create table t1(a int, b text(1), c text(1), filler text(1), primary key(a, b(1)), unique key (a, c(1)));
lock tables t1 write, t1 as a read, t1 as b read;
insert into t1(a) values(1);
alter table t1 drop key a;
unlock tables;
drop table t1;
|
