What options and variables have been removed in MySQL 8.0?

Listed below are some options and variables that have been removed in MySQL 8.0:

• innodb_available_undo_logs: It refers to the InnoDB return The total number of rolling segments. It is different from innodb_rollback_segments, which shows the number of active rollback segments. Removed in MySQL 8.0.2.
• Qcache_free_blocks: It refers to the number of free memory blocks in the query cache. It was removed in MySQL 8.0.3.
• Qcache_free_memory: It refers to the amount of memory available for the query cache. It was removed in MySQL 8.0.3.
• bootstrap: It is used by the MySQL installation script. It was removed in MySQL 8.0.0.
• date_format: It is the DATE format (not used). It was removed in MySQL 8.0.3.
• datetime_format: It is the DATETIME/TIMESTAMP format (not used). Removed in MySQL 8.0.3.
• innodb_file_format_check: It determines whether InnoDB performs file format compatibility checks. It was removed in MySQL 8.0.0.
• innodb_file_format_max: It refers to the file format mark present in the shared table space. It was removed in MySQL 8.0.0.
• Partitioning: It helps to enable (or disable) partitioning support. It was removed in MySQL 8.0.0.
• query_cache_limit: It recommends that cached results larger than a certain number should not be cached. It was removed in MySQL 8.0.3.
• query_cache_size: It refers to the memory allocated to store old query results. It was removed in MySQL 8.0.3.
• skip-partition: It ensures that user-defined partitions are not enabled. It was removed in MySQL 8.0.0.
• time_format: TIME format (not used). It was removed in MySQL 8.0.3.
• tx_isolation: It is the default transaction isolation level. Removed in MySQL 8.0.3.
• tx_read_only: It is the default transaction access mode. It was removed in MySQL 8.0.3.

The above is the detailed content of What options and variables have been removed in MySQL 8.0?. For more information, please follow other related articles on the PHP Chinese website!