Debian Codegraph @

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

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