Search Results
https://dev.mysql.com/doc/refman/8.4/en/derived-table-optimization.html
It is possible to disable merging by using in the subquery any constructs that prevent merging, although these are not as explicit in their effect on materialization. The optimizer handles derived tables, view references, and common table ...
https://dev.mysql.com/doc/refman/8.4/en/encrypted-connection-protocols-ciphers.html
Unless you intend to disable encrypted connections, the list of permitted protocols should not be empty. MySQL supports multiple TLS protocols and ciphers, and enables configuring which protocols and ciphers to permit for encrypted connections. It ...
https://dev.mysql.com/doc/refman/8.4/en/engine-condition-pushdown-optimization.html
To disable it at server startup, set the optimizer_switch system variable's engine_condition_pushdown flag to off. For example, in a my.cnf file, use these lines: [mysqld] optimizer_switch=engine_condition_pushdown=off At runtime, disable condition ... This optimization improves the efficiency of direct comparisons between a nonindexed column and a ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-components.html
This section describes the characteristics of individual error log components. For general information about configuring error logging, see Section 7.4.2, “The Error Log”. A log component can be a filter or a sink: A filter processes log ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-configuration.html
To disable a log component, remove it from the log_error_services value. To disable a log component, remove it from the log_error_services value. In MySQL 8.4, error logging uses the MySQL component architecture described at Section 7.5, “MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/events-overview.html
(By default, a recurring event's schedule begins as soon as it is created, and continues indefinitely, until it is disabled or dropped.) If a repeating event does not terminate within its scheduling interval, the result may be multiple instances of ... MySQL Events are tasks that run according to a ...
https://dev.mysql.com/doc/refman/8.4/en/events-privileges.html
To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system variable. In this example, the EVENT privilege on the schema myschema is removed from the jon@ghidora user account: REVOKE ...The EVENT privilege governs the creation, modification, and deletion of ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-innodb-change-buffer.html
When should the change buffer not be used? You might consider disabling the change buffer if the entire data set fits within the InnoDB buffer pool, if you have relatively few secondary indexes, or if you are using solid-state storage, where random ...What types of operations modify secondary indexes and result in change buffering? ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-installation.html
MySQL Workbench 6.3.4 or higher can install MySQL Enterprise Firewall, enable or disable an installed firewall, or uninstall the firewall. Note If installed, MySQL Enterprise Firewall involves some minimal overhead even when disabled. To verify ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-adding-instances.html
[mysqld] # # Disable other storage engines # disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY" # # Replication configuration parameters # server_id=2 gtid_mode=ON enforce_gtid_consistency=ON # # Group Replication configuration # ... At this point, the group has one member in it, server s1, which has some data in ...