12 lines
563 B
Plaintext
12 lines
563 B
Plaintext
create user sbtest IDENTIFIED WITH mysql_native_password;
|
|
grant all privileges on *.* to 'sbtest'@'%';
|
|
create table t1 (a int primary key, b int) engine=xengine;
|
|
set @prior_xengine_lock_wait_timeout = @@xengine_lock_wait_timeout;
|
|
set @prior_xengine_deadlock_detect = @@xengine_deadlock_detect;
|
|
set global xengine_lock_wait_timeout = 100000;
|
|
set global xengine_deadlock_detect = ON;
|
|
set global xengine_lock_wait_timeout = @prior_xengine_lock_wait_timeout;
|
|
set global xengine_deadlock_detect = @prior_xengine_deadlock_detect;
|
|
drop user 'sbtest'@'%';
|
|
drop table t1;
|