if (`SELECT VERSION() LIKE '%embedded%'`) { --skip This test cannot run with the embedded server. } --source suite/perfschema_stress/include/settings.inc --disable_query_log --disable_result_log if (!$engine_type) { let $engine_type= $default_engine_type; } if ($engine_type == Falcon) { --source include/have_falcon.inc } --replace_result $engine_type eval CREATE TABLE t1 (id INT PRIMARY KEY, b CHAR(100) DEFAULT 'initial value') ENGINE=$engine_type; # Need something to start with INSERT INTO t1(id) VALUES (1), (2), (3), (4), (5), (6), (7), (8); # Bulk load the correct number of rows while (`SELECT MAX(id) < $num_stress_rows FROM t1`) { SELECT MAX(id) FROM t1 INTO @max; --replace_result $num_stress_rows eval INSERT INTO t1(id) SELECT id + @max FROM t1 WHERE id + @max <= $num_stress_rows; } # Turn on some instruments UPDATE performance_schema.setup_instruments SET TIMED = 'YES'; UPDATE performance_schema.setup_instruments SET ENABLED = 'NO'; UPDATE performance_schema.setup_instruments SET ENABLED = 'YES' WHERE NAME IN ('wait/io/file/sql/FRM', 'thread/sql/Connection', 'wait/synch/cond/sql/COND_mdl', 'wait/synch/rwlock/sql/LOCK_sys_init_connect', 'wait/synch/mutex/sql/LOCK_mdl'); UPDATE performance_schema.setup_consumers SET ENABLED = 'YES'; --enable_result_log --enable_query_log