Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-snapshot-method.html
Assuming the above exceptions do not apply to your database, use the cold backup technique to obtain a reliable binary snapshot of InnoDB tables: do a slow shutdown of the MySQL Server, then copy the data files manually. If the source database ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-troubleshooting.html
After the errors are fixed, perform a slow shutdown (by setting innodb_fast_shutdown=0) before attempting the upgrade again. A schema mismatch in a MySQL 8.3 instance between the .frm file of a table and the InnoDB data dictionary can cause an ...
https://dev.mysql.com/doc/refman/8.4/en/windows-testing.html
In this case, start mysqld with the skip_name_resolve system variable enabled and use only localhost and IP addresses in the Host column of the MySQL grant tables. (Be sure that an account exists that specifies an IP address or you may not be able ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore-upgrade.html
Perform a slow shutdown of the MySQL Server you just started in the last step by issuing the SET GLOBAL innodb_fast_shutdown=0 statement and then shutting the server down. Important You may encounter technical challenges during a server upgrade or ...
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
Error number: 1037; Symbol: HW_ER_UNSUPPORTED_EXPR_IN_CORRELATED_SUBQUERIES Message: The expression, [%s], is not supported for correlated subqueries. Description: The specific functionality for correlated subqueries is absent in HeatWave. Error ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html
Changes to this variable affect execution of all subsequent queries; to affect one query differently from another, it is necessary to change optimizer_switch before each one. If subqueries subq1 and subq2 are converted to semijoins, tables t4@subq1 ... 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/heatwave/en/mys-hw-genai-rag.html
The ML_RAG routine runs retrieval-augmented generation which aims to generate more accurate responses for your queries. This topic contains the following sections: Before You Begin Retrieve Context and Generate Relevant Content Retrieve Context ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-byo-embedding-tables.html
To Run Batch Queries, add the natural-language queries to a column in a new or existing table. To use the name of an embedding model that is not available in MySQL HeatWave for running RAG, also add the vector embeddings of the input queries to a ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-byo-embedding-tables.html
For Running Batch Queries, add the natural-language queries to a column in a new or existing table. To use the name of an embedding model that is not available in GenAI for running RAG, also add the vector embeddings of the input queries to a column ... GenAI lets you use tables containing your own vector embedding to run retrieval-augmented generation (RAG) with vector ...
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
select_type Value JSON Name Meaning SIMPLE None Simple SELECT (not using UNION or subqueries) PRIMARY None Outermost SELECT UNION None Second or later SELECT statement in a UNION DEPENDENT UNION dependent (true) Second or later SELECT statement in a ... The EXPLAIN statement provides information about how MySQL executes ...