•The following InnoDB  file format variables were removed: 

• innodb_file_format 

• innodb_file_format_check 

• innodb_file_format_max 

• innodb_large_prefix 

File format variables were necessary for creating tables compatible with earlier versions of InnoDB in MySQL 5.1. Now that MySQL 5.1 has reached the end of its product lifecycle, these options are no longer required. 

The FILE_FORMAT  column was removed from the INNODB_TABLES  and INNODB_TABLESPACES Information Schema tables. 

•The innodb_support_xa  system variable, which enables support for two-phase commit in XA transactions, was removed. InnoDB  support for two-phase commit in XA transactions is always enabled. 

•Support for DTrace was removed. 

•The JSON_APPEND()  function was removed. Use JSON_ARRAY_APPEND()  instead. 

•Support for placing table partitions in shared InnoDB  tablespaces was removed in MySQL 8.0.13. Shared tablespaces include the InnoDB  system tablespace and general tablespaces. For information about identifying partitions in shared tablespaces and moving them to file-per-table tablespaces, see Section 2.11.5, “Preparing Your Installation for Upgrade” . 

•Support for setting user variables in statements other than SET  was deprecated in MySQL 8.0.13. This functionality is subject to removal in MySQL 9.0. 

•The --ndb perror  option was removed. Use the ndb_perror  utility instead. 

•The innodb_undo_logs  variable was removed. The innodb_rollback_segments  variables performs the same function and should be used instead. 

•The Innodb_available_undo_logs  status variable was removed. The number of available rollback segments per tablespace may be retrieved using SHOW VARIABLES LIKE ’innodb_rollback_segments’; 

•As of MySQL 8.0.14, the previously deprecated innodb_undo_tablespaces  variable is no longer configurable. For more information, see Section 15.6.3.4, “Undo Tablespaces” . 

•Support for the ALTER TABLE ... UPGRADE PARTITIONING  statement has been removed. 

•As of MySQL 8.0.16, support for the internal_tmp_disk_storage_engine  system variable has been removed; internal temporary tables on disk now always use the InnoDB  storage engine. See Storage Engine for On-Disk Internal Temporary Tables,for more information. 

•The DISABLE_SHARED CMake  option was unused and has been removed. 

## 1.4 Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.0 

•Options and Variables Introduced in MySQL 8.0 

•Options and Variables Deprecated in MySQL 8.0 

