Debian Codegraph @

mysql-test/suite/perfschema/r/idx_events_transactions_history.result

raw
1 create user foo@localhost;
2 grant ALL on *.* to foo@localhost;
3 truncate table performance_schema.events_transactions_history;
4 # Connection 1
5 select connection_id() into @conid;
6 start transaction;
7 rollback;
8 # Default connection
9
10 ====================================================================
11 Testing index for columns THREAD_ID, EVENT_ID
12 ====================================================================
13 ############ Explain for Query ####################################
14 explain select END_EVENT_ID
15 from performance_schema.events_transactions_history
16 where THREAD_ID = "impossible";
17 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
18 1 SIMPLE events_transactions_history NULL ref PRIMARY PRIMARY 8 const # 100.00 Using where
19 ############ Explain for Query ####################################
20 explain select END_EVENT_ID
21 from performance_schema.events_transactions_history
22 where THREAD_ID > "impossible";
23 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
24 1 SIMPLE events_transactions_history NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
25 ############ Explain for Query ####################################
26 explain select END_EVENT_ID
27 from performance_schema.events_transactions_history
28 where THREAD_ID < "2";
29 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
30 1 SIMPLE events_transactions_history NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
31 ############ Explain for Query ####################################
32 explain select END_EVENT_ID
33 from performance_schema.events_transactions_history
34 where THREAD_ID = @tid;
35 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
36 1 SIMPLE events_transactions_history NULL ref PRIMARY PRIMARY 8 const # 100.00 NULL
37 ############ Explain for Query ####################################
38 explain select END_EVENT_ID
39 from performance_schema.events_transactions_history
40 where THREAD_ID = "impossible"
41 and EVENT_ID = "impossible";
42 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
43 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table
44 ############ Explain for Query ####################################
45 explain select END_EVENT_ID
46 from performance_schema.events_transactions_history
47 where THREAD_ID = @tid
48 and EVENT_ID = "impossible";
49 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
50 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table
51 ############ Explain for Query ####################################
52 explain select END_EVENT_ID
53 from performance_schema.events_transactions_history
54 where THREAD_ID = @tid
55 and EVENT_ID > "impossible";
56 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
57 1 SIMPLE events_transactions_history NULL ref PRIMARY PRIMARY 8 const # 33.33 Using where
58 ############ Explain for Query ####################################
59 explain select END_EVENT_ID
60 from performance_schema.events_transactions_history
61 where THREAD_ID = @tid
62 and EVENT_ID < "2";
63 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
64 1 SIMPLE events_transactions_history NULL ref PRIMARY PRIMARY 8 const # 33.33 Using where
65 ############ Explain for Query ####################################
66 explain select END_EVENT_ID
67 from performance_schema.events_transactions_history
68 where THREAD_ID = @tid
69 and EVENT_ID = @eid;
70 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
71 1 SIMPLE events_transactions_history NULL const PRIMARY PRIMARY 16 const,const # 100.00 NULL
72 ############# Explain End #########################################
73 flush status;
74 select END_EVENT_ID
75 from performance_schema.events_transactions_history
76 where THREAD_ID = @tid
77 and EVENT_ID = @eid;
78 END_EVENT_ID
79 #
80 OK: handler_read_key incremented
81 commit;
82 drop user foo@localhost;