38 lines
892 B
Plaintext
38 lines
892 B
Plaintext
#
|
|
# Validate that deadlock errors don't occur with a high level of concurrency
|
|
#
|
|
# Disable for valgrind because this takes too long
|
|
DROP DATABASE IF EXISTS mysqlslap;
|
|
CREATE DATABASE mysqlslap;
|
|
USE mysqlslap;
|
|
CREATE TABLE t1(id1 BIGINT, id2 BIGINT, count INT, PRIMARY KEY(id1, id2), KEY(id2)) ENGINE=xengine;
|
|
CREATE TABLE t1rev(id1 BIGINT, id2 BIGINT, count INT, PRIMARY KEY(id1, id2) COMMENT "rev:cf2", KEY(id2) COMMENT "rev:cf2") ENGINE=xengine;
|
|
SET @save = @@global.xengine_lock_wait_timeout;
|
|
SET GLOBAL xengine_lock_wait_timeout = 60;
|
|
SELECT count from t1;
|
|
count
|
|
5000
|
|
SELECT count from t1;
|
|
count
|
|
10000
|
|
SELECT count from t1;
|
|
count
|
|
15000
|
|
SELECT count from t1;
|
|
count
|
|
20000
|
|
SELECT count from t1rev;
|
|
count
|
|
5000
|
|
SELECT count from t1rev;
|
|
count
|
|
10000
|
|
SELECT count from t1rev;
|
|
count
|
|
15000
|
|
SELECT count from t1rev;
|
|
count
|
|
20000
|
|
SET GLOBAL xengine_lock_wait_timeout = @save;
|
|
DROP DATABASE mysqlslap;
|