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
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
|
/* Copyright (c) 2017, 2025, Oracle and/or its affiliates.
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License, version 2.0,
as published by the Free Software Foundation.
This program is designed to work with certain software (including
but not limited to OpenSSL) that is licensed under separate terms,
as designated in a particular file or component or in included license
documentation. The authors of MySQL hereby grant you an additional
permission to link the program and your derivative works with the
separately licensed software that they have either included with
the program or referenced in the documentation.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License, version 2.0, for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA */
#ifndef PFS_DD_VERSION_H
#define PFS_DD_VERSION_H
/**
@file storage/perfschema/pfs_dd_version.h
Performance schema data dictionary version.
*/
/**
The version of the current performance_schema database schema.
Version numbering forms a name space,
which needs to be unique across all MySQL versions,
even including forks.
This version number is stored on disk in the data dictionary.
Every time the performance_schema structure changes,
this version number must change.
Do not use a naive 1, 2, 3, ... N numbering scheme,
as it requires an authoritative registry to assign numbers.
This can not work in a distributed development environment,
even less with forks, patches and back ports done by third parties.
The numbering to use is the MySQL version number
of the first MySQL version that published a given database schema.
The format is Mmmdd with M=Major, m=minor, d=dot,
so that MySQL 8.0.4 is encoded as 80004.
In case of -dash version numbers, encode MySQL 8.12.34-56 as 8123456.
Historical version number published in the data dictionary:
1:
Introduced in MySQL 8.0.3 by WL#7900.
Never published in a GA version, abandoned.
80004:
performance_schema tables changed in MySQL 8.0.4 are
- setup_threads (created)
- setup_instruments (modified)
- variables_info (modified)
- setup_timers (removed)
- metadata_locks (modified, added column COLUMN_NAME)
- replication_connection_configuration (modified)
- instance_log_resource (created)
80005:
performance_schema tables changed in MySQL 8.0.5 are
- all, changed UTF8 (aka UTF8MB3) to UTF8MB4.
80006:
performance_schema tables changed in MySQL 8.0.6 are
- variables_info.set_time precision changed from 0 to 6.
80011:
Version bump from 8.0.6 to 8.0.11,
versions [8.0.5 - 8.0.10] inclusive are abandoned.
performance_schema tables changed in MySQL 8.0.11 are
- instance_log_resource was renamed to log_resource.
80014:
performance_schema tables changed in MySQL 8.0.14 are
- events_statements_current, added column QUERY_ID
- events_statements_history, added column QUERY_ID
- events_statements_history_long, added column QUERY_ID
80015:
performance_schema.keyring_keys
80017: -- WARNING, EXPOSED BY MySQL 8.0.16 --
Unfortunately, MySQL 8.0.16 claim the 80017 tag, due to a bad merge.
performance_schema tables changed in MySQL 8.0.16
- replication_connection_configuration, added column NETWORK_NAMESPACE
800171: -- WARNING, EXPOSED BY MySQL 8.0.17 --
---------------------------------------------------------------------
IMPORTANT NOTE:
The release 8.0.16 made use of version 80017 incorrectly, which makes
the upgrade from 8.0.16 to 8.0.17 release immutable. This was
introduced by WL#12720.
In order to allow upgrade from 8.0.16 to 8.0.17, we choose the new
version number as 800171 for 8.0.17 release. Going forward the
release 8.0.18 would use 80018.
Note that, any comparison between two PFS version numbers should be
carefully done.
---------------------------------------------------------------------
performance_schema tables changed in MySQL 8.0.17
- WL#12571 increases the HOST name length from 60 to 255.
80018:
performance_schema tables changed in MySQL 8.0.18
- replication_connection_configuration, added column
MASTER_COMPRESSION_ALGORITHMS, MASTER_COMPRESSION_LEVEL
- replication_applier_configuration, added column
PRIVILEGE_CHECKS_USER
80019:
performance_schema tables changed in MySQL 8.0.19
- replication_connection_configuration, added column
TLS_CIPHERSUITES
- replication_applier_configuration, added column
REQUIRE_ROW_FORMAT
80020:
performance_schema tables changed in MySQL 8.0.20
- WL#3549 created binary_log_transaction_compression_stats
- replication_applier_configuration, added column
REQUIRE_TABLE_PRIMARY_KEY_CHECK
80021:
performance_schema tables changed in MySQL 8.0.21
- tls_channel_status (created)
- replication_connection_configuration, added column
SOURCE_CONNECTION_AUTO_FAILOVER
80022:
performance_schema tables changed in MySQL 8.0.22
- WL#9090 created processlist
- WL#13681 created error_log
80023:
performance_schema tables changed in MySQL 8.0.23
- WL#12819 replication_applier_configuration, added column
ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPE
ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUE
- performance_schema.replication_asynchronous_connection_failover,
added column MANAGED_NAME
- added table
performance_schema.replication_asynchronous_connection_failover_managed
80024:
performance_schema tables changed in MySQL 8.0.24
- WL#13446 added performance_schema.keyring_component_status
80027:
performance_schema tables changed in MySQL 8.0.27
- WL#9852 added replication_group_members column
MEMBER_COMMUNICATION_PROTOCOL_STACK
- Bug#32701593:'SELECT FROM
PS.REPLICATION_ASYNCHRONOUS_CONNECTION_FAILOVER' DIDN'T RETURN A RE
- WL#7491 added the column to replication_connection_configuration
the column GTID_ONLY
- BUG#104643 Defaults in performance schema tables incompatible with sql_mode
fixed TIMESTAMP columns (removed default 0)
fixed DOUBLE columns (removed sign)
80028:
performance_schema tables changed in MySQL 8.0.28
- WL#14779 PERFORMANCE_SCHEMA, ADD CPU TIME TO STATEMENT METRICS
added CPU_TIME, SUM_CPU_TIME columns.
- Fixed performance_schema.processlist host column to size 261.
80029:
performance_schema tables changed in MySQL 8.0.29
- WL#14346 PERFORMANCE_SCHEMA, SECONDARY_ENGINE STATS
Added columns EXECUTION_ENGINE, COUNT_SECONDARY
- Bug #30624990 NO UTF8MB3 IN INFORMATION_SCHEMA.CHARACTER_SETS
Use 'utf8mb3' rather than 'utf8' alias for for character set names.
80030:
performance_schema tables changed in MySQL 8.0.30
- WL#12527 added innodb_redo_log_files table (table is created dynamically
and based on PFS_engine_table_share_proxy mechanism)
- Bug #33787300 Rename utf8_xxx collations to utf8mb3_xxx
This patch renames utf8_bin to utf8mb3_bin
This patch renames utf8_general_ci
80031:
- WL#14432 Session memory limits in performance schema
Modified column PROPERTIES in table setup_instruments
Added column FLAGS in table setup_instruments
80032:
- WL#15419: Make the replica_generate_invisible_primary_key option settable
per channel
Modified column REQUIRE_TABLE_PRIMARY_KEY_CHECK in table
replication_applier_configuration
80033:
- WL#15059: PERFORMANCE_SCHEMA, OTEL TRACE INTERFACE
New column TELEMETRY_ACTIVE added to performance_schema.threads
80040:
- Bug#31763497 PERFORMANCE DEGRADATION CAUSED BY MONITORING
SYS.INNODB_LOCK_WAITS IN MYSQL 8.0
- Table performance_schema.data_lock_waits, add PRIMARY KEY.
*/
static const uint PFS_DD_VERSION = 80040;
#endif /* PFS_DD_VERSION_H */
|
