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


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.

Updated on: 24-Feb-2021

168 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements