Debian Codegraph @

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

raw
1 create user foo@localhost;
2 grant ALL on *.* to foo@localhost;
3 # Connection con
4
5 ====================================================================
6 Testing index for columns USER, HOST, VARIABLE_NAME
7 ====================================================================
8 ############ Explain for Query ####################################
9 explain select VARIABLE_VALUE
10 from performance_schema.status_by_account
11 where USER = "impossible";
12 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
13 1 SIMPLE status_by_account NULL ref ACCOUNT ACCOUNT 129 const # 100.00 NULL
14 ############ Explain for Query ####################################
15 explain select VARIABLE_VALUE
16 from performance_schema.status_by_account
17 where USER > "impossible";
18 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
19 1 SIMPLE status_by_account NULL ALL ACCOUNT NULL NULL NULL # 33.33 Using where
20 ############ Explain for Query ####################################
21 explain select VARIABLE_VALUE
22 from performance_schema.status_by_account
23 where USER < "2";
24 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
25 1 SIMPLE status_by_account NULL ALL ACCOUNT NULL NULL NULL # 33.33 Using where
26 ############ Explain for Query ####################################
27 explain select VARIABLE_VALUE
28 from performance_schema.status_by_account
29 where USER = "foo";
30 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
31 1 SIMPLE status_by_account NULL ref ACCOUNT ACCOUNT 129 const # 100.00 NULL
32 ############ Explain for Query ####################################
33 explain select VARIABLE_VALUE
34 from performance_schema.status_by_account
35 where USER = "impossible"
36 and HOST = "impossible";
37 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
38 1 SIMPLE status_by_account NULL ref ACCOUNT ACCOUNT 385 const,const # 100.00 NULL
39 ############ Explain for Query ####################################
40 explain select VARIABLE_VALUE
41 from performance_schema.status_by_account
42 where USER = "foo"
43 and HOST = "impossible";
44 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
45 1 SIMPLE status_by_account NULL ref ACCOUNT ACCOUNT 385 const,const # 100.00 NULL
46 ############ Explain for Query ####################################
47 explain select VARIABLE_VALUE
48 from performance_schema.status_by_account
49 where USER = "foo"
50 and HOST > "impossible";
51 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
52 1 SIMPLE status_by_account NULL ref ACCOUNT ACCOUNT 129 const # 33.33 Using where
53 ############ Explain for Query ####################################
54 explain select VARIABLE_VALUE
55 from performance_schema.status_by_account
56 where USER = "foo"
57 and HOST < "2";
58 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
59 1 SIMPLE status_by_account NULL ref ACCOUNT ACCOUNT 129 const # 33.33 Using where
60 ############ Explain for Query ####################################
61 explain select VARIABLE_VALUE
62 from performance_schema.status_by_account
63 where USER = "foo"
64 and HOST = "localhost";
65 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
66 1 SIMPLE status_by_account NULL ref ACCOUNT ACCOUNT 385 const,const # 100.00 NULL
67 ############ Explain for Query ####################################
68 explain select VARIABLE_VALUE
69 from performance_schema.status_by_account
70 where USER = "impossible"
71 and HOST = "impossible"
72 and VARIABLE_NAME = "impossible";
73 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
74 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table
75 ############ Explain for Query ####################################
76 explain select VARIABLE_VALUE
77 from performance_schema.status_by_account
78 where USER = "foo"
79 and HOST = "localhost"
80 and VARIABLE_NAME = "impossible";
81 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
82 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table
83 ############ Explain for Query ####################################
84 explain select VARIABLE_VALUE
85 from performance_schema.status_by_account
86 where USER = "foo"
87 and HOST = "localhost"
88 and VARIABLE_NAME > "impossible";
89 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
90 1 SIMPLE status_by_account NULL ref ACCOUNT ACCOUNT 385 const,const # 33.33 Using where
91 ############ Explain for Query ####################################
92 explain select VARIABLE_VALUE
93 from performance_schema.status_by_account
94 where USER = "foo"
95 and HOST = "localhost"
96 and VARIABLE_NAME < "2";
97 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
98 1 SIMPLE status_by_account NULL ref ACCOUNT ACCOUNT 385 const,const # 33.33 Using where
99 ############ Explain for Query ####################################
100 explain select VARIABLE_VALUE
101 from performance_schema.status_by_account
102 where USER = "foo"
103 and HOST = "localhost"
104 and VARIABLE_NAME = "Max_execution_time_exceeded";
105 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
106 1 SIMPLE status_by_account NULL const ACCOUNT ACCOUNT 643 const,const,const # 100.00 NULL
107 ############# Explain End #########################################
108 flush status;
109 select VARIABLE_VALUE
110 from performance_schema.status_by_account
111 where USER = "foo"
112 and HOST = "localhost"
113 and VARIABLE_NAME = "Max_execution_time_exceeded";
114 VARIABLE_VALUE
115 #
116 OK: handler_read_key incremented
117 # Conenction default
118 drop user foo@localhost;