What are the options and variables that were removed in MySQL 8.0?

MySQLMySQLi Database

Some of the options and variables that have been removed in MySQL 8.0 have been listed below:

  • innodb_available_undo_logs: It refers to the total number of InnoDB rollback segments. It is different from innodb_rollback_segments, which displays the number of active rollback segments. It was removed in MySQL 8.0.2.
  • Qcache_free_blocks: It refers to the number of free memory blocks in query cache. It was removed in MySQL 8.0.3.
  • Qcache_free_memory: It refers to the amount of free memory for the query cache. It was removed in MySQL 8.0.3.
  • bootstrap: It is used by MySQL installation scripts. It was removed in MySQL 8.0.0.
  • date_format: It is the DATE format (unused). It was removed in MySQL 8.0.3.
  • datetime_format: It is the DATETIME/TIMESTAMP format (unused). It was removed in MySQL 8.0.3.
  • innodb_file_format_check: It determines whether or not the InnoDB performs file format compatibility checking. It was removed in MySQL 8.0.0.
  • innodb_file_format_max: It refers to the file format tag present in shared tablespace. It was removed in MySQL 8.0.0.
  • partition: It helps enable (or disable) the partitioning support. It was removed in MySQL 8.0.0.
  • query_cache_limit: It suggests that cache results that are bigger than a specific amount shouldn’t be cached. It was removed in MySQL 8.0.3.
  • query_cache_size: It refers to the memory that is allocated to store results from old queries. It was removed in MySQL 8.0.3.
  • skip-partition: It ensures that user-defined partitioning is not enabled. It was removed in MySQL 8.0.0.
  • time_format: TIME format (unused). It was removed in MySQL 8.0.3.
  • tx_isolation: It is the default transaction isolation level. It was removed in MySQL 8.0.3.
  • tx_read_only: It is the default transaction access mode. It was removed in MySQL 8.0.3.
raja
Published on 12-Feb-2021 09:50:20
Advertisements