Debian Codegraph @

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

raw
1 create database explain_test_db;
2 use explain_test_db;
3 truncate table performance_schema.events_statements_summary_by_digest;
4 select 1;
5 1
6 1
7 select digest from performance_schema.events_statements_summary_by_digest
8 where SCHEMA_NAME = 'explain_test_db' limit 1
9 into @digest;
10 use test;
11
12 ====================================================================
13 Testing index for columns SCHEMA_NAME, DIGEST
14 ====================================================================
15 ############ Explain for Query ####################################
16 explain select COUNT_STAR
17 from performance_schema.events_statements_summary_by_digest
18 where SCHEMA_NAME = "impossible";
19 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
20 1 SIMPLE events_statements_summary_by_digest NULL ref SCHEMA_NAME SCHEMA_NAME 259 const # 100.00 NULL
21 ############ Explain for Query ####################################
22 explain select COUNT_STAR
23 from performance_schema.events_statements_summary_by_digest
24 where SCHEMA_NAME > "impossible";
25 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
26 1 SIMPLE events_statements_summary_by_digest NULL ALL SCHEMA_NAME NULL NULL NULL # 33.33 Using where
27 ############ Explain for Query ####################################
28 explain select COUNT_STAR
29 from performance_schema.events_statements_summary_by_digest
30 where SCHEMA_NAME < "2";
31 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
32 1 SIMPLE events_statements_summary_by_digest NULL ALL SCHEMA_NAME NULL NULL NULL # 33.33 Using where
33 ############ Explain for Query ####################################
34 explain select COUNT_STAR
35 from performance_schema.events_statements_summary_by_digest
36 where SCHEMA_NAME = "explain_test_db";
37 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
38 1 SIMPLE events_statements_summary_by_digest NULL ref SCHEMA_NAME SCHEMA_NAME 259 const # 100.00 NULL
39 ############ Explain for Query ####################################
40 explain select COUNT_STAR
41 from performance_schema.events_statements_summary_by_digest
42 where SCHEMA_NAME = "impossible"
43 and DIGEST = "impossible";
44 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
45 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table
46 ############ Explain for Query ####################################
47 explain select COUNT_STAR
48 from performance_schema.events_statements_summary_by_digest
49 where SCHEMA_NAME = "explain_test_db"
50 and DIGEST = "impossible";
51 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
52 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table
53 ############ Explain for Query ####################################
54 explain select COUNT_STAR
55 from performance_schema.events_statements_summary_by_digest
56 where SCHEMA_NAME = "explain_test_db"
57 and DIGEST > "impossible";
58 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
59 1 SIMPLE events_statements_summary_by_digest NULL ref SCHEMA_NAME SCHEMA_NAME 259 const # 33.33 Using where
60 ############ Explain for Query ####################################
61 explain select COUNT_STAR
62 from performance_schema.events_statements_summary_by_digest
63 where SCHEMA_NAME = "explain_test_db"
64 and DIGEST < "2";
65 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
66 1 SIMPLE events_statements_summary_by_digest NULL ref SCHEMA_NAME SCHEMA_NAME 259 const # 33.33 Using where
67 ############ Explain for Query ####################################
68 explain select COUNT_STAR
69 from performance_schema.events_statements_summary_by_digest
70 where SCHEMA_NAME = "explain_test_db"
71 and DIGEST = @digest;
72 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
73 1 SIMPLE events_statements_summary_by_digest NULL const SCHEMA_NAME SCHEMA_NAME 518 const,const # 100.00 NULL
74 ############# Explain End #########################################
75 flush status;
76 select COUNT_STAR
77 from performance_schema.events_statements_summary_by_digest
78 where SCHEMA_NAME = "explain_test_db"
79 and DIGEST = @digest;
80 COUNT_STAR
81 #
82 OK: handler_read_key incremented
83 drop database explain_test_db;