Debian Codegraph @

mysql-test/suite/perfschema/r/idx_variables_by_thread.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, VARIABLE_NAME
8 ====================================================================
9 ############ Explain for Query ####################################
10 explain select VARIABLE_VALUE
11 from performance_schema.variables_by_thread
12 where THREAD_ID = "impossible";
13 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
14 1 SIMPLE variables_by_thread NULL ref PRIMARY PRIMARY 8 const # 100.00 Using where
15 ############ Explain for Query ####################################
16 explain select VARIABLE_VALUE
17 from performance_schema.variables_by_thread
18 where THREAD_ID > "impossible";
19 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
20 1 SIMPLE variables_by_thread NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
21 ############ Explain for Query ####################################
22 explain select VARIABLE_VALUE
23 from performance_schema.variables_by_thread
24 where THREAD_ID < "2";
25 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
26 1 SIMPLE variables_by_thread NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
27 ############ Explain for Query ####################################
28 explain select VARIABLE_VALUE
29 from performance_schema.variables_by_thread
30 where THREAD_ID = @tid;
31 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
32 1 SIMPLE variables_by_thread NULL ref PRIMARY PRIMARY 8 const # 100.00 NULL
33 ############ Explain for Query ####################################
34 explain select VARIABLE_VALUE
35 from performance_schema.variables_by_thread
36 where THREAD_ID = "impossible"
37 and VARIABLE_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 VARIABLE_VALUE
42 from performance_schema.variables_by_thread
43 where THREAD_ID = @tid
44 and VARIABLE_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 VARIABLE_VALUE
49 from performance_schema.variables_by_thread
50 where THREAD_ID = @tid
51 and VARIABLE_NAME > "impossible";
52 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
53 1 SIMPLE variables_by_thread NULL ref PRIMARY PRIMARY 8 const # 33.33 Using where
54 ############ Explain for Query ####################################
55 explain select VARIABLE_VALUE
56 from performance_schema.variables_by_thread
57 where THREAD_ID = @tid
58 and VARIABLE_NAME < "2";
59 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
60 1 SIMPLE variables_by_thread NULL ref PRIMARY PRIMARY 8 const # 33.33 Using where
61 ############ Explain for Query ####################################
62 explain select VARIABLE_VALUE
63 from performance_schema.variables_by_thread
64 where THREAD_ID = @tid
65 and VARIABLE_NAME = "autocommit";
66 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
67 1 SIMPLE variables_by_thread NULL const PRIMARY PRIMARY 266 const,const # 100.00 NULL
68 ############# Explain End #########################################
69 flush status;
70 select VARIABLE_VALUE
71 from performance_schema.variables_by_thread
72 where THREAD_ID = @tid
73 and VARIABLE_NAME = "autocommit";
74 VARIABLE_VALUE
75 #
76 OK: handler_read_key incremented