WL#10473: InnoDB: Deprecate innodb_undo_tablespaces in 5.7
Affects: Server-8.0 — Status: Complete
The default value of innodb-undo-tablespaces has been changed to 2. The minimum value of innodb-undo-tablespaces has been changed to 2. We will quit using innodb-undo-tablespaces and use a hard coded number of auto-generated undo tablespaces. The design is that innodb-undo-tablespaces will be deleted and the default value of 2 implicit undo tablespaces will be hard-coded so that there will be only one way to create and drop undo tablespaces. So the latest version of 5.7 needs to be documented that this setting is deprecated in a future version. This setting is a global read-only variable, command line only, so it does not have any user interface other than its description. It must be mostly deprecated in the documentation.
The setting --innodb-undo-tablespaces is a global read-only variable. It is only used on the command line or in the config file. It does not have any user interface other than its description. We will add the phrase "(deprecated)" to that description, which is declared to the MySQL server with the setting. But I am not aware of any way to show that description is SQL. Therfore, most of the effort to deprecate this setting must be done in the documentation.
Copyright (c) 2000, 2020, Oracle Corporation and/or its affiliates. All rights reserved.