Debian Codegraph @

mysql-test/suite/perfschema/r/idx_mems_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 LOW_COUNT_USED
11 from performance_schema.memory_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 memory_summary_by_thread_by_event_name NULL ref PRIMARY PRIMARY 8 const # 100.00 Using where
15 ############ Explain for Query ####################################
16 explain select LOW_COUNT_USED
17 from performance_schema.memory_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 memory_summary_by_thread_by_event_name NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
21 ############ Explain for Query ####################################
22 explain select LOW_COUNT_USED
23 from performance_schema.memory_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 memory_summary_by_thread_by_event_name NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
27 ############ Explain for Query ####################################
28 explain select LOW_COUNT_USED
29 from performance_schema.memory_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 memory_summary_by_thread_by_event_name NULL ref PRIMARY PRIMARY 8 const # 100.00 NULL
33 ############ Explain for Query ####################################
34 explain select LOW_COUNT_USED
35 from performance_schema.memory_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 LOW_COUNT_USED
42 from performance_schema.memory_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 LOW_COUNT_USED
49 from performance_schema.memory_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 memory_summary_by_thread_by_event_name NULL ref PRIMARY PRIMARY 8 const # 33.33 Using where
54 ############ Explain for Query ####################################
55 explain select LOW_COUNT_USED
56 from performance_schema.memory_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 memory_summary_by_thread_by_event_name NULL ref PRIMARY PRIMARY 8 const # 33.33 Using where
61 ############ Explain for Query ####################################
62 explain select LOW_COUNT_USED
63 from performance_schema.memory_summary_by_thread_by_event_name
64 where THREAD_ID = @tid
65 and EVENT_NAME = "memory/sql/help";
66 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
67 1 SIMPLE memory_summary_by_thread_by_event_name NULL const PRIMARY PRIMARY 522 const,const # 100.00 NULL
68 ############# Explain End #########################################
69 flush status;
70 select LOW_COUNT_USED
71 from performance_schema.memory_summary_by_thread_by_event_name
72 where THREAD_ID = @tid
73 and EVENT_NAME = "memory/sql/help";
74 LOW_COUNT_USED
75 #
76 OK: handler_read_key incremented