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
|
#################
# 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_employee_name;
ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
show create table performance_schema.pfs_example_employee_name;
ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
select * from performance_schema.pfs_example_employee_name;
ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
###########
# INSTALL #
###########
INSTALL PLUGIN pfs_example_plugin_employee SONAME 'pfs_example_plugin_employee.xxx';
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_employee_name PERFORMANCE_SCHEMA 10
performance_schema pfs_example_employee_salary PERFORMANCE_SCHEMA 10
performance_schema pfs_example_machine PERFORMANCE_SCHEMA 10
performance_schema pfs_example_machine_by_employee_by_type PERFORMANCE_SCHEMA 10
describe performance_schema.pfs_example_employee_name;
Field Type Null Key Default Extra
EMPLOYEE_NUMBER int NO PRI NULL
FIRST_NAME char(20) YES MUL NULL
LAST_NAME varchar(20) YES NULL
show create table performance_schema.pfs_example_employee_name;
Table Create Table
pfs_example_employee_name CREATE TABLE `pfs_example_employee_name` (
`EMPLOYEE_NUMBER` int NOT NULL,
`FIRST_NAME` char(20) DEFAULT NULL,
`LAST_NAME` varchar(20) DEFAULT NULL,
PRIMARY KEY (`EMPLOYEE_NUMBER`),
KEY `FIRST_NAME` (`FIRST_NAME`)
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
select * from performance_schema.pfs_example_employee_name;
EMPLOYEE_NUMBER FIRST_NAME LAST_NAME
1 foo1 bar1
2 foo2 bar2
3 foo3 bar3
##############
# UN INSTALL #
##############
UNINSTALL PLUGIN pfs_example_plugin_employee;
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_employee_name;
ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
show create table performance_schema.pfs_example_employee_name;
ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
select * from performance_schema.pfs_example_employee_name;
ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
insert into performance_schema.pfs_example_employee_name
values (1, "First", "Last");
ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
update performance_schema.pfs_example_employee_name
set employee_number = 2 where employee_number = 1;
ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
delete from performance_schema.pfs_example_employee_name;
ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
##########################################
# SERVER RESTART, AFTER PLUGIN UNINSTALL #
##########################################
# 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_employee_name;
ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
show create table performance_schema.pfs_example_employee_name;
ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
select * from performance_schema.pfs_example_employee_name;
ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
###########
# INSTALL #
###########
INSTALL PLUGIN pfs_example_plugin_employee SONAME 'pfs_example_plugin_employee.xxx';
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_employee_name PERFORMANCE_SCHEMA 10
performance_schema pfs_example_employee_salary PERFORMANCE_SCHEMA 10
performance_schema pfs_example_machine PERFORMANCE_SCHEMA 10
performance_schema pfs_example_machine_by_employee_by_type PERFORMANCE_SCHEMA 10
describe performance_schema.pfs_example_employee_name;
Field Type Null Key Default Extra
EMPLOYEE_NUMBER int NO PRI NULL
FIRST_NAME char(20) YES MUL NULL
LAST_NAME varchar(20) YES NULL
show create table performance_schema.pfs_example_employee_name;
Table Create Table
pfs_example_employee_name CREATE TABLE `pfs_example_employee_name` (
`EMPLOYEE_NUMBER` int NOT NULL,
`FIRST_NAME` char(20) DEFAULT NULL,
`LAST_NAME` varchar(20) DEFAULT NULL,
PRIMARY KEY (`EMPLOYEE_NUMBER`),
KEY `FIRST_NAME` (`FIRST_NAME`)
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
select * from performance_schema.pfs_example_employee_name;
EMPLOYEE_NUMBER FIRST_NAME LAST_NAME
1 foo1 bar1
2 foo2 bar2
3 foo3 bar3
############################################
# SERVER RESTART, WITHOUT PLUGIN UNINSTALL #
############################################
# 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_employee_name PERFORMANCE_SCHEMA 10
performance_schema pfs_example_employee_salary PERFORMANCE_SCHEMA 10
performance_schema pfs_example_machine PERFORMANCE_SCHEMA 10
performance_schema pfs_example_machine_by_employee_by_type PERFORMANCE_SCHEMA 10
describe performance_schema.pfs_example_employee_name;
Field Type Null Key Default Extra
EMPLOYEE_NUMBER int NO PRI NULL
FIRST_NAME char(20) YES MUL NULL
LAST_NAME varchar(20) YES NULL
show create table performance_schema.pfs_example_employee_name;
Table Create Table
pfs_example_employee_name CREATE TABLE `pfs_example_employee_name` (
`EMPLOYEE_NUMBER` int NOT NULL,
`FIRST_NAME` char(20) DEFAULT NULL,
`LAST_NAME` varchar(20) DEFAULT NULL,
PRIMARY KEY (`EMPLOYEE_NUMBER`),
KEY `FIRST_NAME` (`FIRST_NAME`)
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
select * from performance_schema.pfs_example_employee_name;
EMPLOYEE_NUMBER FIRST_NAME LAST_NAME
1 foo1 bar1
2 foo2 bar2
3 foo3 bar3
###########
# CLEANUP #
###########
UNINSTALL PLUGIN pfs_example_plugin_employee;
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_employee_name;
ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
show create table performance_schema.pfs_example_employee_name;
ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
select * from performance_schema.pfs_example_employee_name;
ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
|
