Debian Codegraph @

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

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