Search Results
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysqlsh.html
--compression-algorithms=value Command-Line Format --compression-algorithms=value Type Set Default Value uncompressed Valid Values zlib zstd uncompressed The permitted compression algorithms for connections to the server. --compression-level=level ... MySQL Shell is an advanced command-line client and code editor for ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-chat-details.html
The output looks similar to the following: | { "tables": [ { "table_name": "`demo_embeddings`", "schema_name": "`demo_db`" } ], "response": "\nThe output of the follow-up question is:\n| HeatWave AutoML uses a variety of machine learning algorithms, ... This topic describes how to view a chat session ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html
The remote cloning operation replaces the existing data dictionary on the joining member, but Group Replication checks and does not proceed if the joining member has additional transactions that are not present on the other group members, because ...
https://dev.mysql.com/doc/refman/8.4/en/connection-options.html
ssl-session-data-continue-on-failed-reuse Command-Line Format --ssl-session-data-continue-on-failed-reuse Type Boolean Default Value OFF Controls whether a new connection is started to replace an attempted connection that tried but failed to reuse ... This section describes options supported by most MySQL client programs that control how client programs establish connections to the server, whether connections are encrypted, and whether connections are ...
https://dev.mysql.com/doc/refman/8.4/en/nested-join-optimization.html
More exactly, a variation of the nested-loop join algorithm is exploited. Recall the algorithm by which the nested-loop join executes a query (see Section 10.2.1.7, “Nested-Loop Join Algorithms”). The following discussion refers to the join ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-functions.html
mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' characters. mask_iban(str [, mask_char]) Masks an International Bank Account Number (IBAN) and returns ...Nine digits grouped in pattern: xxx-xxx-xxx ('-' is any separator ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-summarize-content.html
Summarizing Content To summarize text, perform the following steps: To define the text that you want to summarize, set the @text variable: mysql> SET @text="TextToSummarize"; Replace TextToSummarize with the text that you want to summarize. Machine ... The following sections in this topic describe how to summarize exiting content using the GenAI: Before You Begin Summarizing Content Running Batch Queries What's Next Before You Begin Review the GenAI requirements and ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-tablespace-encryption.html
What are the encryption algorithms used with InnoDB data-at-rest encryption? A.17.4. Is it possible to use 3rd party encryption algorithms in place of the one provided by the InnoDB data-at-rest encryption feature? A.17.5. What are the encryption ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
The data-at-rest encryption feature supports the Advanced Encryption Standard (AES) block-based encryption algorithm. Tables residing in file-per-table tablespaces are rebuilt using the COPY algorithm. The INPLACE algorithm is used when altering the ... InnoDB supports data-at-rest encryption for file-per-table tablespaces, general tablespaces, the mysql system tablespace, redo logs, and undo ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-performance.html
Online DDL and Metadata Locks Online DDL operations can be viewed as having three phases: Phase 1: Initialization In the initialization phase, the server determines how much concurrency is permitted during the operation, taking into account storage ... Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in ...