--source include/have_debug.inc --echo # --echo # Normal Case --echo # set global innodb_limit_optimistic_insert_debug = 2; CREATE TABLE t1 (a INT); INSERT INTO t1 VALUES (10), (20), (30), (40), (50), (60), (70), (80), (90), (100); SELECT COUNT(*) FROM t1; CHECK TABLE t1; DROP TABLE t1; set global innodb_limit_optimistic_insert_debug = 0; --echo # --echo # Error test case where we run out of resources while spawning threads and the worker threads exit --echo # call mtr.add_suppression("\\[Warning\\] .* Resource not available to create threads for parallel scan. Falling back to single thread mode."); set global innodb_limit_optimistic_insert_debug = 2; set debug="+d,innodb_pread_thread_OOR"; CREATE TABLE t1 (a INT); INSERT INTO t1 VALUES (10), (20), (30), (40), (50), (60), (70), (80), (90), (100); # Check parallel read SELECT COUNT(*) FROM t1; # Check parallel read CHECK TABLE t1; DROP TABLE t1; set global innodb_limit_optimistic_insert_debug = 0; set debug="-d,innodb_pread_thread_OOR";