Debian Codegraph @

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

raw
1
2 ====================================================================
3 Testing index for columns EVENT_NAME
4 ====================================================================
5 ############ Explain for Query ####################################
6 explain select COUNT_STAR
7 from performance_schema.events_waits_summary_global_by_event_name
8 where EVENT_NAME = "impossible";
9 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
10 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table
11 ############ Explain for Query ####################################
12 explain select COUNT_STAR
13 from performance_schema.events_waits_summary_global_by_event_name
14 where EVENT_NAME > "impossible";
15 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
16 1 SIMPLE events_waits_summary_global_by_event_name NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
17 ############ Explain for Query ####################################
18 explain select COUNT_STAR
19 from performance_schema.events_waits_summary_global_by_event_name
20 where EVENT_NAME < "2";
21 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
22 1 SIMPLE events_waits_summary_global_by_event_name NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
23 ############ Explain for Query ####################################
24 explain select COUNT_STAR
25 from performance_schema.events_waits_summary_global_by_event_name
26 where EVENT_NAME = "wait/lock/table/sql/handler";
27 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
28 1 SIMPLE events_waits_summary_global_by_event_name NULL const PRIMARY PRIMARY 514 const # 100.00 NULL
29 ############# Explain End #########################################
30 flush status;
31 select COUNT_STAR
32 from performance_schema.events_waits_summary_global_by_event_name
33 where EVENT_NAME = "wait/lock/table/sql/handler";
34 COUNT_STAR
35 #
36 OK: handler_read_key incremented