Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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
135 Views
Advertisements