DROP DATABASE test;CREATE DATABASE test;USE test;
SET GLOBAL innodb_change_buffering_debug=1;
CREATE TABLE t1(c1 INT)PARTITION BY HASH (c1) PARTITIONS 15;
SET @start_global_value=@@global.innodb_spin_wait_delay;
SET @@global.innodb_limit_optimistic_insert_debug=@start_global_value;
create table tt(a int,b int,primary key(a,b));
set global innodb_limit_optimistic_insert_debug=1;
DROP TABLE IF EXISTS t1;
This is an upstream bug : http:// bugs.mysql. com/bug. php?id= 74605
Testcase *****
DROP DATABASE test;CREATE DATABASE test;USE test; change_ buffering_ debug=1; global_ value=@ @global. innodb_ spin_wait_ delay; innodb_ limit_optimisti c_insert_ debug=@ start_global_ value; limit_optimisti c_insert_ debug=1;
SET GLOBAL innodb_
CREATE TABLE t1(c1 INT)PARTITION BY HASH (c1) PARTITIONS 15;
SET @start_
SET @@global.
create table tt(a int,b int,primary key(a,b));
set global innodb_
DROP TABLE IF EXISTS t1;