Search Results
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-information-commands.html
In addition, you can obtain information about mysql client commands that are independent of the MySQL server and thus are also available for use when connected to the MySQL Cluster Manager agent. You can also use most standard mysql client commands ... Online help is available in the MySQL Cluster Manager client for MySQL Cluster Manager client ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-preparation.html
(See Section 19.2.1, “Replication Formats”.) In addition, we strongly recommend enabling the replica_allow_batching system variable (the default). Preparing the NDB Cluster for replication consists of the following steps: Check all MySQL ...To ...
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
See the description of the ndb_join_pushdown server system variable for more information and examples. If you restrict queries with the max_join_size system variable, this row product also is used to determine which multiple-table SELECT statements ...For DEPENDENT SUBQUERY, the subquery is re-evaluated only once for each set of different values of the variables from its outer ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-networking.html
If not set, the value of system variable 'max_allowed_packet' will be used to initialize this upon connecting. Default Value 1080 Since Version 5.1.34 socketFactory The name of the class that the driver should use for creating socket connections to ... socksProxyHost Name or IP address of a SOCKS host to connect ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-audit.html
This location of the audit log file can be changed at server startup using the audit_log_file system variable. audit-log=FORCE_PLUS_PERMANENT Restart the server to apply the configuration change: $> systemctl restart mysqld By default, rule-based ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-networking.html
If not set, the value of system variable 'max_allowed_packet' will be used to initialize this upon connecting. Default Value 1080 Since Version 5.1.34 socketFactory The name of the class that the driver should use for creating socket connections to ... socksProxyHost Name or IP address of a SOCKS host to connect ...
https://dev.mysql.com/doc/refman/8.4/en/known-issues.html
Even if you use lower_case_table_names=2 (which enables MySQL to remember the case used for databases and table names), MySQL does not remember the case used for database names for the function DATABASE() or within the various logs (on ... This ...
https://dev.mysql.com/doc/refman/8.4/en/metadata-locking.html
Metadata Lock Acquisition Metadata Lock Release Metadata Lock Acquisition If there are multiple waiters for a given lock, the highest-priority lock request is satisfied first, with an exception related to the max_write_lock_count system variable.
https://dev.mysql.com/doc/refman/8.4/en/replication-channels.html
A multi-source replica can also be set up as a multi-threaded replica, by setting the system variable replica_parallel_workers to a value greater than 0. In MySQL multi-source replication, a replica opens multiple replication channels, one for each ...The replication channels represent the path of transactions flowing from a source to the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-per-table-tablespaces.html
Changing the setting at runtime requires privileges sufficient to set global system variables. A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file system in a single data file. Disabling ...