Debian Codegraph @

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

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