Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.0 •The following  InnoDB  file format variables were removed: • innodb_file_format • innodb_file_format_check • innodb_file_format_max • innodb_large_prefix •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. •Options and Variables Introduced in MySQL 8.0 •Options and Variables Deprecated in MySQL 8.0 1.4 Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.0 50 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.