221
221
# ADD PARTITION and LOCK TABLE
222
222
CREATE TABLE t1 ( i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, f INT )
223
223
ENGINE = InnoDB PARTITION BY HASH(i) PARTITIONS 2;
224
INSERT INTO t1 VALUES (2, 2), (3, 3), (4, 4), (5, 5);
224
225
SET lock_wait_timeout = 2;
225
226
#Connection 1 locks the table