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', 'memory/sql/Prepared_statement::main_mem_root'); # Switch to (con1, localhost, root, , ) # Switch to (con2, localhost, root, , ) PREPARE stmt1 FROM "SELECT 1 FROM DUAL;"; PREPARE stmt2a FROM "SELECT 2 FROM DUAL;"; PREPARE stmt2b FROM "SELECT 2+2 FROM DUAL;"; # Switch to connection default connection check_status CON1 threads PASSED connection check_status CON1 statement history PASSED offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total connection check_status CON2 threads PASSED connection check_status CON2 statement history PASSED offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total EXECUTE stmt1; 1 1 EXECUTE stmt2a; 2 2 EXECUTE stmt2b; 2+2 4 # Switch to connection default connection check_status CON1 threads PASSED connection check_status CON1 statement history PASSED offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total connection check_status CON2 threads PASSED connection check_status CON2 statement history PASSED offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total EXECUTE stmt1; 1 1 EXECUTE stmt2a; 2 2 EXECUTE stmt2b; 2+2 4 # Switch to connection default connection check_status CON1 threads PASSED connection check_status CON1 statement history PASSED offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total connection check_status CON2 threads PASSED connection check_status CON2 statement history PASSED offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total DEALLOCATE PREPARE stmt1; DEALLOCATE PREPARE stmt2a; DEALLOCATE PREPARE stmt2b; # Switch to connection default connection check_status CON1 threads PASSED connection check_status CON1 statement history PASSED offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total connection check_status CON2 threads PASSED connection check_status CON2 statement history PASSED offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total UPDATE performance_schema.setup_instruments SET FLAGS = '', ENABLED='YES'; UPDATE performance_schema.setup_instruments SET FLAGS = 'controlled' where (find_in_set('controlled_by_default', PROPERTIES)); UPDATE performance_schema.setup_threads SET ENABLED = 'YES'; UPDATE performance_schema.threads SET INSTRUMENTED = 'YES'; DROP PROCEDURE test.verify_thread; DROP TABLE test.enforced;