1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
|
# Tests for PERFORMANCE_SCHEMA
# Miscelaneous
--source include/not_embedded.inc
--source include/have_perfschema.inc
#
# Bug#12790483 OBJECTS_SUMMARY_GLOBAL_BY_TYPE AND RENAME TABLE
#
# Rename table leaves old tables names behind in
# performance_schema.objects_summary_global_by_type
#
SELECT object_schema, object_name FROM performance_schema.objects_summary_global_by_type
WHERE object_schema='test';
CREATE TABLE test.t_before(a INT);
INSERT INTO test.t_before VALUES (1);
# The new table should appear in OBJECTS_SUMMARY_GLOBAL_BY_TYPE.
SELECT object_schema, object_name FROM performance_schema.objects_summary_global_by_type
WHERE object_schema='test';
RENAME TABLE test.t_before TO test.t_after;
# The renamed table should appear in OBJECTS_SUMMARY_GLOBAL_BY_TYPE, but only
# after it is accessed.
SELECT COUNT(*) FROM test.t_after;
SELECT object_schema, object_name FROM performance_schema.objects_summary_global_by_type
WHERE object_schema='test';
DROP TABLE test.t_after;
# The renamed table should not appear in OBJECTS_SUMMARY_GLOBAL_BY_TYPE.
SELECT object_schema, object_name FROM performance_schema.objects_summary_global_by_type
WHERE object_schema='test';
#
# Verify table views are ignored by the table io instrumentation.
#
CREATE TABLE test.t1(a INT);
INSERT INTO test.t1 VALUES (1);
CREATE VIEW test.v1 AS SELECT * FROM test.t1;
SELECT COUNT(*) FROM test.v1;
# Verify that a PFS table share was not created for the view.
SELECT object_schema, object_name FROM performance_schema.objects_summary_global_by_type
WHERE object_schema='test';
DROP VIEW test.v1;
DROP TABLE test.t1;
SELECT object_schema, object_name FROM performance_schema.objects_summary_global_by_type
WHERE object_schema='test';
#
# Bug#45496 Performance schema: assertion fails in
# ha_perfschema::rnd_init:223
#
--disable_result_log
SELECT EVENT_ID FROM performance_schema.events_waits_current
WHERE THREAD_ID IN
(SELECT THREAD_ID FROM performance_schema.threads)
AND EVENT_NAME IN
(SELECT NAME FROM performance_schema.setup_instruments
WHERE NAME LIKE "wait/synch/%")
LIMIT 1;
--enable_result_log
#
# Bug#45088 Should not be able to create tables of engine PERFORMANCE_SCHEMA
#
--error ER_WRONG_PERFSCHEMA_USAGE
create table test.t1(a int) engine=performance_schema;
# The table should not appear in OBJECTS_SUMMARY_GLOBAL_BY_TYPE
SELECT object_schema, object_name FROM performance_schema.objects_summary_global_by_type
WHERE object_schema='test';
#
# Bug#44897 Performance Schema: can create a ghost table in another database
#
--error ER_WRONG_PERFSCHEMA_USAGE
create table test.t1 like performance_schema.events_waits_current;
# The table should not appear in OBJECTS_SUMMARY_GLOBAL_BY_TYPE
SELECT object_schema, object_name FROM performance_schema.objects_summary_global_by_type
WHERE object_schema='test';
#
# Bug#44898 PerformanceSchema: can create a table in db performance_schema, cannot insert
#
--error ER_TABLEACCESS_DENIED_ERROR
create table performance_schema.t1(a int);
# The table should not appear in OBJECTS_SUMMARY_GLOBAL_BY_TYPE
SELECT object_schema, object_name FROM performance_schema.objects_summary_global_by_type
WHERE object_schema='test';
#
# Bug#51447 performance schema evil twin files
#
--disable_warnings
drop table if exists test.ghost;
--enable_warnings
create table test.ghost (a int, b int);
alter table test.ghost add index index_a(a);
alter table test.ghost add index index_b(b);
insert into test.ghost values (1, 3);
insert into test.ghost values (2, 4);
select * from test.ghost;
drop table test.ghost;
# Shoud return nothing
select * from performance_schema.file_instances
where file_name like "%ghost%";
#
# Bug#52586 Misleading error message on attempt to access
# a P_S table using a wrong name
--error ER_NO_SUCH_TABLE
select * from performance_schema.no_such_table;
#
# Bug#12370950 - 60905: TABLE_IO_WAITS_SUMMARY_BY_INDEX_USAGE AGGREGATES NON-INSERT DML WRONGLY
#
--disable_warnings
DROP TABLE IF EXISTS t_60905;
--enable_warnings
CREATE TABLE t_60905 (i INT, j INT, KEY(i)) ENGINE = InnoDB;
INSERT INTO t_60905 VALUES
(1,2), (3,4), (5,6), (7,8), (9,10);
# should delete with a "single" PRIMARY lookup (2 PRIMARY fetch, 1 PRIMARY delete)
DELETE FROM t_60905 WHERE i = 1;
# should delete with a full scan (5 NULL fetch, 1 NULL delete)
DELETE FROM t_60905 WHERE j = 8;
# show the instrument data
SELECT object_schema,
object_name,
index_name,
count_fetch,
count_insert,
count_update,
count_delete
FROM performance_schema.table_io_waits_summary_by_index_usage
WHERE object_schema = 'test'
AND object_name = 't_60905';
DROP TABLE t_60905;
|
