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
|
################################################################################
# Test case to test functionality in which a plugin/component can add its own
# tables in performance schema.
#
################################################################################
--echo #################
--echo # INITIAL STATE #
--echo #################
select * from INFORMATION_SCHEMA.tables
where TABLE_NAME like "pfs_example_%";
--error ER_NO_SUCH_TABLE
describe performance_schema.pfs_example_continent;
--error ER_NO_SUCH_TABLE
show create table performance_schema.pfs_example_continent;
--error ER_NO_SUCH_TABLE
select * from performance_schema.pfs_example_continent;
--echo ###########
--echo # INSTALL #
--echo ###########
INSTALL COMPONENT "file://component_pfs_example_component_population";
select TABLE_SCHEMA, TABLE_NAME, ENGINE, VERSION, TABLE_COMMENT
from INFORMATION_SCHEMA.tables
where TABLE_NAME like "pfs_example_%"
order by table_name;
describe performance_schema.pfs_example_continent;
show create table performance_schema.pfs_example_continent;
select * from performance_schema.pfs_example_continent;
--echo ##############
--echo # UN INSTALL #
--echo ##############
UNINSTALL COMPONENT "file://component_pfs_example_component_population";
select * from INFORMATION_SCHEMA.tables
where TABLE_NAME like "pfs_example_%";
--error ER_NO_SUCH_TABLE
describe performance_schema.pfs_example_continent;
--error ER_NO_SUCH_TABLE
show create table performance_schema.pfs_example_continent;
--error ER_NO_SUCH_TABLE
select * from performance_schema.pfs_example_continent;
--echo ################################
--echo # SERVER RESTART, UN INSTALLED #
--echo ################################
--source include/restart_mysqld.inc
select * from INFORMATION_SCHEMA.tables
where TABLE_NAME like "pfs_example_%";
--error ER_NO_SUCH_TABLE
describe performance_schema.pfs_example_continent;
--error ER_NO_SUCH_TABLE
show create table performance_schema.pfs_example_continent;
--error ER_NO_SUCH_TABLE
select * from performance_schema.pfs_example_continent;
--echo ###########
--echo # INSTALL #
--echo ###########
INSTALL COMPONENT "file://component_pfs_example_component_population";
select TABLE_SCHEMA, TABLE_NAME, ENGINE, VERSION, TABLE_COMMENT
from INFORMATION_SCHEMA.tables
where TABLE_NAME like "pfs_example_%"
order by table_name;
describe performance_schema.pfs_example_continent;
show create table performance_schema.pfs_example_continent;
select * from performance_schema.pfs_example_continent;
--echo #############################
--echo # SERVER RESTART, INSTALLED #
--echo #############################
--source include/restart_mysqld.inc
select TABLE_SCHEMA, TABLE_NAME, ENGINE, VERSION, TABLE_COMMENT
from INFORMATION_SCHEMA.tables
where TABLE_NAME like "pfs_example_%"
order by table_name;
describe performance_schema.pfs_example_continent;
show create table performance_schema.pfs_example_continent;
select * from performance_schema.pfs_example_continent;
--echo ##############
--echo # UN INSTALL #
--echo ##############
UNINSTALL COMPONENT "file://component_pfs_example_component_population";
select * from INFORMATION_SCHEMA.tables
where TABLE_NAME like "pfs_example_%";
--error ER_NO_SUCH_TABLE
describe performance_schema.pfs_example_continent;
--error ER_NO_SUCH_TABLE
show create table performance_schema.pfs_example_continent;
--error ER_NO_SUCH_TABLE
select * from performance_schema.pfs_example_continent;
--echo ###########
--echo # CLEANUP #
--echo ###########
let $MYSQLD_DATADIR= `select @@datadir`;
cat_file $MYSQLD_DATADIR/pfs_example_component_population.log;
remove_file $MYSQLD_DATADIR/pfs_example_component_population.log;
|
