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 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68
|
SET DEFAULT_STORAGE_ENGINE = 'tokudb';
# Establish connection conn1 (user = root)
DROP TABLE IF EXISTS foo;
set session transaction isolation level read uncommitted;
set session tokudb_prelock_empty=1;
set session tokudb_load_save_space=0;
create table foo (a int, b int, c int, key (a)) engine=TokuDB;
show create table foo;
Table Create Table
foo CREATE TABLE `foo` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=TokuDB DEFAULT CHARSET=latin1 `compression`='tokudb_zlib'
begin;
insert into foo values (1,10,100),(2,20,200),(3,30,300);
set session transaction isolation level read uncommitted;
set session lock_wait_timeout=1;
insert into foo values (100,100,100);
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
alter table foo drop index a;
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
truncate table foo;
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
commit;
drop table foo;
set session tokudb_prelock_empty=1;
set session tokudb_load_save_space=1;
create table foo (a int, b int, c int, key (a)) engine=TokuDB;
show create table foo;
Table Create Table
foo CREATE TABLE `foo` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=TokuDB DEFAULT CHARSET=latin1 `compression`='tokudb_zlib'
begin;
insert into foo values (1,10,100),(2,20,200),(3,30,300);
insert into foo values (100,100,100);
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
alter table foo drop index a;
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
truncate table foo;
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
commit;
drop table foo;
set session tokudb_prelock_empty=0;
set session tokudb_load_save_space=0;
create table foo (a int, b int, c int, key (a)) engine=TokuDB;
show create table foo;
Table Create Table
foo CREATE TABLE `foo` (
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
`c` int(11) DEFAULT NULL,
KEY `a` (`a`)
) ENGINE=TokuDB DEFAULT CHARSET=latin1 `compression`='tokudb_zlib'
begin;
insert into foo values (1,10,100),(2,20,200),(3,30,300);
insert into foo values (100,100,100);
alter table foo drop index a;
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
truncate table foo;
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
set session transaction isolation level serializable;
DROP TABLE foo;
|