MySQL
8.1.0
Source Code Documentation
pfs_dd_version.h
Go to the documentation of this file.
1
/* Copyright (c) 2017, 2023, Oracle and/or its affiliates.
2
3
This program is free software; you can redistribute it and/or modify
4
it under the terms of the GNU General Public License, version 2.0,
5
as published by the Free Software Foundation.
6
7
This program is also distributed with certain software (including
8
but not limited to OpenSSL) that is licensed under separate terms,
9
as designated in a particular file or component or in included license
10
documentation. The authors of MySQL hereby grant you an additional
11
permission to link the program and your derivative works with the
12
separately licensed software that they have included with MySQL.
13
14
This program is distributed in the hope that it will be useful,
15
but WITHOUT ANY WARRANTY; without even the implied warranty of
16
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17
GNU General Public License, version 2.0, for more details.
18
19
You should have received a copy of the GNU General Public License
20
along with this program; if not, write to the Free Software
21
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA */
22
23
#ifndef PFS_DD_VERSION_H
24
#define PFS_DD_VERSION_H
25
26
/**
27
@file storage/perfschema/pfs_dd_version.h
28
Performance schema data dictionary version.
29
*/
30
31
/**
32
The version of the current performance_schema database schema.
33
Version numbering forms a name space,
34
which needs to be unique across all MySQL versions,
35
even including forks.
36
37
This version number is stored on disk in the data dictionary.
38
Every time the performance_schema structure changes,
39
this version number must change.
40
41
Do not use a naive 1, 2, 3, ... N numbering scheme,
42
as it requires an authoritative registry to assign numbers.
43
This can not work in a distributed development environment,
44
even less with forks, patches and back ports done by third parties.
45
46
The numbering to use is the MySQL version number
47
of the first MySQL version that published a given database schema.
48
The format is Mmmdd with M=Major, m=minor, d=dot,
49
so that MySQL 8.0.4 is encoded as 80004.
50
51
In case of -dash version numbers, encode MySQL 8.12.34-56 as 8123456.
52
53
Historical version number published in the data dictionary:
54
55
1:
56
57
Introduced in MySQL 8.0.3 by WL#7900.
58
Never published in a GA version, abandoned.
59
60
80004:
61
62
performance_schema tables changed in MySQL 8.0.4 are
63
- setup_threads (created)
64
- setup_instruments (modified)
65
- variables_info (modified)
66
- setup_timers (removed)
67
- metadata_locks (modified, added column COLUMN_NAME)
68
- replication_connection_configuration (modified)
69
- instance_log_resource (created)
70
71
80005:
72
73
performance_schema tables changed in MySQL 8.0.5 are
74
- all, changed UTF8 (aka UTF8MB3) to UTF8MB4.
75
76
80006:
77
78
performance_schema tables changed in MySQL 8.0.6 are
79
- variables_info.set_time precision changed from 0 to 6.
80
81
80011:
82
83
Version bump from 8.0.6 to 8.0.11,
84
versions [8.0.5 - 8.0.10] inclusive are abandoned.
85
performance_schema tables changed in MySQL 8.0.11 are
86
- instance_log_resource was renamed to log_resource.
87
88
80014:
89
90
performance_schema tables changed in MySQL 8.0.14 are
91
- events_statements_current, added column QUERY_ID
92
- events_statements_history, added column QUERY_ID
93
- events_statements_history_long, added column QUERY_ID
94
95
80015:
96
97
performance_schema.keyring_keys
98
99
80017: -- WARNING, EXPOSED BY MySQL 8.0.16 --
100
101
Unfortunately, MySQL 8.0.16 claim the 80017 tag, due to a bad merge.
102
performance_schema tables changed in MySQL 8.0.16
103
- replication_connection_configuration, added column NETWORK_NAMESPACE
104
105
800171: -- WARNING, EXPOSED BY MySQL 8.0.17 --
106
---------------------------------------------------------------------
107
IMPORTANT NOTE:
108
The release 8.0.16 made use of version 80017 incorrectly, which makes
109
the upgrade from 8.0.16 to 8.0.17 release immutable. This was
110
introduced by WL#12720.
111
112
In order to allow upgrade from 8.0.16 to 8.0.17, we choose the new
113
version number as 800171 for 8.0.17 release. Going forward the
114
release 8.0.18 would use 80018.
115
116
Note that, any comparison between two PFS version numbers should be
117
carefully done.
118
---------------------------------------------------------------------
119
120
performance_schema tables changed in MySQL 8.0.17
121
- WL#12571 increases the HOST name length from 60 to 255.
122
123
80018:
124
125
performance_schema tables changed in MySQL 8.0.18
126
- replication_connection_configuration, added column
127
MASTER_COMPRESSION_ALGORITHMS, MASTER_COMPRESSION_LEVEL
128
- replication_applier_configuration, added column
129
PRIVILEGE_CHECKS_USER
130
131
80019:
132
133
performance_schema tables changed in MySQL 8.0.19
134
- replication_connection_configuration, added column
135
TLS_CIPHERSUITES
136
- replication_applier_configuration, added column
137
REQUIRE_ROW_FORMAT
138
139
80020:
140
141
performance_schema tables changed in MySQL 8.0.20
142
- WL#3549 created binary_log_transaction_compression_stats
143
- replication_applier_configuration, added column
144
REQUIRE_TABLE_PRIMARY_KEY_CHECK
145
146
80021:
147
148
performance_schema tables changed in MySQL 8.0.21
149
- tls_channel_status (created)
150
- replication_connection_configuration, added column
151
SOURCE_CONNECTION_AUTO_FAILOVER
152
153
80022:
154
155
performance_schema tables changed in MySQL 8.0.22
156
- WL#9090 created processlist
157
- WL#13681 created error_log
158
159
80023:
160
161
performance_schema tables changed in MySQL 8.0.23
162
- WL#12819 replication_applier_configuration, added column
163
ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPE
164
ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUE
165
- performance_schema.replication_asynchronous_connection_failover,
166
added column MANAGED_NAME
167
- added table
168
performance_schema.replication_asynchronous_connection_failover_managed
169
170
80024:
171
172
performance_schema tables changed in MySQL 8.0.24
173
- WL#13446 added performance_schema.keyring_component_status
174
175
80027:
176
177
performance_schema tables changed in MySQL 8.0.27
178
- WL#9852 added replication_group_members column
179
MEMBER_COMMUNICATION_PROTOCOL_STACK
180
- Bug#32701593:'SELECT FROM
181
PS.REPLICATION_ASYNCHRONOUS_CONNECTION_FAILOVER' DIDN'T RETURN A RE
182
- WL#7491 added the column to replication_connection_configuration
183
the column GTID_ONLY
184
- BUG#104643 Defaults in performance schema tables incompatible with sql_mode
185
fixed TIMESTAMP columns (removed default 0)
186
fixed DOUBLE columns (removed sign)
187
188
80028:
189
190
performance_schema tables changed in MySQL 8.0.28
191
- WL#14779 PERFORMANCE_SCHEMA, ADD CPU TIME TO STATEMENT METRICS
192
added CPU_TIME, SUM_CPU_TIME columns.
193
- Fixed performance_schema.processlist host column to size 261.
194
195
80029:
196
197
performance_schema tables changed in MySQL 8.0.29
198
- WL#14346 PERFORMANCE_SCHEMA, SECONDARY_ENGINE STATS
199
Added columns EXECUTION_ENGINE, COUNT_SECONDARY
200
- Bug #30624990 NO UTF8MB3 IN INFORMATION_SCHEMA.CHARACTER_SETS
201
Use 'utf8mb3' rather than 'utf8' alias for for character set names.
202
203
80030:
204
205
performance_schema tables changed in MySQL 8.0.30
206
- WL#12527 added innodb_redo_log_files table (table is created dynamically
207
and based on PFS_engine_table_share_proxy mechanism)
208
- Bug #33787300 Rename utf8_xxx collations to utf8mb3_xxx
209
This patch renames utf8_bin to utf8mb3_bin
210
This patch renames utf8_general_ci
211
212
80031:
213
214
- WL#14432 Session memory limits in performance schema
215
Modified column PROPERTIES in table setup_instruments
216
Added column FLAGS in table setup_instruments
217
218
80032:
219
220
- WL#15419: Make the replica_generate_invisible_primary_key option settable
221
per channel
222
Modified column REQUIRE_TABLE_PRIMARY_KEY_CHECK in table
223
replication_applier_configuration
224
225
80033:
226
227
- WL#15059: PERFORMANCE_SCHEMA, OTEL TRACE INTERFACE
228
New column TELEMETRY_ACTIVE added to performance_schema.threads
229
*/
230
231
static
const
uint
PFS_DD_VERSION
= 80033;
232
233
#endif
/* PFS_DD_VERSION_H */
PFS_DD_VERSION
static const uint PFS_DD_VERSION
The version of the current performance_schema database schema.
Definition:
pfs_dd_version.h:231
storage
perfschema
pfs_dd_version.h
Generated by
1.9.2