Search Results
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-relaylog.html
The default relay log file and relay log index file names and locations can be overridden with, respectively, the relay_log and relay_log_index system variables (see Section 19.1.6, “Replication and Binary Logging Options and Variables”). On a ...For the default replication channel, relay log file names have the default form host_name-relay-bin.nnnnnn, where host_name is the name of the replica server host and nnnnnn is a sequence ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-unexpected-replica-halt.html
The details of the recovery process are influenced by the chosen method of replication, whether the replica is single-threaded or multithreaded, and the setting of relevant system variables. The system variable itself is also deprecated, so omit it ... In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before ...
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/myisam-maintenance-schedule.html
(These are “expected crashed tables.”) To cause the server to check MyISAM tables automatically, start it with the myisam_recover_options system variable set. You should also check your tables regularly during normal system operation. It is a ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-components-installation.html
$> mysql -u root -p -e "SET PERSIST_ONLY component_masking.masking_database=mask_db" Enter password: (enter root password here) After modifying the variable, restart the server to cause the new setting to take effect. While the mysql system schema ... Components provide expanded access to MySQL Enterprise Data Masking and De-Identification ...