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
231static const uint PFS_DD_VERSION = 80033;
232
233#endif /* PFS_DD_VERSION_H */
static const uint PFS_DD_VERSION
The version of the current performance_schema database schema.
Definition: pfs_dd_version.h:231