Debian Codegraph @

mysql-test/suite/perfschema/t/idx_mems_by_user_by_event_name.test

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 #setup
4 let $select_column = LOW_COUNT_USED;
5 let $table = performance_schema.memory_summary_by_user_by_event_name;
6
7 create user foo@localhost;
8 grant ALL on *.* to foo@localhost;
9 connect(con, localhost, foo,,);
10
11 select connection_id() into @conid;
12 select thread_id from performance_schema.threads
13 where PROCESSLIST_ID = @conid
14 into @tid;
15
16 ###########################################################################
17 # Test index on USER, EVENT_NAME
18 ###########################################################################
19
20 let $column_count = 2;
21 let $col1 = USER;
22 let $col2 = EVENT_NAME;
23 let $col1_act = "foo";
24 let $col2_act = "memory/sql/help";
25
26 --source ../include/idx_explain_test.inc
27
28 # Cleanup
29 --connection default
30 drop user foo@localhost;