Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-compatibility-upgrade.html
The deprecated Group Replication system variable group_replication_allow_local_lower_version_join can be used in such situations to override the normal compatibility policies. During an online upgrade procedure, if the group is in single-primary ...
https://dev.mysql.com/doc/refman/8.4/en/insert-optimization.html
If you are adding data to a nonempty table, you can tune the bulk_insert_buffer_size variable to make data insertion even faster. To optimize insert speed, combine many small operations into a single large operation. Ideally, you make a single ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tls-channel-status-table.html
(This is the case if any admin_tls_xxx or admin_ssl_xxx system variable is set to a value different from its default.) Otherwise, the administrative interface uses the same TLS context as the main interface. Connection interface TLS properties are ...The tls_channel_status table provides information about connection interface TLS properties: mysql> SELECT * FROM performance_schema.tls_channel_status\G *************************** ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-differing-tables.html
The global value of the system variable replica_type_conversions controls the type conversion mode used on the replica. A column's default value is determined by a number of factors, including its type, whether it is defined with a DEFAULT option, ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/connectors/en/connector-j-unix-socket.html
Connector/J does not natively support connections to MySQL Servers with Unix domain sockets. However, there is provision for using 3rd-party libraries that supply the function via a pluggable socket factory. Such a custom factory should implement ...
https://dev.mysql.com/doc/connector-j/en/connector-j-unix-socket.html
Connector/J does not natively support connections to MySQL Servers with Unix domain sockets. However, there is provision for using 3rd-party libraries that supply the function via a pluggable socket factory. Such a custom factory should implement ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-security.html
This can be changed by setting the audit_log_file system variable at server startup. For security reasons, audit log files should be written to a directory accessible only to the MySQL server and to users with a legitimate reason to view the log.
https://dev.mysql.com/doc/refman/8.4/en/binlog-replication-configuration-overview.html
The source and each replica must be configured with a unique ID (using the server_id system variable). This section describes replication between MySQL servers based on the binary log file position method, where the MySQL instance operating as the ...The information in the binary log is stored in different logging formats according to the database changes being ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-object-cache.html
For information about valid values for dictionary object cache configuration options, refer to Section 7.1.8, “Server System Variables”. Both caches store table definitions but serve different parts of the MySQL server. The dictionary object ...
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. This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. In such cases, the ...