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
|
#################
# INITIAL STATE #
#################
select * from INFORMATION_SCHEMA.tables
where TABLE_NAME like "pfs_example_%";
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE VERSION ROW_FORMAT TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE AUTO_INCREMENT CREATE_TIME UPDATE_TIME CHECK_TIME TABLE_COLLATION CHECKSUM CREATE_OPTIONS TABLE_COMMENT
describe performance_schema.pfs_example_continent;
ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
show create table performance_schema.pfs_example_continent;
ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
select * from performance_schema.pfs_example_continent;
ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
###########
# INSTALL #
###########
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;
TABLE_SCHEMA TABLE_NAME ENGINE VERSION TABLE_COMMENT
performance_schema pfs_example_continent PERFORMANCE_SCHEMA 10
performance_schema pfs_example_country PERFORMANCE_SCHEMA 10
describe performance_schema.pfs_example_continent;
Field Type Null Key Default Extra
NAME char(20) NO PRI NULL
show create table performance_schema.pfs_example_continent;
Table Create Table
pfs_example_continent CREATE TABLE `pfs_example_continent` (
`NAME` char(20) NOT NULL,
PRIMARY KEY (`NAME`)
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
select * from performance_schema.pfs_example_continent;
NAME
bar1
bar2
##############
# UN INSTALL #
##############
UNINSTALL COMPONENT "file://component_pfs_example_component_population";
select * from INFORMATION_SCHEMA.tables
where TABLE_NAME like "pfs_example_%";
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE VERSION ROW_FORMAT TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE AUTO_INCREMENT CREATE_TIME UPDATE_TIME CHECK_TIME TABLE_COLLATION CHECKSUM CREATE_OPTIONS TABLE_COMMENT
describe performance_schema.pfs_example_continent;
ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
show create table performance_schema.pfs_example_continent;
ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
select * from performance_schema.pfs_example_continent;
ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
################################
# SERVER RESTART, UN INSTALLED #
################################
# restart
select * from INFORMATION_SCHEMA.tables
where TABLE_NAME like "pfs_example_%";
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE VERSION ROW_FORMAT TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE AUTO_INCREMENT CREATE_TIME UPDATE_TIME CHECK_TIME TABLE_COLLATION CHECKSUM CREATE_OPTIONS TABLE_COMMENT
describe performance_schema.pfs_example_continent;
ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
show create table performance_schema.pfs_example_continent;
ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
select * from performance_schema.pfs_example_continent;
ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
###########
# INSTALL #
###########
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;
TABLE_SCHEMA TABLE_NAME ENGINE VERSION TABLE_COMMENT
performance_schema pfs_example_continent PERFORMANCE_SCHEMA 10
performance_schema pfs_example_country PERFORMANCE_SCHEMA 10
describe performance_schema.pfs_example_continent;
Field Type Null Key Default Extra
NAME char(20) NO PRI NULL
show create table performance_schema.pfs_example_continent;
Table Create Table
pfs_example_continent CREATE TABLE `pfs_example_continent` (
`NAME` char(20) NOT NULL,
PRIMARY KEY (`NAME`)
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
select * from performance_schema.pfs_example_continent;
NAME
bar1
bar2
#############################
# SERVER RESTART, INSTALLED #
#############################
# restart
select TABLE_SCHEMA, TABLE_NAME, ENGINE, VERSION, TABLE_COMMENT
from INFORMATION_SCHEMA.tables
where TABLE_NAME like "pfs_example_%"
order by table_name;
TABLE_SCHEMA TABLE_NAME ENGINE VERSION TABLE_COMMENT
performance_schema pfs_example_continent PERFORMANCE_SCHEMA 10
performance_schema pfs_example_country PERFORMANCE_SCHEMA 10
describe performance_schema.pfs_example_continent;
Field Type Null Key Default Extra
NAME char(20) NO PRI NULL
show create table performance_schema.pfs_example_continent;
Table Create Table
pfs_example_continent CREATE TABLE `pfs_example_continent` (
`NAME` char(20) NOT NULL,
PRIMARY KEY (`NAME`)
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
select * from performance_schema.pfs_example_continent;
NAME
bar1
bar2
##############
# UN INSTALL #
##############
UNINSTALL COMPONENT "file://component_pfs_example_component_population";
select * from INFORMATION_SCHEMA.tables
where TABLE_NAME like "pfs_example_%";
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE VERSION ROW_FORMAT TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE AUTO_INCREMENT CREATE_TIME UPDATE_TIME CHECK_TIME TABLE_COLLATION CHECKSUM CREATE_OPTIONS TABLE_COMMENT
describe performance_schema.pfs_example_continent;
ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
show create table performance_schema.pfs_example_continent;
ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
select * from performance_schema.pfs_example_continent;
ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
###########
# CLEANUP #
###########
pfs_example_component_population init:
Passed add_tables()
End of init
pfs_example_component_population_deinit:
Passed delete_tables()
End of deinit
|
