Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-unexpected-replica-halt.html
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 halting. Updates to the applier metadata repository are committed ...This ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
When IGNORE—or LOCAL without REPLACE—is specified, data interpretation errors become warnings and the load operation continues, even if the SQL mode is restrictive. Interpretation of field values and assignment to table columns depends on these ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-parallel-table.html
When the server finishes processing the data it received, messages are returned showing the chunk that was being imported by each thread at the time, the percentage complete, and the number of records that were updated in the target table. In this ... MySQL Shell's parallel table import utility util.importTable() provides rapid data import to a MySQL relational table for large data ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-security-mysql-privileges.html
This includes all MySQL privilege types (SELECT privilege, UPDATE privilege, DELETE privilege, and so on) granted on the database, table, and column level. The only tables that would be safe from this sort of mayhem would be those tables that were ... In this section, we discuss how the MySQL privilege system works in relation to NDB Cluster and the implications of this for keeping an NDB Cluster ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-x-protocol-and-x-devapi.html
Default Value PREFERRED Since Version 8.0.20 xdevapi.compression-algorithms A comma-delimited list of compression algorithms, each one identified by its name and operating mode, (e.g. As an alternative to the default algorithm names, that contain a ...If the property is not set, the mechanism is chosen depending on the connection type: "PLAIN" is used for TLS connections and "SHA256_MEMORY" or "MYSQL41" is used for unencrypted ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-encoding.html
This topic contains the following sections: Run Auto Encoding Usage Notes Auto Encoding Examples What's Next Run Auto Encoding To enable Auto Encoding, specify the auto_enc option in recommend mode. This sequence allows data placement performance ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-x-protocol-and-x-devapi.html
Default Value PREFERRED Since Version 8.0.20 xdevapi.compression-algorithms A comma-delimited list of compression algorithms, each one identified by its name and operating mode, (e.g. As an alternative to the default algorithm names, that contain a ...If the property is not set, the mechanism is chosen depending on the connection type: "PLAIN" is used for TLS connections and "SHA256_MEMORY" or "MYSQL41" is used for unencrypted ...
https://dev.mysql.com/doc/refman/8.4/en/char.html
When CHAR values are retrieved, trailing spaces are removed unless the PAD_CHAR_TO_FULL_LENGTH SQL mode is enabled. If strict SQL mode is not enabled and you assign a value to a CHAR or VARCHAR column that exceeds the column's maximum length, the ...
https://dev.mysql.com/doc/refman/8.4/en/connecting-using-uri-or-key-value-pairs.html
The following options are available: ssl-mode: The desired security state for the connection. The following modes are permissible: DISABLED PREFERRED REQUIRED VERIFY_CA VERIFY_IDENTITY Important VERIFY_CA and VERIFY_IDENTITY are better choices than ... This section describes use of URI-like connection strings or key-value pairs to specify how to establish connections to the MySQL server, for clients such as MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-natural-language.html
By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text collection. MyISAM Limitation For very small tables, word distribution does not adequately reflect their ...A collection is a set of one or more columns included in a FULLTEXT ...