Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
How Page Compression Works When a page is written, it is compressed using the specified compression algorithm. Writes to the tablespace that occur after setting the new compression algorithm use the new setting, but to apply the new compression ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-functions.html
The number passes the Luhn check (an algorithm that performs a checksum verification against a check digit). gen_blacklist(str, dictionary_name, replacement_dictionary_name) Replaces a term present in one dictionary with a term from a second ... The ...
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
unique_subquery This type replaces eq_ref for some IN subqueries of the following form: value IN (SELECT primary_key FROM single_table WHERE some_expr) unique_subquery is just an index lookup function that replaces the subquery completely for better ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html
The parser recognizes optimizer hint comments after the initial keyword of SELECT, UPDATE, INSERT, REPLACE, and DELETE statements. Table-Level Optimizer Hints Table-level hints affect: Use of the Block Nested-Loop (BNL) and Batched Key Access (BKA) ... One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 10.9.2, “Switchable ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
Note that the replacement variable authentication_policy is not set by MySQL Configurator. These variables are listed here, with their replacements in brackets: Com_slave_start (Com_replica_start); Com_slave_stop (Com_replica_stop); ...(Bug ...
https://dev.mysql.com/doc/refman/8.4/en/view-restrictions.html
Indexes can be used for views processed using the merge algorithm. However, a view that is processed with the temptable algorithm is unable to take advantage of indexes on its underlying tables (although indexes can be used during generation of the ... The maximum number of tables that can be referenced in the definition of a view is ...
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
mysql> SELECT X'616263', HEX('abc'), UNHEX(HEX('abc')); -> 'abc', 616263, 'abc' mysql> SELECT HEX(255), CONV(HEX(255),16,10); -> 'FF', 255 INSERT(str,pos,len,newstr) Returns the string str, with the substring beginning at position pos and len ...For ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-chat-details.html
The output looks similar to the following: | { "tables": [ { "table_name": "`demo_embeddings`", "schema_name": "`demo_db`" } ], "response": ""HeatWave AutoML uses a variety of machine learning algorithms, including decision trees, random forests, ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
WITH_LD also replaces the USE_LD_LLD CMake option that was removed in MySQL 8.3.0. The group_replication_allow_local_lower_version_join system variable is deprecated, and setting it causes a warning (ER_WARN_DEPRECATED_SYNTAX_NO_REPLACEMENT) to be ... This section summarizes what has been added to, deprecated in, changed, and removed from MySQL 8.4 since MySQL ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-22.html
(WL #14110) The new compression-algorithms connection option sets the order by which supported algorithms are negotiated and selected to send compressed data over X Protocol connections. The algorithms available are specified by the server and ...