# Performance schema tests generally depend on specific query plans
# and behavior, and much of the perfschema suite is therefore disabled
# if the hypergraph optimizer is active.
--source include/not_hypergraph.inc

# Tests for PERFORMANCE_SCHEMA

#setup
let $select_column = LOW_COUNT_USED;
let $table = performance_schema.memory_summary_by_thread_by_event_name;

select connection_id() into @conid;

select thread_id from performance_schema.threads
  where PROCESSLIST_ID = @conid
  into @tid;

###########################################################################
# Test index on THREAD_ID, EVENT_NAME
###########################################################################

let $column_count = 2;
let $col1 = THREAD_ID;
let $col2 = EVENT_NAME;
let $col1_act = @tid;
let $col2_act = "memory/sql/help";

--source ../include/idx_explain_test.inc