Rechercher dans le manuel MySQL
This section lists server variables, status variables, and options that were added for the first time, have been deprecated, or have been removed in MySQL 8.0.
Options and Variables Introduced in MySQL 8.0
The following system variables, status variables, and options are new in MySQL 8.0, and have not been included in any previous release series.
Acl_cache_items_count: Added in MySQL 8.0.0.Audit_log_current_size: Added in MySQL 8.0.11.Audit_log_event_max_drop_size: Added in MySQL 8.0.11.Audit_log_events: Added in MySQL 8.0.11.Audit_log_events_filtered: Added in MySQL 8.0.11.Audit_log_events_lost: Added in MySQL 8.0.11.Audit_log_events_written: Added in MySQL 8.0.11.Audit_log_total_size: Added in MySQL 8.0.11.Audit_log_write_waits: Added in MySQL 8.0.11.Caching_sha2_password_rsa_public_key: Added in MySQL 8.0.4.Com_alter_resource_group: Added in MySQL 8.0.3.Com_alter_user_default_role: Added in MySQL 8.0.0.Com_create_resource_group: Added in MySQL 8.0.3.Com_create_role: Added in MySQL 8.0.0.Com_drop_resource_group: Added in MySQL 8.0.3.Com_drop_role: Added in MySQL 8.0.0.Com_grant_roles: Added in MySQL 8.0.0.Com_install_component: Added in MySQL 8.0.0.Com_revoke_roles: Added in MySQL 8.0.0.Com_set_resource_group: Added in MySQL 8.0.3.Com_set_role: Added in MySQL 8.0.0.Com_uninstall_component: Added in MySQL 8.0.0.Connection_control_delay_generated: Added in MySQL 8.0.1.Firewall_access_denied: Added in MySQL 8.0.11.Firewall_access_granted: Added in MySQL 8.0.11.Firewall_cached_entries: Added in MySQL 8.0.11.Secondary_engine_execution_count: Added in MySQL 8.0.13.activate_all_roles_on_login: Added in MySQL 8.0.2.admin_address: Added in MySQL 8.0.14.admin_port: Added in MySQL 8.0.14.audit-log: Added in MySQL 8.0.11.audit_log_buffer_size: Added in MySQL 8.0.11.audit_log_compression: Added in MySQL 8.0.11.audit_log_connection_policy: Added in MySQL 8.0.11.audit_log_current_session: Added in MySQL 8.0.11.audit_log_encryption: Added in MySQL 8.0.11.audit_log_exclude_accounts: Added in MySQL 8.0.11.audit_log_file: Added in MySQL 8.0.11.audit_log_filter_id: Added in MySQL 8.0.11.audit_log_flush: Added in MySQL 8.0.11.audit_log_format: Added in MySQL 8.0.11.audit_log_include_accounts: Added in MySQL 8.0.11.audit_log_policy: Added in MySQL 8.0.11.audit_log_read_buffer_size: Added in MySQL 8.0.11.audit_log_rotate_on_size: Added in MySQL 8.0.11.audit_log_statement_policy: Added in MySQL 8.0.11.audit_log_strategy: Added in MySQL 8.0.11.authentication_ldap_sasl_auth_method_name: Added in MySQL 8.0.11.authentication_ldap_sasl_bind_base_dn: Added in MySQL 8.0.11.authentication_ldap_sasl_bind_root_dn: Added in MySQL 8.0.11.authentication_ldap_sasl_bind_root_pwd: Added in MySQL 8.0.11.authentication_ldap_sasl_ca_path: Added in MySQL 8.0.11.authentication_ldap_sasl_group_search_attr: Added in MySQL 8.0.11.authentication_ldap_sasl_group_search_filter: Added in MySQL 8.0.11.authentication_ldap_sasl_init_pool_size: Added in MySQL 8.0.11.authentication_ldap_sasl_log_status: Added in MySQL 8.0.11.authentication_ldap_sasl_max_pool_size: Added in MySQL 8.0.11.authentication_ldap_sasl_server_host: Added in MySQL 8.0.11.authentication_ldap_sasl_server_port: Added in MySQL 8.0.11.authentication_ldap_sasl_tls: Added in MySQL 8.0.11.authentication_ldap_sasl_user_search_attr: Added in MySQL 8.0.11.authentication_ldap_simple_auth_method_name: Added in MySQL 8.0.11.authentication_ldap_simple_bind_base_dn: Added in MySQL 8.0.11.authentication_ldap_simple_bind_root_dn: Added in MySQL 8.0.11.authentication_ldap_simple_bind_root_pwd: Added in MySQL 8.0.11.authentication_ldap_simple_ca_path: Added in MySQL 8.0.11.authentication_ldap_simple_group_search_attr: Added in MySQL 8.0.11.authentication_ldap_simple_group_search_filter: Added in MySQL 8.0.11.authentication_ldap_simple_init_pool_size: Added in MySQL 8.0.11.authentication_ldap_simple_log_status: Added in MySQL 8.0.11.authentication_ldap_simple_max_pool_size: Added in MySQL 8.0.11.authentication_ldap_simple_server_host: Added in MySQL 8.0.11.authentication_ldap_simple_server_port: Added in MySQL 8.0.11.authentication_ldap_simple_tls: Added in MySQL 8.0.11.authentication_ldap_simple_user_search_attr: Added in MySQL 8.0.11.authentication_windows_log_level: Added in MySQL 8.0.11.authentication_windows_use_principal_name: Added in MySQL 8.0.11.binlog_expire_logs_seconds: Added in MySQL 8.0.1.binlog_row_metadata: Added in MySQL 8.0.1.binlog_row_value_options: Added in MySQL 8.0.3.binlog_transaction_dependency_history_size: Added in MySQL 8.0.1.binlog_transaction_dependency_tracking: Added in MySQL 8.0.1.caching_sha2_password_auto_generate_rsa_keys: Added in MySQL 8.0.4.caching_sha2_password_private_key_path: Added in MySQL 8.0.3.caching_sha2_password_public_key_path: Added in MySQL 8.0.3.connection_control_failed_connections_threshold: Added in MySQL 8.0.1.connection_control_max_connection_delay: Added in MySQL 8.0.1.connection_control_min_connection_delay: Added in MySQL 8.0.1.create_admin_listener_thread: Added in MySQL 8.0.14.cte_max_recursion_depth: Added in MySQL 8.0.3.default_collation_for_utf8mb4: Added in MySQL 8.0.11.dragnet.Status: Added in MySQL 8.0.12.dragnet.log_error_filter_rules: Added in MySQL 8.0.4.early-plugin-load: Added in MySQL 8.0.0.group_replication_communication_debug_options: Added in MySQL 8.0.3.group_replication_flow_control_hold_percent: Added in MySQL 8.0.2.group_replication_flow_control_max_commit_quota: Added in MySQL 8.0.2.group_replication_flow_control_member_quota_percent: Added in MySQL 8.0.2.group_replication_flow_control_min_quota: Added in MySQL 8.0.2.group_replication_flow_control_min_recovery_quota: Added in MySQL 8.0.2.group_replication_flow_control_period: Added in MySQL 8.0.2.group_replication_flow_control_release_percent: Added in MySQL 8.0.2.group_replication_member_expel_timeout: Added in MySQL 8.0.13.group_replication_member_weight: Added in MySQL 8.0.2.group_replication_recovery_get_public_key: Added in MySQL 8.0.4.group_replication_recovery_public_key_path: Added in MySQL 8.0.4.group_replication_unreachable_majority_timeout: Added in MySQL 8.0.2.histogram_generation_max_mem_size: Added in MySQL 8.0.2.information_schema_stats_expiry: Added in MySQL 8.0.3.innodb_buffer_pool_debug: Added in MySQL 8.0.0.innodb_buffer_pool_in_core_file: Added in MySQL 8.0.14.innodb_checkpoint_disabled: Added in MySQL 8.0.2.innodb_ddl_log_crash_reset_debug: Added in MySQL 8.0.3.innodb_deadlock_detect: Added in MySQL 8.0.0.innodb_dedicated_server: Added in MySQL 8.0.3.innodb_directories: Added in MySQL 8.0.4.innodb_fsync_threshold: Added in MySQL 8.0.13.innodb_log_checkpoint_fuzzy_now: Added in MySQL 8.0.13.innodb_log_spin_cpu_abs_lwm: Added in MySQL 8.0.11.innodb_log_spin_cpu_pct_hwm: Added in MySQL 8.0.11.innodb_log_wait_for_flush_spin_hwm: Added in MySQL 8.0.11.innodb_parallel_read_threads: Added in MySQL 8.0.14.innodb_print_ddl_logs: Added in MySQL 8.0.3.innodb_redo_log_encrypt: Added in MySQL 8.0.1.innodb_scan_directories: Added in MySQL 8.0.2.innodb_stats_include_delete_marked: Added in MySQL 8.0.1.innodb_temp_tablespaces_dir: Added in MySQL 8.0.13.innodb_tmpdir: Added in MySQL 8.0.0.innodb_undo_log_encrypt: Added in MySQL 8.0.1.internal_tmp_mem_storage_engine: Added in MySQL 8.0.2.keyring-migration-destination: Added in MySQL 8.0.4.keyring-migration-host: Added in MySQL 8.0.4.keyring-migration-password: Added in MySQL 8.0.4.keyring-migration-port: Added in MySQL 8.0.4.keyring-migration-socket: Added in MySQL 8.0.4.keyring-migration-source: Added in MySQL 8.0.4.keyring-migration-user: Added in MySQL 8.0.4.keyring_aws_cmk_id: Added in MySQL 8.0.11.keyring_aws_conf_file: Added in MySQL 8.0.11.keyring_aws_data_file: Added in MySQL 8.0.11.keyring_aws_region: Added in MySQL 8.0.11.keyring_encrypted_file_data: Added in MySQL 8.0.11.keyring_encrypted_file_password: Added in MySQL 8.0.11.keyring_okv_conf_dir: Added in MySQL 8.0.11.keyring_operations: Added in MySQL 8.0.4.log_error_filter_rules: Added in MySQL 8.0.2.log_error_services: Added in MySQL 8.0.2.log_error_suppression_list: Added in MySQL 8.0.13.log_slow_extra: Added in MySQL 8.0.14.mandatory_roles: Added in MySQL 8.0.2.mysql_firewall_mode: Added in MySQL 8.0.11.mysql_firewall_trace: Added in MySQL 8.0.11.mysqlx: Added in MySQL 8.0.11.mysqlx-interactive-timeout: Added in MySQL 8.0.4.mysqlx-port-read-timeout: Added in MySQL 8.0.4.mysqlx-wait-timeout: Added in MySQL 8.0.4.mysqlx-write-timeout: Added in MySQL 8.0.4.mysqlx_interactive_timeout: Added in MySQL 8.0.4.mysqlx_read_timeout: Added in MySQL 8.0.4.mysqlx_wait_timeout: Added in MySQL 8.0.4.mysqlx_write_timeout: Added in MySQL 8.0.4.no-dd-upgrade: Added in MySQL 8.0.4.no-monitor: Added in MySQL 8.0.12.original_commit_timestamp: Added in MySQL 8.0.1.password_history: Added in MySQL 8.0.3.password_require_current: Added in MySQL 8.0.13.password_reuse_interval: Added in MySQL 8.0.3.performance_schema_max_digest_sample_age: Added in MySQL 8.0.3.persist_only_admin_x509_subject: Added in MySQL 8.0.14.persisted_globals_load: Added in MySQL 8.0.0.regexp_stack_limit: Added in MySQL 8.0.4.regexp_time_limit: Added in MySQL 8.0.4.resultset_metadata: Added in MySQL 8.0.3.rpl_read_size: Added in MySQL 8.0.11.show_create_table_verbosity: Added in MySQL 8.0.11.sql_require_primary_key: Added in MySQL 8.0.13.ssl_fips_mode: Added in MySQL 8.0.11.syseventlog.facility: Added in MySQL 8.0.13.syseventlog.include_pid: Added in MySQL 8.0.13.syseventlog.tag: Added in MySQL 8.0.13.temptable_max_ram: Added in MySQL 8.0.2.thread_pool_algorithm: Added in MySQL 8.0.11.thread_pool_high_priority_connection: Added in MySQL 8.0.11.thread_pool_max_unused_threads: Added in MySQL 8.0.11.thread_pool_prio_kickup_timer: Added in MySQL 8.0.11.thread_pool_size: Added in MySQL 8.0.11.thread_pool_stall_limit: Added in MySQL 8.0.11.use_secondary_engine: Added in MySQL 8.0.13.validate_password.check_user_name: Added in MySQL 8.0.4.validate_password.dictionary_file: Added in MySQL 8.0.4.validate_password.dictionary_file_last_parsed: Added in MySQL 8.0.4.validate_password.dictionary_file_words_count: Added in MySQL 8.0.4.validate_password.length: Added in MySQL 8.0.4.validate_password.mixed_case_count: Added in MySQL 8.0.4.validate_password.number_count: Added in MySQL 8.0.4.validate_password.policy: Added in MySQL 8.0.4.validate_password.special_char_count: Added in MySQL 8.0.4.version_compile_zlib: Added in MySQL 8.0.11.windowing_use_high_precision: Added in MySQL 8.0.2.
Options and Variables Deprecated in MySQL 8.0
The following system variables, status variables, and options have been deprecated in MySQL 8.0.
expire_logs_days: Purge binary logs after this many days. Deprecated as of MySQL 8.0.3.innodb_undo_tablespaces: The number of tablespace files that rollback segments are divided between. Deprecated as of MySQL 8.0.4.log_syslog: Whether to write error log to syslog. Deprecated as of MySQL 8.0.2.symbolic-links: Permit symbolic links for MyISAM tables. Deprecated as of MySQL 8.0.2.
The following system variables, status variables, and options have been removed in MySQL 8.0.
Com_alter_db_upgrade: Count of ALTER DATABASE ... UPGRADE DATA DIRECTORY NAME statements. Removed in MySQL 8.0.0.Innodb_available_undo_logs: Display the total number of InnoDB rollback segments; different from innodb_rollback_segments, which displays the number of active rollback segments. Removed in MySQL 8.0.2.Qcache_free_blocks: Number of free memory blocks in the query cache. Removed in MySQL 8.0.3.Qcache_free_memory: The amount of free memory for the query cache. Removed in MySQL 8.0.3.Qcache_hits: Number of query cache hits. Removed in MySQL 8.0.3.Qcache_inserts: Number of query cache inserts. Removed in MySQL 8.0.3.Qcache_lowmem_prunes: Number of queries that were deleted from the query cache due to lack of free memory in the cache. Removed in MySQL 8.0.3.Qcache_not_cached: Number of noncached queries (not cacheable, or not cached due to the query_cache_type setting). Removed in MySQL 8.0.3.Qcache_queries_in_cache: Number of queries registered in the query cache. Removed in MySQL 8.0.3.Qcache_total_blocks: The total number of blocks in the query cache. Removed in MySQL 8.0.3.Slave_heartbeat_period: The slave's replication heartbeat interval, in seconds. Removed in MySQL 8.0.1.Slave_last_heartbeat: Shows when the latest heartbeat signal was received, in TIMESTAMP format. Removed in MySQL 8.0.1.Slave_received_heartbeats: Number of heartbeats received by a replication slave since previous reset. Removed in MySQL 8.0.1.Slave_retried_transactions: The total number of times since startup that the replication slave SQL thread has retried transactions. Removed in MySQL 8.0.1.Slave_running: The state of this server as a replication slave (slave I/O thread status). Removed in MySQL 8.0.1.bootstrap: Used by mysql installation scripts. Removed in MySQL 8.0.0.date_format: The DATE format (unused). Removed in MySQL 8.0.3.datetime_format: The DATETIME/TIMESTAMP format (unused). Removed in MySQL 8.0.3.des-key-file: Load keys for des_encrypt() and des_encrypt from given file. Removed in MySQL 8.0.3.group_replication_allow_local_disjoint_gtids_join: Allow the current server to join the group even if it has transactions not present in the group. Removed in MySQL 8.0.4.have_crypt: Availability of the crypt() system call. Removed in MySQL 8.0.3.ignore-builtin-innodb: Ignore the built-in InnoDB. Removed in MySQL 8.0.3.ignore-db-dir: Treat directory as nondatabase directory. Removed in MySQL 8.0.0.ignore_db_dirs: Directories treated as nondatabase directories. Removed in MySQL 8.0.0.innodb_checksums: Enable InnoDB checksums validation. Removed in MySQL 8.0.0.innodb_disable_resize_buffer_pool_debug: Disables resizing of the InnoDB buffer pool. Removed in MySQL 8.0.0.innodb_file_format: The format for new InnoDB tables. Removed in MySQL 8.0.0.innodb_file_format_check: Whether InnoDB performs file format compatibility checking. Removed in MySQL 8.0.0.innodb_file_format_max: The file format tag in the shared tablespace. Removed in MySQL 8.0.0.innodb_large_prefix: Enables longer keys for column prefix indexes. Removed in MySQL 8.0.0.innodb_locks_unsafe_for_binlog: Force InnoDB not to use next-key locking. Instead use only row-level locking. Removed in MySQL 8.0.0.innodb_stats_sample_pages: Number of index pages to sample for index distribution statistics. Removed in MySQL 8.0.0.innodb_support_xa: Enable InnoDB support for the XA two-phase commit. Removed in MySQL 8.0.0.innodb_undo_logs: Defines the number of undo logs (rollback segments) used by InnoDB; an alias for innodb_rollback_segments. Removed in MySQL 8.0.2.log-warnings: Log some noncritical warnings to the log file. Removed in MySQL 8.0.3.log_builtin_as_identified_by_password: Whether to log CREATE/ALTER USER, GRANT in backward-compatible fashion. Removed in MySQL 8.0.11.log_error_filter_rules: Filter rules for error logging. Removed in MySQL 8.0.4.log_syslog: Whether to write error log to syslog. Removed in MySQL 8.0.13.log_syslog_facility: Facility for syslog messages. Removed in MySQL 8.0.13.log_syslog_include_pid: Whether to include server PID in syslog messages. Removed in MySQL 8.0.13.log_syslog_tag: Tag for server identifier in syslog messages. Removed in MySQL 8.0.13.max_tmp_tables: Unused. Removed in MySQL 8.0.3.metadata_locks_cache_size: Size of the metadata locks cache. Removed in MySQL 8.0.13.metadata_locks_hash_instances: Number of metadata lock hashes. Removed in MySQL 8.0.13.multi_range_count: The maximum number of ranges to send to a table handler at once during range selects. Removed in MySQL 8.0.3.old_passwords: Selects password hashing method for PASSWORD(). Removed in MySQL 8.0.11.partition: Enable (or disable) partitioning support. Removed in MySQL 8.0.0.query_cache_limit: Do not cache results that are bigger than this. Removed in MySQL 8.0.3.query_cache_min_res_unit: Minimal size of unit in which space for results is allocated (last unit will be trimmed after writing all result data). Removed in MySQL 8.0.3.query_cache_size: The memory allocated to store results from old queries. Removed in MySQL 8.0.3.query_cache_type: Query cache type. Removed in MySQL 8.0.3.query_cache_wlock_invalidate: Invalidate queries in query cache on LOCK for write. Removed in MySQL 8.0.3.secure-auth: Disallow authentication for accounts that have old (pre-4.1) passwords. Removed in MySQL 8.0.3.show_compatibility_56: Compatibility for SHOW STATUS/VARIABLES. Removed in MySQL 8.0.1.skip-partition: Do not enable user-defined partitioning. Removed in MySQL 8.0.0.sync_frm: Sync .frm to disk on create. Enabled by default. Removed in MySQL 8.0.0.temp-pool: Using this option will cause most temporary files created to use a small set of names, rather than a unique name for each new file. Removed in MySQL 8.0.1.time_format: The TIME format (unused). Removed in MySQL 8.0.3.tx_isolation: The default transaction isolation level. Removed in MySQL 8.0.3.tx_read_only: Default transaction access mode. Removed in MySQL 8.0.3.
Traduction non disponible
Le manuel MySQL n'est pas encore traduit en français sur l'infobrol. Seule la version anglaise est disponible pour l'instant.
Document créé le 26/06/2006, dernière modification le 26/10/2018
Source du document imprimé : https://www.gaudry.be/mysql-rf-added-deprecated-removed.html
L'infobrol est un site personnel dont le contenu n'engage que moi. Le texte est mis à disposition sous licence CreativeCommons(BY-NC-SA). Plus d'info sur les conditions d'utilisation et sur l'auteur.
Références
Ces références et liens indiquent des documents consultés lors de la rédaction de cette page, ou qui peuvent apporter un complément d'information, mais les auteurs de ces sources ne peuvent être tenus responsables du contenu de cette page.
L'auteur de ce site est seul responsable de la manière dont sont présentés ici les différents concepts, et des libertés qui sont prises avec les ouvrages de référence. N'oubliez pas que vous devez croiser les informations de sources multiples afin de diminuer les risques d'erreurs.
