1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
# 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 = END_EVENT_ID;
let $table = performance_schema.events_waits_history;
create database explain_test_db;
create table explain_test_db.t1 (c int);
insert into explain_test_db.t1 values ('1');
truncate table performance_schema.events_waits_history;
# Create a new Connection
connect(con1,127.0.0.1,root,,);
--echo # Connection 1
--connection con1
select connection_id() into @conid;
let $tid = `select thread_id from performance_schema.threads
where PROCESSLIST_ID = @conid`;
select * from explain_test_db.t1;
--echo # Default connection
--connection default
--disable_query_log
--eval select EVENT_ID from performance_schema.events_waits_history where THREAD_ID = $tid limit 1 into @eid;
--eval select $tid into @tid;
--enable_query_log
###########################################################################
# Test index on THREAD_ID, EVENT_ID
###########################################################################
let $column_count = 2;
let $col1 = THREAD_ID;
let $col2 = EVENT_ID;
let $col1_act = @tid;
let $col2_act = @eid;
--source ../include/idx_explain_test.inc
# Cleanup
drop table explain_test_db.t1;
drop database explain_test_db;
|
