Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
Description
According to the KB as of 2019-02-19, at least the following options / variables have been deprecated, but not mentioned as removed:
option / variable | first version where it was deprecated | removed in 10.5 by |
---|---|---|
--log-bin-trust-routine-creators | 5.0.16 (MySQL) ? | 5.5.20 alpha |
--delay-key-write-for-all-tables | 5.0 (MySQL) | 5.5.20 alpha |
--default-collation | 5.0 (MySQL) | 5.5.20 alpha |
--enable-locking | 5.0 (MySQL) | 5.5.20 alpha |
--log-long-format | 5.0 (MySQL) | 5.5.20 alpha |
--log-update | 5.0 (MySQL) | 5.5.20 alpha |
--one-thread | ? | |
--set-variable | 5.0 (MySQL) | 5.5.20 alpha |
--skip-locking | 5.0 (MySQL) | 5.5.20 alpha |
--use-symbolic-links | 5.0 (MySQL) | 5.5.20 alpha |
--warnings | 5.0 (MySQL) | 5.5.20 alpha |
max_long_data_size | 5.5 | |
multi_range_count | 5.1, ignored from 5.3 | |
optimizer_switch.engine_condition_pushdown | 10.1.1 | |
storage_engine | 5.5 - in variable description, not with Warning | |
thread_concurrency | 5.5 | |
timed_mutexes | 5.5.39 | |
mroonga_default_parser | mroonga 5.04 | |
innodb_buffer_pool_populate | 10.0.23 | |
innodb_checksums | 10.0 | |
innodb_cleaner_lsn_age_factor | 10.2.6 | |
innodb_corrupt_table_action | 10.2.6 | |
innodb_empty_free_list_algorithm | 10.2.6 | |
innodb_fake_changes | 10.2.6 | |
innodb_foreground_preflush | 10.2.6 | |
innodb_kill_idle_transaction | 10.2.6 | |
innodb_locking_fake_changes | 10.2.6 | |
innodb_locks_unsafe_for_binlog | 10.0 | |
innodb_log_arch_dir | 10.2.6 | |
innodb_log_arch_expire_sec | 10.2.6 | |
innodb_log_archive | 10.2.6 | |
innodb_log_block_size | 10.2.6 | |
innodb_log_checksum_algorithm | 10.2.6 | |
innodb_max_bitmap_file_size | 10.2.6 | |
innodb_max_changed_pages | 10.2.6 | |
innodb_rollback_segments | 10.0 | |
innodb_sched_priority_cleaner | 10.2.6 | |
innodb_show_locks_held | 10.2.6 | |
innodb_show_verbose_locks | 10.2.6 | |
innodb_stats_sample_pages | 10.0 | |
innodb_track_changed_pages | 10.2.6 | |
innodb_track_redo_log_now | 10.2.6 | |
innodb_use_global_flush_log_at_trx_commit | 10.2.6 | |
innodb_use_stacktrace | 10.2.6 |
At some point, a cleanup needs to be done: either we should remove them, or we should introduce a concept of eternal deprecation, when an option/variable is accepted on startup (with a warning), but is otherwise ignored – cannot be seen or set or used at runtime.
Attachments
Issue Links
- is part of
-
MDEV-21475 storage_engine system variable has been marked as deprecated in 5.5, but warnings not issued
- Closed
- relates to
-
MDEV-6999 Remove or deprecate unused variables
- Closed
-
MDEV-19534 Make innodb_checksum_algorithm=full_crc32 by default, and remove innodb_checksums
- Closed
-
MDEV-19544 Remove innodb_locks_unsafe_for_binlog
- Closed
-
MDEV-19551 Remove alias innodb_stats_sample_pages
- Closed
-
MDEV-19563 Galera depends on deprecated option innodb_locks_unsafe_for_binlog
- Closed
-
MDEV-19570 Deprecate and ignore innodb_undo_logs, remove innodb_rollback_segments
- Closed