Debian Codegraph @

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

raw
1 select OBJECT_INSTANCE_BEGIN, NAME from performance_schema.rwlock_instances
2 limit 1
3 into @oib, @name;
4 select WRITE_LOCKED_BY_THREAD_ID from performance_schema.rwlock_instances
5 where WRITE_LOCKED_BY_THREAD_ID is not NULL
6 limit 1
7 into @wlbtid;
8 Warnings:
9 Warning 1329 No data - zero rows fetched, selected, or processed
10
11 ====================================================================
12 Testing index for columns OBJECT_INSTANCE_BEGIN
13 ====================================================================
14 ############ Explain for Query ####################################
15 explain select READ_LOCKED_BY_COUNT
16 from performance_schema.rwlock_instances
17 where OBJECT_INSTANCE_BEGIN = "impossible";
18 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
19 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table
20 ############ Explain for Query ####################################
21 explain select READ_LOCKED_BY_COUNT
22 from performance_schema.rwlock_instances
23 where OBJECT_INSTANCE_BEGIN > "impossible";
24 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
25 1 SIMPLE rwlock_instances NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
26 ############ Explain for Query ####################################
27 explain select READ_LOCKED_BY_COUNT
28 from performance_schema.rwlock_instances
29 where OBJECT_INSTANCE_BEGIN < "2";
30 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
31 1 SIMPLE rwlock_instances NULL ALL PRIMARY NULL NULL NULL # 33.33 Using where
32 ############ Explain for Query ####################################
33 explain select READ_LOCKED_BY_COUNT
34 from performance_schema.rwlock_instances
35 where OBJECT_INSTANCE_BEGIN = @oib;
36 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
37 1 SIMPLE rwlock_instances NULL const PRIMARY PRIMARY 8 const # 100.00 NULL
38 ############# Explain End #########################################
39 flush status;
40 select READ_LOCKED_BY_COUNT
41 from performance_schema.rwlock_instances
42 where OBJECT_INSTANCE_BEGIN = @oib;
43 READ_LOCKED_BY_COUNT
44 #
45 OK: handler_read_key incremented
46
47 ====================================================================
48 Testing index for columns NAME
49 ====================================================================
50 ############ Explain for Query ####################################
51 explain select READ_LOCKED_BY_COUNT
52 from performance_schema.rwlock_instances
53 where NAME = "impossible";
54 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
55 1 SIMPLE rwlock_instances NULL ref NAME NAME 514 const # 100.00 NULL
56 ############ Explain for Query ####################################
57 explain select READ_LOCKED_BY_COUNT
58 from performance_schema.rwlock_instances
59 where NAME > "impossible";
60 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
61 1 SIMPLE rwlock_instances NULL ALL NAME NULL NULL NULL # 33.33 Using where
62 ############ Explain for Query ####################################
63 explain select READ_LOCKED_BY_COUNT
64 from performance_schema.rwlock_instances
65 where NAME < "2";
66 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
67 1 SIMPLE rwlock_instances NULL ALL NAME NULL NULL NULL # 33.33 Using where
68 ############ Explain for Query ####################################
69 explain select READ_LOCKED_BY_COUNT
70 from performance_schema.rwlock_instances
71 where NAME = @name;
72 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
73 1 SIMPLE rwlock_instances NULL ref NAME NAME 514 const # 100.00 NULL
74 ############# Explain End #########################################
75 flush status;
76 select READ_LOCKED_BY_COUNT
77 from performance_schema.rwlock_instances
78 where NAME = @name;
79 READ_LOCKED_BY_COUNT
80 #
81 OK: handler_read_key incremented