Debian Codegraph @

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

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