#
# 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;