1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
SET DEFAULT_STORAGE_ENGINE = 'tokudb';
DROP TABLE IF EXISTS t1;
create table t1 (i int, j int, primary key (i))engine=TokuDB;
insert into t1 values (0,0) MEMCACHE_DIRTY 'a';
insert into t1 values (1,0) MEMCACHE_DIRTY 'b', 'c';
update t1 set j=j+1 where i=0 MEMCACHE_DIRTY 'a';
update t1 set j=j+1 where i=1 MEMCACHE_DIRTY 'b', 'c';
insert into t1 values (0,0) on duplicate key update j=j+1 MEMCACHE_DIRTY 'a';
insert into t1 values (2,0) on duplicate key update j=j+1 MEMCACHE_DIRTY 'a', 'b';
replace into t1 values (0,3) MEMCACHE_DIRTY 'a';
replace into t1 values (3,3) MEMCACHE_DIRTY 'a', 'b';
delete from t1 where i=0 MEMCACHE_DIRTY 'a';
delete from t1 where i=1 MEMCACHE_DIRTY 'b', 'c';
DROP TABLE t1;
|
