ctrl_mem_ps_mix.test

UPDATE performance_schema.setup_instruments
  SET FLAGS = '', ENABLED='NO'
  WHERE NAME LIKE 'memory/%';

UPDATE performance_schema.setup_instruments
  SET FLAGS = 'controlled', ENABLED='YES'
  WHERE NAME IN ('memory/sql/Prepared_statement::infrastructure');

UPDATE performance_schema.setup_instruments
  SET ENABLED='YES'
  WHERE NAME IN ('memory/sql/Prepared_statement::main_mem_root');

--source ../include/controlled_memory_setup.inc

--connection con1

PREPARE stmt1 FROM "SELECT 1 FROM DUAL;";

--connection con2

PREPARE stmt2a FROM "SELECT 2 FROM DUAL;";
PREPARE stmt2b FROM "SELECT 2+2 FROM DUAL;";

--source ../include/controlled_memory_dump.inc

--connection con1

EXECUTE stmt1;

--connection con2

EXECUTE stmt2a;
EXECUTE stmt2b;

--source ../include/controlled_memory_dump.inc

--connection con1

EXECUTE stmt1;

--connection con2

EXECUTE stmt2a;
EXECUTE stmt2b;

--source ../include/controlled_memory_dump.inc

--connection con1

DEALLOCATE PREPARE stmt1;

--connection con2

DEALLOCATE PREPARE stmt2a;
DEALLOCATE PREPARE stmt2b;

--source ../include/controlled_memory_dump.inc

--source ../include/controlled_memory_cleanup.inc